+ Reply to Thread
Results 1 to 7 of 7

Worksheet operations absurdly slow

  1. 02-16-2014, 01:13 AM #1
    brisbane
    brisbane is offline
    Registered User
    Join Date
    02-16-2014
    Location
    Canada
    MS-Off Ver
    Excel 2013
    Posts
    2

    Worksheet operations absurdly slow

    Hi all,

    I'm working in a spreadsheet with ~75 tabs that is ~23mb. Adding, deleting, or even moving a worksheet takes at least 5 minutes, and that time seems almost exponential to manipulate multiple tabs at once (e.g. deleting 8 tabs may take 30 minutes). While this is occurring, my computer seems to be working fine, and I have plenty of RAM (6g) and CPU power (2.5 Ghz). Opening and saving/closing the spreadsheet doesn't take an abnormal amount of time.

    Any idea what might be causing this?

    Thanks!
    Reply With QuoteRegister To Reply
  2. 02-16-2014, 01:17 AM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,938

    Re: Worksheet operations absurdly slow

    Hi and welcome to the forum

    Almost impossible to say without seeing what you are working with . However, having 75 tabs seems extremely excessive?? Im sure there are other ways to do what you are doing
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 02-16-2014, 01:23 AM #3
    brisbane
    brisbane is offline
    Registered User
    Join Date
    02-16-2014
    Location
    Canada
    MS-Off Ver
    Excel 2013
    Posts
    2

    Re: Worksheet operations absurdly slow

    Nothing too complicated. I'm modeling out a retail company -- each tab represents a single store and then I have a consolidation tab which uses Sum(First:Last). Pretty standard for how it's done in the industry and much easier to work with than the alternative (a single tab with stores presented vertically). Specifically actions on tabs take an excessive period of time...not opening, not calculations, not row/column manipulation...
    Reply With QuoteRegister To Reply
  4. 02-16-2014, 01:45 AM #4
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,938

    Re: Worksheet operations absurdly slow

    based on what you have described, I have pushed this to the other experts for their input too
    Reply With QuoteRegister To Reply
  5. 02-16-2014, 04:44 AM #5
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,463

    Re: Worksheet operations absurdly slow

    Given that you are using 3D formulas, the structure of each sheet is the same. So, how many rows, how many columns, how many formulas on each sheet? Do you have formulas that "prepare" the row for input, for example, =IF(A2="","",...) ? Are the formulas simple, complex, array formulas? Do you have a lot of formatting? Do you have a lot of Conditional Formatting? Is the "last used cell" further down and/or across the sheet than the actual data? Do you switch calculation to manual when you delete the sheets?

    Can you give us a sample workbook with a couple of sheets and the summary sheet to review?

    Regards, TMS
    Last edited by TMS; 02-16-2014 at 03:37 PM.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  6. 02-16-2014, 01:34 PM #6
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Worksheet operations absurdly slow

    This sounds like a candidate for VBA, perhaps you're formula bound??
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
    Reply With QuoteRegister To Reply
  7. 02-16-2014, 03:27 PM #7
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Worksheet operations absurdly slow

    Volatile formulas, e.g., INDIRECT and OFFSET?

    Full-column references where they aren't needed?
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro is running real slow and makes navigating the worksheet really slow after execution.
    By MichWolverines in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-03-2013, 04:29 PM
  2. Worksheet lookup/match and other operations
    By Paulthenovice in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-26-2011, 11:53 AM
  3. Relatively slow worksheet
    By jerryliang2k in forum Excel General
    Replies: 1
    Last Post: 12-29-2008, 08:45 PM
  4. Getting a commandbutton macro to do operations on an adjacent worksheet
    By kuraitori in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-03-2008, 06:24 PM
  5. Slow excel operations
    By [email protected] in forum Excel General
    Replies: 3
    Last Post: 02-14-2005, 12:06 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1