Slow response when copying

S

Steve M

I'm getting very slow response times (minutes)when I copy
large columns (50,000 cells) containing simple formulas.
I just upgraded from Excel 97 where I didn't have that
problem. I've got 1 gig of memory & a 100 gig hard drive
& I maxed out the paging size on Windows XP. Can anyone
tell me how to work around this?? Thanks
 
M

Mike

Turn automatic calculations off before copying such a
large quantity. From the menu select Tools/Options click
the Calculation tab, click the Manual option. Once done,
turn it back on, or use the F9 key to calculate.
 

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

slow responses when accessing spreadsheets that are stored on shar 0
Outlook running very slow 0
Help Optimizing a Sheet to improve performance 1
Critical Error Shut Down-xl2007-When Copying Sheets Btwn Workbooks 7
Slow computer 3
excel 2008 crashes and is very slow 4
Excel very slow to insert columns 2
Outlook 2007 Slow and non responsive 3

Top