Can't open workbook (in Excel 2000)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?
 
If you open excel first and turn calculation to manual:
tools|option|calculation tab

you might have more luck (or maybe not???)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How2 set a shared workbook to always open a certain window size? 1
Lost the blue title bar on top of Excel 2003 workbook 5
Excel MS Excel in Win 10 3
Opening multiple workbooks in Excel 3
Sharing workbooks limitations - Merged Cells 12
Excel 2007 Workbook Not Visible 1
Cannot open one particula worksheet within a workbook 2
Close form automatically upon opening workbook 2

Back
Top