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

"GWC" wrote:
I deleted all of the lines at the end that have all-empty
fields (",,,,,,,,,,,") and saved the CVS file.
I opened the CSV file in Excel and did the "shifting"
process 10 times. Each time look less than 10 seconds for
a total of 93 seconds!


Odd! It took significantly less total time when I did it.

Of course, this does depend on characteristics of the computer system.

But also, I saved as XLSX and reopened the XLSX file before doing the
repeated shifts.

I would not think that makes any difference. But we're dealing with an
inexplicable phenomenon in the first place. So anything could be an adverse
factor.

 
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 01:24 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"