Book 32

Q45 · Apr 9th, 2002, 10:03 AM

I am trying to open a large Excel file (6 Megs) and I keep getting a Dr. Watson Excel shutdown message. I noticed that when I launch excel it opens up with a new Book number everytime I try to launch the file. I'm now on Book32.xls. Do you know how I can shut-down all these and start over with Book1.xls? I think that's my problem. Thank you!

Jack in the UK · Apr 9th, 2002, 01:18 PM

Hi

Firts thing save and cold boot, (Cold boot is shut down have a coffee and re boot after 2 minutes)

This allowes windows to drop from memory and any dirt it might be holding

then try post results and il look again.

EdE · Apr 9th, 2002, 01:36 PM

If you have pivot tables and/or links in your 6 meg file, try this. When you open, dont update links and after file starts to load, hit the escape key until the file finally loads. I have several large excel files (11mb to 22mb) that occasionally encounter this error. It is a pivottable access thing. If you have pivottables, you will need to rebuild, unfortunately. This always fixes the problem for me.

Apr 9th, 2002, 01:18 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Hi Firts thing save and cold boot, (Cold boot is shut down have a coffee and re boot after 2 minutes) This allowes windows to drop from memory and any dirt it might be holding then try post results and il look again. __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 9th, 2002, 10:03 AM	#1
Q45 New Member Join Date: Feb 2002 Posts: 32	I am trying to open a large Excel file (6 Megs) and I keep getting a Dr. Watson Excel shutdown message. I noticed that when I launch excel it opens up with a new Book number everytime I try to launch the file. I'm now on Book32.xls. Do you know how I can shut-down all these and start over with Book1.xls? I think that's my problem. Thank you!

Apr 9th, 2002, 01:36 PM	#3
EdE Board Regular Join Date: Apr 2002 Location: A Mile High!! Posts: 230	If you have pivot tables and/or links in your 6 meg file, try this. When you open, dont update links and after file starts to load, hit the escape key until the file finally loads. I have several large excel files (11mb to 22mb) that occasionally encounter this error. It is a pivottable access thing. If you have pivottables, you will need to rebuild, unfortunately. This always fixes the problem for me.