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

Thread: Speeding up Excel 2007

  1. #1
    Board Regular
    Join Date
    Jul 2011
    Location
    London
    Posts
    510
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Speeding up Excel 2007

    Hi,

    I have a large spreadsheet, which was initially of size 55KB plus, I have converted it to an xlsb format which has drastically reduced its size to under 3kb.

    Regardless of this the spreadsheet is extremely unresponsive, probably due to the large number of calculations in it,

    Can anyone give some tips on improving speed?

    I have many vlookups for example, and they tend to have $A:$A references for example in them, would reducing the range make a difference?

    Any general tips would be helpful!

  2. #2
    Board Regular jeffreybrown's Avatar
    Join Date
    Jul 2004
    Posts
    5,138
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Jeff

  3. #3
    Board Regular
    Join Date
    Jul 2011
    Location
    London
    Posts
    510
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Speeding up Excel 2007

    Thank you Jeff,

    I am looking at FastExcel Sample files to see if that might help, I am hopeful!

  4. #4
    Board Regular jeffreybrown's Avatar
    Join Date
    Jul 2004
    Posts
    5,138
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Speeding up Excel 2007

    Good luck, hope you find what you need
    Jeff

  5. #5
    New Member
    Join Date
    Oct 2012
    Location
    Preston, England
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Speeding up Excel 2007

    A couple of things i have noticed over the years.
    The more live formulas the slower the sheet. Formulas looking in other workbooks/spreadsheets are alot worse.

    one trick i have when i am finished compiling reports is to copy and paste all of the formulas and then copy the contents into a new open .xls file and then save as the file to an xlsx format. I have had 4.5MB file end up 32kb using this trick.

  6. #6
    Board Regular
    Join Date
    Jul 2011
    Location
    London
    Posts
    510
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Speeding up Excel 2007

    Thanks for the advice all,

    I purchased FastExcel, its brilliant!

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
  •