ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Editing in Excel 2007 slow (https://www.excelbanter.com/excel-discussion-misc-queries/239788-editing-excel-2007-slow.html)

Oxford

Editing in Excel 2007 slow
 
Working in an 8000 line workbook with three sheets (no links yet) after a
copy and paste the editting of cells has slowed to 30 secs a cell. Task
manager says Excel not responding then poof it wakes up. Cannot undo the
paste command, too much editing has taken place since that time. Any
suggestions?

Oxford

Editing in Excel 2007 slow
 
Additional info: Slow to edit is only on one sheet in workbook, other files
okay as well. I'm sure I have done something to cause this, just not sure
what. Again, any help appreciated.

"Oxford" wrote:

Working in an 8000 line workbook with three sheets (no links yet) after a
copy and paste the editting of cells has slowed to 30 secs a cell. Task
manager says Excel not responding then poof it wakes up. Cannot undo the
paste command, too much editing has taken place since that time. Any
suggestions?


MagneticEnergy

Editing in Excel 2007 slow
 
On Aug 14, 7:38*pm, Oxford wrote:
Working in an 8000 line workbook with three sheets (no links yet) after a
copy and paste the editting of cells has slowed to 30 secs a cell. *Task
manager says Excel not responding then poof it wakes up. *Cannot undo the
paste command, too much editing has taken place since that time. *Any
suggestions?


That's as fast as your computer is going to run that application once
you put that much stuff in memory. You have to upgrade your computer,
by either putting more ram, or upgrading to a faster system and
perhaps a 64bit operating system. Assuming you are not going to do
this very often, just go make a cup of coffee, walk the dog, stretch,
take out the trash, etc.



All times are GMT +1. The time now is 12:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com