ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   to clear contents of a spreadsheet (https://www.excelbanter.com/excel-discussion-misc-queries/154383-re-clear-contents-spreadsheet.html)

Jerry

to clear contents of a spreadsheet
 
The problem is, it is the faster computer (faster CPU, more memory) that runs
the operation very slowly.


"JLatham" wrote:

Differences in hardware? One computer may have a faster processor (CPU),
more memory (remember, Excel is keeping a copy in case you decide to UNDO
your massive clear operation - and a small amount of memory may force it to
page pieces of the file to the hard drive, slowing things down). Perhaps the
load on the systems is different: slower one may be running more processes
that tie up the CPU more than the other.

Potentially the version of the operating system and even the version of
Excel can play into it, along with the size of the spreadsheet itself.

"Jerry" wrote:

Why it takes forever to clear contents of a spreadsheet on one computer while
the same operation can be done in a sec on another computer?



All times are GMT +1. The time now is 03:42 AM.

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