Mac Forum / Applications / Excel / July 2008

I have installed Office 2007 Win and Office 2008 Mac
I created a Pivot Table in Win
I opened the file (xlsx) on Excel/Mac: a message popped up, saying
thet there will be losses in the functionality of the pivot tabel, and

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
I'm importing data by cutting and pasting from a database, but when I paste it fills down rather than across. I need my data to go across rows so that I can export it to a database program. Is there a way to ...

I have a spreadsheet with a date mm/dd/yyyy.
I need to divide that date into three distinct columns - one for year, one
for month, and one for day.
Is there a formula or formulas that I can use to take the data in the

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)
Processor: intel
I need help finding the calculator tool. It used to be docked as part of the formula tool bar in office 2004. I did find it under, I think, Tools, or View.....only once. I was able to select it and use it, but ...

I seem to have Scroll Lock on, and cant work out how to turn it off.
Running MS Excell 2004, a green light is on next to SCRL at the bottom of
the page, and the arrow keys scroll the screen instead of moving between
cells. On a PC (sorry, recent convert from the darkside), there's ...

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel
I'm running 12.1.1 of Excel on a MacBook Pro. Today when I created a graph on sheet two (moved it from sheet 1) and then copied the graph and tried to paste it into Word (2008 for mac 12.1.1) Excel crashed. The ...

Does Microsoft have some sort of usage guidelines for working with
pivot tables?  Or maybe a list of "Do's and Don'ts" ??
I've already had excel crash at least 3 times while I'm dealing with
pivot tables, and the crash generally occurs when i click "save"

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
... and get back to 2004?

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel
I can't seem to open some of the files that I created in office 2004. It's been suggested that I probably have "illegal" characters in my sheet names. Does anyone know how to change them without being able to ...

Dear;
I have a table in excel 2007. this table consist of the following coloms:
Task Name             Start Date      End Date     Status
contact Vendor A     10-Jul-08       19-Jul-08    in-Progress

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel
Greetings!

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel
I am trying to do an XY scatter plot and label each point with the name of the point, rather than the X or Y value, which is what happens if i select "add data label". There used to be an add-in called XY chart ...

Is there anything available for inserting dynamic stock quotes in Excel - other Excel versions had msn.quote. Thanks.

I have EXCEL 2003 SP3.  
Whenever I open an existing Excel spreadsheet, Excel automatically adds a 1
to the end.  Then when I do a simple "save" it defaults back to "my
documents" instead of the original loacation of the file. Then I have to

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)
Processor: intel
Is Microsoft going to restore the Snap-To-Grid feature back to Excel? I know about holding down the Comand Key but I wish the old feature was back.