+ Reply to Thread
Results 1 to 4 of 4

Excel 2010 slow working with multiple sheets

  1. #1
    Registered User
    Join Date
    05-29-2012
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    84

    Excel 2010 slow working with multiple sheets

    I upgraded to excel 2010 a few months ago at work. While some things were faster, there were several things that were slower than working in 2003 (certain Macros, working with multiple sheets, etc...). It looks like some of the problems (like the macros) were an issue with the computer. I just got a new CPU so as expected, a lot of the issues have corrected themselves. The one problem I am still seeing that I can't explain is the slowness when working with multiple sheets.

    I have a lot of files that have 140 nearly identical tabs. Often times I will group the tabs together and make changes to the header or a column or something. In excel 2003, I would certainly have to wait for the updates to be made to all sheets, but usually only for 10 seconds or so. With 2010 it is 2-3 times that long. Anyone able to shed any light as to what could be causing this? Is there a setting I can try changing to speed this up? You would think with it using 2 processors (which are both active) it should be faster.

    Thanks in advance for any help you may have!

  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Excel 2010 slow working with multiple sheets

    Excel 2003 maxed at 65k rows per sheet.
    Excel 2007+ has over a million rows per sheet.

    Depending on the changes you're applying to these sheets, that could certainly cause the extra time.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    05-29-2012
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    84

    Re: Excel 2010 slow working with multiple sheets

    Each sheet is a few hundred rows max.

  4. #4
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Excel 2010 slow working with multiple sheets

    I'm just offering something to think about. I wasn't referring to the number of rows of data you have, I'm talking about the number of rows TOTAL on the sheet. Depending on WHAT you're changing or doing, it may be evaluating all 1million rows to apply that change, even if the data is only 100 rows.

+ 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