I forgot to mention that I'm using Excel 2007 and Excel 2010. Paul ----------------------------------------- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley -----------------------------------------
________________________________ From: Paul <schreiner_p...@att.net> To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> Sent: Wed, September 14, 2011 2:59:17 PM Subject: $$Excel-Macros$$ Slow Laptop execution I have an excel application that is used to create maintain Manufacturing Process documents in an Oracle database. These documents vary from 2 to 400 pages (averaging about 30) The application has (7) hidden worksheet "templates". I first turn off ScreenUpdating, Calculations, DisplayAlerts, Events. I then read data from an Oracle database and determine the combination of templates required and copy the sheets. For several years, this application has been working great on 32-bit Desktop workstations. Recently, we've begun to utilize 64-bit laptops. For some reason, documents that retrieve in 6 seconds on the desktop take 25 seconds on the laptops. I've narrowed the issue to the copying of the templates. I collected timing information. the line: Sheets(FormTemplate).Copy after:=Sheets(Sheets.Count) takes .03 to .06 seconds on the desktop. The same line takes 1.1 to 1.6 seconds on the laptop. Not a big deal, until you do it 30-40 times. As a test, I created a workbook that simply copies sheet1 (blank) 100 times. Desktop time: 2 seconds laptop time: 107 seconds... As I said, I've disabled everything I can think of. Any other recommendations? Paul -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
