Mac Forum / Applications / Excel / March 2009

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)
Processor: Intel
I am trying to make a new line chart and I am having trouble getting the data to start at 0, 0. For Example I have a data point that when the x-value is 0 the y-value is 532. What I am getting on the chart is a ...

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC
I have a large volume of OCR'd text in a column that needs to be copied by block and pasted special to transpose the text to horizontal row. Is there a way to create a shortcut key? I can create a Paste ...

Version: 2004
Operating System: Mac OS X 10.4 (Tiger)
Processor: Intel
When I try to open a file, I get a message in a box titled Graphics Filter. The message is "Converting: Metafile. It continues into a never ending loop.

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
Because of a suspicious corruption bug in a spreadsheet with a pivot table, I decided to try to separate my data from my analysis and presentation of it in pivot tables. That is, I'm trying to keep just data in ...

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
Hello, With my old Excel program, I just had to click on the Sigma (sum) sign and everything added. With the new Office 2008, adding numbers has become very complicated, in fact, impossible. A blue frame is ...

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
I have the problem noted by Dan Brotsky on 30 Sept last year see <http://www.officeformac.com/ProductForums/Excel/2785>

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
In Excel 2004, we had Chart Options which, IIRC, could be used to hide/show a legend. That seems to be missing in Excel 2008. I have deleted a legend and would like to get it back!

MAC Powerbook G4, OS 10.5.6, Office 2004, Excel 2004, Version 11.5.3
I accidentally dragged the formula bar up into the standard toolbar and it
(the formula bar) disappeared. I can't get it back. I've tried
MENU: VIEW: FOMULA BAR: CHECK , then UNCHECK  then CHECK.

Version: v.X
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC
I need to deactivate ALL the hyperlinks on an Excel file, and keep them from reactivating when I add new email addresses on the spreadsheet.

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
How do I restore a custom toolbar I made after having to reinstall Office after a system reinstallation?

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
Just did a speed test of Excel on Bootcamp vs. Mac Excel 2008. I setup 12,000 rows of data in one excel worksheet, and 12,000 rows of data in another spreadsheet. Then used vlookup to match the two files ...

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Using the IRR formula is coming back with a num error message. I know on a PC that add-ins have to be activated to use this, but there is nothing in the add-ins part of the menu. Does anyone know what I'm doing wrong?
Thank you ...

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
read all the problems with Excel for mac its sounds like a nightmare run my business on excel spread sheets its took me years to develop a work book to this day i use data validation and sum if i have ordered ...

I originally posted this in microsoft.public.excel.misc
I have a workbook with only one sheet. I want to use a macro to change the
name of that sheet to "QIF" and its color to RED and add a second worksheet
with "IIF" name and color Yellow.

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
HI