Mac Forum / Applications / Excel / June 2005

In an attempt to PDF a workbook in Excel, I encounter the following problem:
The user is prompted to save the workbook with one file name.
If the workbook contains multiple pages, then each worksheet is outputted
as a PDF, but each of them to the same file name. Thus, the final ...

I have a worksheet that has sign-in data for people working one of 5
shifts every day - I download information from a database and paste it
into the sheet and it calculates hours worked for each shift, puts them
into columns for each person, and sums hours for different shifts that

Running Excel 98 under OS 9.2.2 on a beige G3 with 352 MB Built-in memory.
I want to highlight the Saturdays and Sundays in a column of cells
containing dates named (creatively) "Dates"  and, based on messages in the
Group's Google Archive, I've tried "Formula is WEEKDAY(Dates,1) = ...

I have pricing sheets that have been created in Excel.  We are
increasing our pricing and I need to increase all the prices in the
worksheet by 7 percent.  Does anyone have a suggestion as to how to do
this to the entire sheet at once instead of individually?  Thanks in

I installed Excel having my keyboard set to Spanish and now the default
currency and number formatting uses dot as thousands separator and
comma(,) as decimal. I have tried to change it, because I need to use
dot(.) as decimal and comma(,) as thousands separator.

Every other day or so, the Recently Used File List in Excel 2004 becomes
empty. This problem does not seem to occur in Word 2004.
I've tried trashing the Excel preferences (com.microsoft.Excel.prefs.plist &
com.microsoft.Excel.plist), but that hasn't solved the problem.

Everything was going great, but all sudden, new folder or new workbook not
working, bring up a default.  So I have personal macro workbook, can't
remember what this is for
I have two workbook in startup folder, no extension.

I am using Excel 2004 for Mac and need help on drop lists. I want to change
the drop list depending on the previous choice. Lets say in the first list I
give the choice between 3 options (jumper, pigtail or duplex). Depending on
the choice taken, there would be another drop list ...

I am trying to add number of days, INCLUDING HOLIDAYS, to a date to get
a second date. However, the date formula in Excle always exclude
holidays. Is there any way I can make the calculate to include holidays
???

I'm trying to create a macro for the following situation:
1) I have 10 spreadsheets open simultaneously (all separate files - each
with one sheet)
2) For one of the spreadsheets, I would like to copy all the other files and

Can't get a large worksheet to open. Have downloaded updates,
restarted, still starts to open, then a little over halfway on the
progress bar, it crashes. Impt file I need to access. Help!

I have been working extensively on excel 2000/windows 2000 and recently
bought myself a powerbook with office 2004 for mac.  My problem is that
when I try to open a excel file created in windows on my mac excel but
it pops out for a file called "ATPVBAEN.XLA".  Think that's because

I am concatenating cells together and including &", "& between to provide a
comma and a space between pieces of info
Some of the cells contain data derived from further cells, although some may
be empty

I have a VB program I've written on Windows that essentially starts
Excel, then creates various Worksheets and populates them with data,
does some cell formatting, etc. Keep in mind, this is not a Macro that
is launched from within Excel this is a standalone executable. I

Mac OS X 10.4.1 with all software updates applied, MS Office 2004 with
all software updates supplied.
When launching Excel in my account, I get the following error dialog:
"An unexpected error occurred while trying to load the Microsoft