Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    Apr 2010
    Location
    Oakland, CA, USA
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have a spreadsheet (about 2000 rows of various calculations (mostly sums)) that in the previous version of excel updated quickly. Now, in Excel 2007, every time I change a cell, I have to wait 30 seconds for it to respond. This didn't happen with the old version. I don't really want to go to manual update, and even in compatibility mode, it's slow. Any ideas on how to speed it up?

    Thanks

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Are there formulas pointing to entire columns?
    Where does control+end take you on the sheets?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    New Lounger
    Join Date
    Apr 2010
    Location
    Oakland, CA, USA
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    No entire columns. Sums over 1-2K entries in a column. I also have lots of COUNTIFs over fixed ranges. Ctrl-end takes me to where I'd expect, in this case BE2142.

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Any hidden rows?

    Does it help to do a control+shift+alt+F9 (forces Excel to rebuild the calculation tree)?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    New Lounger
    Join Date
    Apr 2010
    Location
    Oakland, CA, USA
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    No hidden rows, and CSA-F9 doesn't change things either. It only seems to affect the worksheet that has the calculations (other sheets contain mostly data) and even moving the cursor around on that page is slow.

    Thanks for the help.

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    do you have any code in the worksheet?

    Steve

  7. #7
    New Lounger
    Join Date
    Apr 2010
    Location
    Oakland, CA, USA
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    No code. Like I said, it was fast in Excel 2003, suddenly is like molasses in 2007.

Posting Permissions

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