+ Reply to Thread
Results 1 to 7 of 7

Help required to make the processing of workbook fast

  1. #1
    Registered User
    Join Date
    06-12-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    86

    Help required to make the processing of workbook fast

    Hi,

    I am facing an abnormal process. In the attached workbook, there is a sheet named "AOR". I dont know why the sheet process very slow, be it calculation, copy paste or changing cell height . I mean the processing is very slow. I have done most of work on it and cant bear to redo on from fresh basis on new sheet as i have to submit the same ASAP.

    I hope some one may be knowing to resolve issue. Also help with instruction as how to handle the issue as this is only a part of file.
    I ned to make my data base improved on basis of suggestions received
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    06-12-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    86

    Re: Help required to make the processing of workbook fast

    I am waiting for some one to help or correct the file

  3. #3
    Forum Contributor Steve N.'s Avatar
    Join Date
    12-22-2011
    Location
    USA
    MS-Off Ver
    Excel 2007, 2010
    Posts
    298

    Re: Help required to make the processing of workbook fast

    I copied/pasted, changed cell size (height and width) and it processes at a seemingly normal speed. I don't see the problem you describe....

  4. #4
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: Help required to make the processing of workbook fast

    Nothing wrong with your workbook. Calculation performs normal, not very much rows to handle, no time consuming array formulas or anything else what could impact performance.
    The only thing I noticed is that sometimes scrolling down is a little bit jerky, but that can hardly come from your workbook. Maybe some other process on your computer is claiming cpu-time.
    Cheers!
    Tsjallie




    --------
    If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!

    If you think design is an expensive waste of time, try doing without ...

  5. #5
    Registered User
    Join Date
    06-12-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    86

    Re: Help required to make the processing of workbook fast

    i have tried on three different system.Processing is slow. I hope u are talking about sheet name "AOR". Other Sheet are working normally. The problem is in AOR sheet. Like of u put a summation function, it takes around 15 seconds to compute, but in other sheet the value is computed as soon as enter is pressed.

    Kindly confirm once again if AOR named sheet is working normally on your systems.

  6. #6
    Registered User
    Join Date
    06-12-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    86

    Re: Help required to make the processing of workbook fast

    if some more experts may give there opinion ......

  7. #7
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: Help required to make the processing of workbook fast

    Tried the AOR sheet. Performs normal.
    And you don't have to shout

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Fast way to make shortcuts
    By wilro85 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-13-2008, 12:04 PM
  2. Image linked to sheet, but how to make fast link change with VB
    By Bellyx in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-29-2007, 12:01 PM
  3. Fast way to make rows visible and invisible
    By gimme_this_gimme_that@yahoo.com in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-09-2006, 03:20 PM
  4. Fast Data Processing
    By astrikor in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-09-2006, 05:53 AM
  5. cannot make the excel fill in/delete cells fast
    By Johny B. in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-21-2005, 02:05 PM

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