+ Reply to Thread
Results 1 to 2 of 2

Spreadsheet takes so long to open any ideas?

  1. #1
    Registered User
    Join Date
    08-12-2009
    Location
    Perth, WA
    MS-Off Ver
    Excel 2003
    Posts
    93

    Spreadsheet takes so long to open any ideas?

    Hi all,

    I have a spreadsheet that is 50MB and is taking close to a minute to open.
    The spreadsheet contains an Output table that has 120 VLookups and 12 other data worksheets each containing a variety of 350 IF, SUMIF and other formulas.

    I also have a macro that I run on each data sheet that performs conditional formatting, copies unique records, copies down formulas, sorts AZ which then updates the Output table. – this also takes about a minute to complete.

    Without going into the mechanics or reengineering of the sheet is there anything simple someone can recommend that I can apply to reduce the size of the spreadsheet or the time it takes to open or run the macro?

    Many thanks

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Spreadsheet takes so long to open any ideas?

    maybe you'll get some ideas from this article by Charles Williams.

    http://msdn.microsoft.com/en-us/libr...alculateFaster

    Not all of it may apply and some stuff is 2007 specific. But overall it's a gold mine of information...

+ 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