+ Reply to Thread
Results 1 to 3 of 3

Excel taking too long to respond

  1. #1
    Forum Contributor
    Join Date
    10-16-2010
    Location
    Memphis, TN
    MS-Off Ver
    Excel 2003, 2010
    Posts
    151

    Excel taking too long to respond

    I am running Microsoft Excel 2010 under Microsoft Windows XP. I have one spreadsheet which is currently 56 columns wide and 1060 rows deep where I input daily production data. Most of the data in the Workbook is calculated using IF,THEN,ELSE statements to check for errors and keep the sheet clean of divison by zero errors.

    I use VLOOKUP Functions to pull data from a dataset on another worksheet within the same book, and I have 1 macro which inserts a row, copies and pastes a row then deletes the original then copies a row containing the formulas being used to the now blank line.

    There are a couple of sheets in the workbook that I use for quick calculations and such but nothing there which would eat up much overhead.

    The problem I am having is the time it takes to do what I consider to be easy tasks, copy cells and insert rows. I also tried to move a block of cells I was working with on one of my extra worksheets in the book and it took over 3 minutes to move 28 cells in an empty worksheet.

    Nothing else that I use takes this much time. The file is saved as a Macro Enabled Excel workbook and I am using a copy that has been copied from our remote server to my desktop to allow it to run locally.

    Where do I start to get this file to start working in a timely and efficient manner?

    Thanks
    Jacob Albers
    Excel 2003 & 2010

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: Excel taking too long to respond

    First, if you put Excel into Manual Calculation mode and repeat the actions you describe is there still a lag ?

    Note: I am not advising this as a fix but as a means to identify / eliminate possible causes.

  3. #3
    Forum Contributor
    Join Date
    10-16-2010
    Location
    Memphis, TN
    MS-Off Ver
    Excel 2003, 2010
    Posts
    151

    Re: Excel taking too long to respond

    Quote Originally Posted by DonkeyOte View Post
    First, if you put Excel into Manual Calculation mode and repeat the actions you describe is there still a lag ?

    Note: I am not advising this as a fix but as a means to identify / eliminate possible causes.
    Thanks, I tried putting it into manual mode and there is still a major lag time problem.

+ 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