LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default Extremely slow sheet copy

Using XL2003, XP Pro SP2, Duo Core laptop

I've been using this line of code for years now:

Worksheets("Report").Copy
after:=Workbooks(strDestinationBook).Worksheets(Wo rkbooks(strDestinationBook).Worksheets.Count)

The "Report" uses less than 300 rows and until recently it took mere
seconds to copy the sheet with the quoted code above.

Both the active workbook and the destination file have been saved to a
local drive - no network files in use.

Today it's taking almost 4 minutes. No software has been installed -
that I know about, corporate laptop and all - who knows what IT does
silently behind the scenes.

On a (possibly) related note, Excel "hangs" for about 20 seconds every
time I open a file - after it recalculates - I can tell with larger
files. The "pause" is consistent regardless of file size.

Any ideas as to how to get this back to normal will be very much
appreciated, as I use this sort of operation about 30 times on the
first business day of every week. 30 occurences x 4 minutes each =
high PITA 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
Cut, copy & paste functions in Excel 2007 are extremely slow. Joe B.[_2_] Excel Worksheet Functions 3 June 2nd 10 02:29 AM
Extremely slow copy/cut in Excel 2007 Mitch Wenger Excel Discussion (Misc queries) 2 January 25th 10 01:37 PM
Copy / Paste extremely slow Isotope07 Excel Worksheet Functions 4 April 23rd 07 02:58 PM
Extremely slow macro CLR Excel Programming 3 January 17th 07 06:58 PM
Copy and paste link in worksheet is extremely slow. What to doÉ Franco Excel Discussion (Misc queries) 0 September 21st 05 04:41 PM


All times are GMT +1. The time now is 02:23 AM.

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"