weird thing about clear contents of a worksheet....

G

Guest

It is exactly the same worksheet. When I clear its contents (select the whole
spreadsheet then press delete key) in my laptop, it works within a blink.
When I switch to my desktop which is faster, it takes forever to clear the
contents of the worksheet. Any idea of why?
 
S

squenson via OfficeKB.com

Any formula or any automatic macro that may refer to a file on a network
drive which could be present in one case but not the other?

What is the CPU indicator showing when you delete entire content on your
desktop (use CTRL+ALT+DEL, then tab Processes, then highlight Excel)?
 
G

Guest

After I embed "application.enableevents=false" in the spreadsheet, it still
takes long,long time to clear the contents of the speadsheet.

The usage of CPU is indicated as 50%. It is unusually high. No idea of the
cause.
 

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

to clear contents of a spreadsheet 2
a cell is set to email contents-cannot undo-changes my formatting 3
Adding a "CLEAR" button to the worksheet 1
How to clear up useless content within worksheet? 1
Clear a cell's contents when document is saved 2
Clear Contents of a Worksheet 1
WHY the same macro runs so slowly on a different but faster comput 2
Clear Contents of Adjacent Cell on Conditional Basis 8

Top