Mac Forum / Applications / Excel / August 2005

I just reloaded Office 2004 on a MacG4.  When I copy an Excel formulae
- for example from cell C4 to cell D4.....it does not give me the total
for Column D4....instead the same number as shown in C4 appears.  If I
go to the formulae bar and reenter any part of the equation for cell

Hi Folks!!
Happy Saturday! :)
I have created a basic invoice form in Excel 2004 and I was wondering
if there's any way (a script or anything) that'll cause the invoice to

I have created a large number of VBA macros and saved them as an
add-in.  When I load the add-in in a sheet none of the macros show up
under the macro listing.  I would like to be able to assign an add-in
macro to a button on my sheet or at least be able to run the macro.

I have a complex and large (4.4MB) workbook I am editing in Excel 2004
for Mac, v11.1 (040909), using OS X v10.4.2 on a powerbook 1.5GHz, 1GB
DDR SDRAM.
The auditing toolbar is behaving eratically. On the same, unprotected

I am struggling with this.
I have a workbook that carries out calculations based on user's input data.
Part of these calculation involve lookups from static data sets that the
user selects from a combobox look up form object

Okay, this is difficult to explain, but I'll try.  I'm attempting to
get the titles at the top of my worksheet to "show" when I scroll down.
What I did was the following:
File, Page Setup, Sheet

I've recently been unable to use worksheets made on a PC with the
Macintosh version of Excel (2001 at home, v.X at the office). Not only
don't the buttons work (which I believe is an Active-X problem from
searching here), but none of the macros work when I activate them

Currently I am building a form  with a list of buttons on it. I use the
standard tools to create a button and then save it. When I close VB editor
and run my form the buttons have disappeared. I am quite uncertain as to
what the cause of this is? Does anyone know the cause?

I've used Excel in Windows for several years. For my job, I spend much of my
time in excel. At this point, I cannot work with a mouse since it slows me
down too much, and I rely solely on keyboard shortcuts.
I'm very interested in switching to Mac over Windows, but am worried that ...

Since installing Office 2004 (updated to 11.1.1 - 050201) on Dual 2.7
GHz PowerPC G5 under MacOS 10.4.2, Excel has been letting me down as
follows:
1) One of my frequently-used keyboard shortcut is Shft+Ctrl+8 (formerly

August 11, 2005
Yikes...
We have both PC and MAC machines in the lab....we created some pivot
tables on the PC Excel version (vintage 2002), along with linked charts

Is it possible, in Excel 2004, to produce a list such that the entries
within that list contain lists for some fields?
An example of the format which I wish to create would be a list of the
customers of a computer repair shop with a small history of the

As a newly self-employed plumber I need to keep lists of
materials/stock so that I can a) keep a track of what I keep on the
shelf ready to use, b) know when to reorder c) can print off easy to
issue estimates based on what materials I will need to complete a job.

I'm trying to open a mid-sized (1.8M) Excel spreadsheet.  I have Office
2004 and Mac OSX 10.4.  I'm getting one of two results: 1) a "Not
Enough Memory" error message, after which Excel opens with a blank
spreadsheet; 2) the process hangs up and I have to Force Quit Excel.

I want to change the default margins for each workbook that I create.
That is, I don't want to have to go and change the margins each time I
create a new workbook;   I want the workbook to open with those changed
margins.   How do I do this?   And while we're at it, how can I change