Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Texas, USA
    Posts
    374
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Slooooow opening of a file (2002)

    It takes more than 10 minutes to open a file. The file size is about 11MB. No VBA in this workbook. Is there any suggestion on this strange behavior?

    System: WinXP+ Office XP

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Slooooow opening of a file (2002)

    Is the workbook on the local hard disk, or on a file server? If it is on a file server, does it also open slow if it is copied to a local hard disk? Does it contain a lot of links to other workbooks that must be updated when the file is opened? Does truning virus protection off on the workstation have any affect?
    Legare Coleman

  3. #3
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Texas, USA
    Posts
    374
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Slooooow opening of a file (2002)

    Local file
    No links to other workbooks or files
    About 20 worksheets with simple formula (+,-,*,/)
    Scanned with NAV, no virus found.
    No NAV installed in the system

    This file was about 2-3MB in Excel97. It blows itself to 11M under Excel2002.

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Slooooow opening of a file (2002)

    Here is a shot in the dark for something to try. Open the file and do a File/SaveAs and save the file to Type HTML under a different name. Close Excel. Start Excel back up and open the HTML file and then do a File/SaveAs back to .xls type (don't replace the original file). Does the resulting file now open more reasonably? If so, check to see if anything like formatting was lost in this process before you delete the original .xls file?
    Legare Coleman

Posting Permissions

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