Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem Opening an Excel File MSO9.DLL Error | Links and Linking in Excel | |||
Problem Opening an Excel File MSO9.DLL Error | Links and Linking in Excel | |||
Problem Editing Macro in Shared Excel File | Excel Discussion (Misc queries) | |||
My excel file is too large (5 mb) when it shouldn't be, why? | Excel Discussion (Misc queries) | |||
Locating a file in excel with a partial file name. | Excel Discussion (Misc queries) |