CLR wrote:
that did the trick.......kind of aggravating to have to do that, but it did
solve the "save-time" problem.

Thank you muchly kind Sir........

Vaya con Dios,
Chuck, CABGx3

--------------------------

You're quite welcome. There's one other trick that I use which may or may not
apply to your case. My large files are typically lots of sheets deep. Each
sheet has a large block of data and then appended off to the right are several
columns of involved, ugly calculations based on that data -- and some data from
a couple of other sheets. Once it's calculated though, it never really changes
again for that sheet.

In this case, once the sheet is calculated I copy the sheet and then paste it
back onto itself using PasteSpecialValues. This gets rid of a thousand long
formulas and replaces them with the simple numbers that they evaluated to. Only
the most recent few sheets are left in their full formulaic glory. Doing this
makes the file much smaller to store, and much faster to calculate if a full
recalc is done.

Good luck...

Bill