Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can't open workbook (in Excel 2000)
Normally, the Status bar displays about 20 blue squares during the "OPEN"
operation. After the last blue square is displayed, the workbook appears in the "Worksheet Area". However, when opening a particular workbook, the "OPEN" process stops after the 19th blue square is displayed. (The Windows Task Manager shows the "Status" of Microsoft Excel is "Not responding"). Why isn't the workbook opening? |
#2
|
|||
|
|||
More Info: In the workbook, all of the cells in many columns contained
a formula which divided the value in the adjoining cell by 2. I then used Replace to change all of the formulas: from cell/2 to cell/100 Because there were so many formulas, I got an "Continue without Undo?" box and I replied "OK". Then, I got an "Out of Memory" error-message and then a "Cannot display results" error-message. I then saved the workbook. Would this have caused the problem with opening the workbook? Is there a way to open the workbook without having the formulas to be recalculated? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
Is there a way to make Excel 2000 open a new worksheet in a new w. | Excel Discussion (Misc queries) | |||
Excel 2000 running on Windows XP SP2 does not properly open CSV fi | Excel Discussion (Misc queries) | |||
How do I open Excel 4.0 files in Office 2000? | Excel Discussion (Misc queries) |