LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
gwc gwc is offline
external usenet poster
 
Posts: 62
Default processing time (revised and re-posted)

Is is normal for the same process to take significantly longer each time it is repeated or is there something wrong with my computer?

My spreadsheet has 9 columns and 51,000 rows. It contains no macros nor formulas.

Here's what I'm doing:

I click on the "A" at the top of COL A.

In the FIND and REPLACE box, I type DUPL after 'Find What' and, for Options, I click 'WITHIN SHEET", "SEARCH BY COLUMNS" and "LOOK IN FORMULAS". I then click FIND ALL and it returns 588 cells.

I select the first cell listed and hold down the SHIFT key and select the last cell listed. (That selects all 588 cells listed).

I then click INSERT and INSERT CELLS and SHIFT CELLS RIGHT.

The first time, the "shifting" process" take 8 seconds.
the second time takes 20 seconds
the third time takes 80 seconds.
the fouth time takes 140 seconds
the fifth time takes 200 seconds
the sixth time takes 6 minutes.
the seventh time takes 20 minutes.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Processing time GWC Excel Programming 1 November 28th 12 12:31 AM
Processing Time Varies Paige Excel Programming 3 June 18th 08 10:11 PM
Processing Time [email protected] Excel Worksheet Functions 0 July 20th 07 06:52 PM
Format excel to revised date automatically when revised annetteberrios Excel Programming 0 September 2nd 05 02:25 PM
Processing time to set values Eric Excel Programming 1 November 2nd 04 07:53 PM


All times are GMT +1. The time now is 12:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"