| 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 | |||
Linear Mode
