Mac Forum / Applications / Excel / January 2006

Hello.  I'm a Windows Excel (Excel 2003) user, but am asking a Mac
Excel question on behalf of a friend.  He saved an Excel file as a
tab-delimited text file, but it did not properly retain the date
format.  When I (the PC-user) save an Excel file that has a column of

With the previous version of Excel the cell value would show the
interim value during loop-driven calculations.  I found this very
useful to be able to see that things were actually happening and to
monitor the progress of calculations.

We are experiencing slow vlookups on files larger then 1mb (5+ minutes)
and also it takes longer then it should to start and close excel.
Also, I was wondering about running office updates on just an excel
install.  Can you do this?  Will it just install the components it

The posting below 10 days ago in the microsoft.public.excel group has not
produced a response ­ perhaps the answer is much the same in the Mac world,
which I personally prefer and use mostly ­ can you help please:
Are the toolbar commands listed on the net with their button images ...

Is it possible to open PC based SuperCalc files in Excel on a Mac?  I
no longer have a PC, but have back-ups of all my old files.  Any help
would be greatly appreciated.

I have a list of test results, one row for each participant. (Each result is
in a seperate column)
I need to make a graph of all of their results when I click on their names.
Obvously I cannot create a graph for each one, as there could be hundreds of

I have a list of test results, one row for each participant. (Each result is
in a seperate column)
I need to make a graph of all of their results when I click on their names.
Obvously I cannot create a graph for each one, as there could be hundreds of

Office 2004 VBA
On opening only Standard toolbar is in view ­ I have not found how to
default to all toolbars on view
Better still, how about a custom toolbar with only the buttons I normally

Just installed Office 2004 on my MAC G4 running OS 10.4.4
No matter what I do, I can't format numbers into currency, or for that
matter, any other format.
Am very familiar with Excel, but this stumps me.

I developed Excel VBA programs on PC and ... usually they don't work on
MAC!! (Last example, I had an "Error 3209 - error defined by the Application
or the Object").
I would appreciate if somebody could give me the address of a site giving

I am new to applescript but have managed to write a droplet that takes
all excel files, strips away all unneeded data and saves the results. I
have created a second script that creates a graph in an app called
Chartsmith. To join these two scripts together I need  to save the

I've created a multi-worksheet Excel workbook to track statistics for a
favorite family game. Unfortunately, over the years, I've used so many
different fonts that now most often when I try to change an old font, I
get something like this message:

I'm submitting a large worksheet to client, and would like to color code
contiguous rows, to show that these rows are of a similar nature. Is there a
way to highlight these rows with color?  Any ideas appreciated. Thanks.
Kevs

Command-F brings up "Find" in Excel for Mac. The "Find Next" button is
highlighted. Is there a keystroke that one can invoke to highlight the
"Close" button? I find it quite inconvenient to have to grab the mouse to
push the "Close" button.

All,
(I've looked though the archive and not found anything quite like
this).
I have a large spreadsheet that contains what is essentially a