Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula related Crash on Opening File
I have a Spreadsheet that "crashes" on opening, I am trying to understand why and if I can avoid creating similar problems in the futute. It is has quite a few Sumproduct, Sumif & Vlookup formulas. But does not refer to other files, all data is in this file. file is ~20 MB When I turn to manual calsc and do not "calc" on save I am able to call the file up. I think the problem may be formula related. Also If I "range Value: the file there is no issue on opening. Are there any guideline or utilities to tell you when you are reaching "boundaries in Excel I am on XP, Excel 2002 SP-2. Any thoughts would be appeciated. ..Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with opening an Excel - File | Excel Worksheet Functions | |||
Opening a file in a macro (network) | Excel Discussion (Misc queries) | |||
Opening a file with code without a set file name | Excel Discussion (Misc queries) | |||
opening file problem please help | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions |