Mac Forum / Applications / Excel / May 2008

How do I get at the data range for the x-axis in Excel 2008.  I can see where
to change y-axis data, but not x-axis.
I'm coming from Excel 2000 for Windows where I could get to all of my data
from the Chart:Source Data box.

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel
Can't seem to open a file that began its life as raw data in Excel (PC) '07, was worked on (created pivot tables and charts) on Excel '08 for Mac and now can't be shared with colleagues in MS Office '07.

It looks like Excel is hard-wired to accept dates input as M/D/Y, which is the American format. Here in Canada (as in the rest of the world), we write D/M/Y. I can't find anything to change this in Preferences, and Excel is apparently not picking up the system date settings from ...

I am creating a worksheet in Microsoft Excel 2004 for Mac that uses
the eomonth() and networkdays() functions from the Analysis Toolpak
add-in.  I have had no issues with the worksheet until suddenly last
week as I opened it, Excel told me that there were links to other

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)
Processor: intel
I have imported data into Excel that creates a row of data. I would prefer that the data be in a column instead of a row. How can I turn a row into a column.? I can't use PivotTable because I have only one row ...

I use 2003 word and excel; in doing a mail merge using excel spreadsheet as
the data source, I merged vacation and PTO accruals and totals into word
table and have tried to format the cells as general, text, custom and it
still brings over about 8 numbers after the decimal and ...

row containing several numerical values
I'd like to conditionally format the row such that the maximum value is
automatically formatted.
"formula is"    "=max(1B:1P)"

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel
Could-it be possible the maximum text length is now limited in a text cell.

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel
When opening a set of excel spreadsheets created on a pc, I am getting a "Cannot open Template Wizard" dialog with only an OK button. Once I click it, I can get to the file. I'm not sure what is causing this ...

I have a large data set of values that has a zero'th value (values
contained in a C-array). In previous versions of Excel, I seem to
remember being able to set the x-axis numeric values to start at 0,
and incrememt every so-and-so much. Now, with Excel 2008, I can't seem

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel
My Excel problem in that a correct formula to multiply two cells will not recalculate at all when a quantity value changes. If I erase the formula and put the same formula back into the cell it will recalculate ...

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel
When I enter a number in a cell it enters as 1/100th of the value entered. For instance if I type in 10000 and hit enter, 100 shows up in the cell

I have office 2008. In excel the l/r arrow keys do not move one cell over. How can I change that?

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel
I'm sure its easy once I get to understand the logic of the new chart system, but I want my X-axis labels for my line chart to be at a 45-degree angle to the axis. This used to be easy, but I can't find it ...

I recently upgraded to Office 2008. Running the latest version of Leopard. When ever I try to save an Excel file. I get the following message(s):
'Expenditures08,xls' could not be found. Check the spelling of the file name, and verify that the file location is correct. If you are ...