Updating Problem with Large Excel File
Dear ALL,
I am currently working on a excel workbook which has reached 284 sheets and
is approx. 34MB in size.
The problem I am having is that sheets which have formulas between them are
not always updating. I Have the automatic calculation settings o.k etc so i
do not think it is that.
If i eneter a new formula that formula works but to get old formulas to work
I need to refresh the data i.e. copy paste the formula again for the old
formulas to update any changes from new data entered.
This creates a problem of that I can not trust the data derived from the
workbook as it would take days to check if all the relevant formulas have
updated automativcally or not.
Is there a limit to the number of calculations a work book can do ?
--
Thanks,
TKA
|