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
