Mac Forum / Applications / Excel / May 2006

I am a new Excel user who was asked to do the inventory for my company.
The same template file was set up on 4 different computers and all the
data was entered. All the worksheets have the same headings. I would
like to merge all the data into one worksheet which would then contain

I would like to create a Macro that runs automatically when I first
open an Excel spreadsheet.  The Macro can reside on either the primary
spreadsheet, or on a secondary one.  The Macro will actually open a
second spreadsheet that contains additional Macros for use on the

When you elect to install Excel's Solver add-in on a Windows PC, the example
file "SolvSamp.xls" is also automatically copied from the installation CD to
the hard drive.
When I installed Mac Office and specifically the Solver add-in on a Mac, the

Can¹t say I¹ve ever had this happen before.  I could swear there was an
insert menu item in excel yesterday.  Gone today.  I¹m a long time Excel
user, just switched to Mac Excel. Any Help appreciated.

   I use office 2003 on a HP laptop. I must have clicked something, I
don't know but my keyboard doesn't respond to excel. It works well with
other applications. The mouse clicks also don't respond, but i can drag
my mouse. I have tried restarting excel but that also doesn't work.

I need a quick reference card that shows items like shortcut keys for
commands, navigation, formatting data, etc.  I don't need a "How To" book or
manual, just the reference guide.  Does anyone know where I can purchase
these?

Suppose A1:K1 contain numbers. I want the mean of the 3 highest numbers
in the range. Is there a way to get a formula to do that? If not, VBA?
Thanks in advance.

I assigned a shortcut for 'Paste special' which worked fine for a while,
then all of a sudden it stopped working. I am coping data between two
formatted sheets so need to be able to 'paste values'. If I can't use a
shortcut to get to the 'paste special' function this is a real long ...

Excel 4.0 quits whenever I click in the top menu. Is there a fix or
workaround?
I have lots of charts that need cleanup when opened in Excel 2004 and
I'd like to use 4.0 till the cleanup is done.

I've got a very simple web query running via an external text file.
The query has been assigned to run in one particular cell, say C33, but
the operation seems to have grabbed the cell below it as well, C44. The
trouble is I'm trying to run another Web Query from C44 but its entry