ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Why does it take so long to delete a part of table? (https://www.excelbanter.com/excel-discussion-misc-queries/163769-why-does-take-so-long-delete-part-table.html)

Eric

Why does it take so long to delete a part of table?
 
Does anyone have any suggestions why it takes so long to delete a part of
table?
I get a table A1: Z60000, when I open it and press ESC to avoid
re-calucalation, then I select a part of table A30000:Z60000 and press Delete
button, I don't understand why it takes so long to perform this task, CPU is
used 100%, but I stop re-calculation process already. Does anyone have any
suggestions on what it is calculating behind the delete process?
N.B. the delete process does not finish yet, so ignoring any re-calculation
after delete process
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric

Don Guillett

Why does it take so long to delete a part of table?
 
Try selecting the row numbers to the left and then delete

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Eric" wrote in message
...
Does anyone have any suggestions why it takes so long to delete a part of
table?
I get a table A1: Z60000, when I open it and press ESC to avoid
re-calucalation, then I select a part of table A30000:Z60000 and press
Delete
button, I don't understand why it takes so long to perform this task, CPU
is
used 100%, but I stop re-calculation process already. Does anyone have
any
suggestions on what it is calculating behind the delete process?
N.B. the delete process does not finish yet, so ignoring any
re-calculation
after delete process
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric




All times are GMT +1. The time now is 01:04 AM.

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