Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Book 32

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    32
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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!

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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"

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Location
    A Mile High!!
    Posts
    241
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •