Mac Forum / Applications / Excel / May 2006

The speed with which answers are provided here is amazing but I posted this
a week ago and I hoped to hear by now! Or haven't I made the problem clear?
Following a problem with my G4 I reinitialised it and loaded OS 10.3.9 and
Office 2004 and everything else from scratch

We have been experiencing a strange bug on saving excel files.  Instead of
saving to the files current name it saves to a randomly generated
number/letter combo.  Note this does not happen all the time and sheets
saved the network seem to be unaffected.

I need to update a spreadsheet on a monthly basis.  Since rows are added
often the formulas in future months tend to miss some rows.
To correct this I select the entire column from the previous month and
choose the new column to paste the formulas only.  The formulas do paste but

I have a client who I just changed over from OS 9 to several Intel Duo
Mac-mini's runing Tiger.
They have a problem where Excel crashes on quit. A user quits Excel but
the menu doesn't go away and won't respond. This is Office 2004 with

I'm familiar with
For Each w In Worksheets
  ...do something...
Next w

Hi, I am trying to use autoformat in excel for mac 2004 and I will
select a format like accounting1 - the sample shows but excel doesn't
format it correctly. It seems to only format the simple correctly. The
others will be missing a vertical line or a double line or all will be

In excel 2004 for mac, once you are in help, how do you quit it?

Having difficulty setting up a formula & i cant find any way of doing this!  
If anyone can help me out it would be great.
Basically i would like to make a formula that only comes into effect if the
number in any given cell is between two amounts.

Hi everyone! my problem is when a cell is inadvertently moved or
deleted in a spreadsheet, that cell reference is no longer valid and
the formulas that reference it, and all that follow, return error
values. All the formulas are protected and hidden, and the input cells

I'm trying to use an advanced filter in Excel 2004. In the example below are
the three ranges: first the criteria range, second the data, third the
extract range. Originally this "test" worked correctly -- the only record
appearing in the extract range was no. 4, which matches ...

Is there some way to set, or limit,  the number of columns and rows
that I want for a spreadsheet.
Thanks,
Doug

I have created a Word document using Office for Mac 2004 v.11.2.3.  This
report contains an inserted graph from an Excel spreadsheet.  However, it is
cut off when you view the graph in the Word file.  If I open it with Office
2003 on my PC it displays just fine so I know the file is ...

Does Excel have the ability to calculate the actual number of  days
between 2 dates similar to the way AppleWorks does. In apple works if I
enter 2 dates such as May 12, 2006 and June 22, 2006 I can enter the
formula "=A2-A1" and it gives me the number of days between those 2

I picked up a copy of Excel and am trying to convert some AppleWorks
formula. As per previous question it does indeed allow you to calculate
the number of days between dates.
I am using an 'IF' statement. I have this forumla:

I have a problem with Excel file corruption. I have a data list in an Excel
2004 file running under OS X 10.4.6.  It currently contains 15 records each
having about 120 fields. We open a Word 2004 template containing merge
fields in the usual format: { MERGEFIELD Field_Name }, for ...