"Sean Timmons" wrote in message
...
the calcs will take as long as they take... if the formulas are to
external
workbooks, ensure they are open when you go to save.

Perhaps it's a matter of either separating these 15 tabs into several
workbooks or finding ways to use less formulas....

"ColleenK" wrote:

I post this before and implemented the suggestions, to no avail, so I am
asking for further ideas.

This is Excel 2003 and I have a workbook with 15 tabs, each tab consists
of
the following formulas: sumif, sumproduct, vlookup and embedded if
statements. This takes about 10 minutes to calculate and when I hit
"save
as", I generally have to wait 15-20 minutes. My PC is a 200 GHz maching
with
1 GB of Ram, does anyone have any suggestions as to how I can speed up
the
calculations?
--
CK

CK wrote <<Perhaps it's a matter of either separating these 15 tabs into
several workbooks A downside of this is that any structural changes in a
workbook will not be referred to correctly in another workbook and any
recalculation will be incorrect. Move just one cell and everything could go
to pot!

Bill Ridgeway.