+ Reply to Thread
Results 1 to 2 of 2

Excel file takes a long time to open

  1. #1
    Registered User
    Join Date
    09-17-2012
    Location
    Alabama
    MS-Off Ver
    Excel 2007
    Posts
    5

    Excel file takes a long time to open

    I have an excel file that takes like 10 minutes to open. The file not particularly large, only about 6mb. It has 8 worksheets. It has no links. It has one vba module with two really simple macros. It has one connection to an olap server. Other files on the same network open quickly.

    Here's what I've done so far in troubleshooting the problem:
    1. Removed unused connections.
    2. Deleted all rows below the last known populated row.
    3. Deleted all columns to the right of my last known populated column.
    4. Deleted any unused names.

    Any ideas on what might cause a file to take so long to open?

  2. #2
    Forum Expert
    Join Date
    08-27-2008
    Location
    England
    MS-Off Ver
    2010
    Posts
    2,561

    Re: Excel file takes a long time to open

    I would guess corruption.

    Next step is to move the contents of the sheets and modules, and connection, into a new book one at a time. By move contents I mean: create new sheet in destination book, select all cells in source sheet, copy, paste into new sheet in destination book.
    CC


    If you feel really indebted please consider a donation to charity. My preferred charity is ActionAid but there are plenty of worthy alternatives.

  3. #3
    Registered User
    Join Date
    09-17-2012
    Location
    Alabama
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Excel file takes a long time to open

    Thank you, Cheeky. I will give this a try.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1