Excel 2003 text file generation slow

M

MrHong

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vista -vs- XP 11
Slow startup 7
Copy and paste slow 1
XP 2002 Office Suite vs. XP 2003 Office Suite 1
Excel 2007 extremely slow to delete cells 1
Parsing Text file and import into Access Table. 13
Excel Extremely Slow 2
Importing Text file 4

Top