Mac Forum / Applications / Excel / September 2007

I'm using Excel for Mac 2004 V11.3.3
I've created a pivot table, which when refreshed on my PC works fine.
However, if I refresh it on my Mac I lose all the formating. I found
the support article 162028 on the Microsoft web site, which suggests

I have been trying to splice together various pieces of VBA code off
the web for this problem, but it always seems that there's some PC-
unique element that throws me off (ie: .dll file requirements).  So
hopefully you can help this poor Mac user.

I have a MacBook running OS 10.4.10 and I also have Office for Mac
2004, version 11.3.7.  I have downloaded all the Mac updates and I
also have updates from Microsoft for Office for Mac, 11.3.5, 11.3.6
and 11.3.7.  The problem is that whenever I am on the internet and I

I'm running the 2004 version of Excel on a brand new PowerBook (Mac OS
X 10.4.10).  I'm frustrated because the SAVE AS function appears to
default to a silly location - logically, when you hit SAVE AS, you
would expect that it would default to saving the new file into the

I have some plain text in a cell that I would like to link to a
picture. The picture resides on my hard drive. How best to do that?
-Paul

How do I set the security to medium in 2007 excel so folks can chose to
enable macros?

Some time ago, the great folks here helped me with some code to
automatically resize worksheets to fit the screen.  I retained the code that
re-sizes sheets when the user moves from one sheet to another, but I can't
find the code that will automatically re-size the first sheet upon ...

I've been playing with conditional formatting and it's not
accomplishing my task. That is, to apply a gray color band to
alternating groups similar rows in a large excel file. For example, if
all other data in the rows were different, and column E had similar

On a form I have a refedit control wich is then used to set a range variable
for further processing:
  Dim s As String
  Dim rng as Range

Over the Labor Day weekend, I copied an IF formula from my father's
Windows woksheet, but this formula is not working on my Mac.
Here is the formula: if(K6>L4,(.15*(min(K6,M4)-L4),0)
K6 = $20,000

is it possible to tansfer an excel file to ms project??
regards

After invoking the AutoFilter command for a column, I would like to reveal
and select the choices using the keyboard. Does anyone know if this is
possible? I've assigned a keyboard command to the Data > Filter > AutoFilter
command, but, instead of having to use the mouse to click ...

Hi all, using xl 2004 version 11.3.5
Have spent many hours trying to work this out but to no avail.
Question is: How do I get a return value of cell count for for a selection
that has no known parameters? If I know either the number of columns

This problem has been reported elsewherefor Excel v X, but none of the
recommendations there work for me on Excel 2004.
Basically, after several years of using the program, I get this
message on launch...

For better or worse I'll often have at least temporary links from one
workbook to bring in data from another workbook (by VLOOKUP or just a
direct reference). Later on I'll often "freeze" the data in the new
worksheet by doing a COPY and PASTE VALUES; but sometimes I totally