Mac Forum / Applications / Excel / August 2005

Is there a program or method to merge multiple Excel files,  I get
about 14 sales reports each month , each with the same header layout
data, and would like an easy method to merge them into one spreadsheet.
I would like ot do this without copying and pasting from each file to

I use Office for Mac 2004. Ever since i installed it I keep the
Formatting Pallette visible. Now for some reason the pallette has
minimized off the bottom of my screen. I click the Formatting Pallette
icon in my menu bar and the pallette (genie effect) retracts back into

Recently, I had a colleague help write a macro in Visual Basic in Excel
on a Windows PC.  The Macro runs fine in Excel running on a PC, however
it crashes in Excel on my Mac and gives the error:  "Complile Error:
Sub or Function not defined".  I am running the latest version of ...

I need to calculate each of the individual cells in one column of my
worksheet. It is important that the I do not calculate the whole sheet
or workbook when I do  this, just the individual cells. I know how to
do each cell individually (double clicking on the cell and pressing

I recently bought a newer iBook to rum OS X and Microsoft 2004 Office.
I have been using the original clamshell iBook running OS 9.2.2 and
Excel 4.0 (circa 1992).
The 2004 Excel does not recognize my Excel 4.0 spreadsheets. Is there

Product: Microsoft Excel for Mac 2004 (v. 11.1)
Problem: Although "fill down" and "fill right" work as expected in most
spreadsheets, I have been working in one recently where they don't. For
example, I have a column (call it A) with about 120 rows of names. In

A coworker sent me an Excel file that she¹d created in Office 2001. She
recently upgraded to Office 2004 but then began having problems opening one
of her original files. Excel recognizes it as an Excel doc (double-click on
file and Excel opens) but it won¹t actually open the file ­ ...

I have an imported a PC Excel workbook containing 53 sheets, one for each
week.  Each sheet is a copy of the sheet #1.  The sheets that have been
imported act normally.  That is, they contain data as originally entered on
the PC. But when I add new info to a cell, the info is ...

In Excel (Office 2004) version 11.1.1 the ROUND function in a formula
works on the screen but not in print preview or when printed.  Any help?

I am trying to find versions each of the products of Office for Mac.
Like the versions of the following :
Office 98 for Macintosh
Microsoft Excel 98 for Macintosh

I have sorted a database and analyzed a subset of records to calculate
average values.  I want to save these averages on another spreadsheet
in the workbook.  How do I paste the numbers without pasting the cell
references?  I need to resort the database to do other calculations.

Does anyone know the formula to count cells with text in them (as
opposed to x's)? Please help! Thanks!

I am recovering an iMac DV from a disk crash.
It has a new hard drive, new OS X and Office:mac 2004 installations,
with all patches and updates:
iMac DV 256 MB, 30 GB, Mac OS X 10.4.2, Office:mac 2004

Can anybody give me a hint how I can force Excel to open a specific template
when I hit 'New Workbook' in the File drop down window. I have populated the
Excel Startup folder with my modified template and two other folders and
find these listed in the Project Galery but would like ...

I need to add a trendline to my plot of sinusoidal data, but Excel only
gives 6 options (linear, logarithmic, polynomial, power, exponential,
and moving average).  Does anyone know of a plugin, preferably free,
that lets one add a Sine trendline?