| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003 text file generation slow
I have an Excel file that loops through 7000 rows (41 colomns) and an
writes the row details to a text file. The proceedure takes in the region of 20 seconds under Excel 97 bu takes over 2 mins under XP. I have tried the following to no avail - Turned off automatic calculation - Turned off Screen updating Anybody know what is causing this and what I could try. Many thank -- Message posted from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 2003 text file generation slow
Have you tried
ActiveSheet.DisplayPageBreaks = False -- Regards, Tom Ogilvy "MrHong " wrote in message ... I have an Excel file that loops through 7000 rows (41 colomns) and and writes the row details to a text file. The proceedure takes in the region of 20 seconds under Excel 97 but takes over 2 mins under XP. I have tried the following to no avail - Turned off automatic calculation - Turned off Screen updating Anybody know what is causing this and what I could try. Many thanks --- Message posted from http://www.ExcelForum.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula generation in Exel 2003 | Excel Discussion (Misc queries) | |||
| Very slow in opening Excel 97 file in Excel 2003 | Setting up and Configuration of Excel | |||
| Open file Slow on Excel 2003 | Excel Discussion (Misc queries) | |||
Linear Mode
