Why does it take so long to delete a part of table?

G

Guest

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
 
S

Steve Wolstenholme

Does anyone have any suggestions why it takes so long to delete a part of
table?
Click to expand...

Just a guess but it may be having to relocate the cells in the table.

Steve
 

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

Why does it take so long? 5
Why does it take longer time for re-calculation? 2
What process is performed behind excel? 2
Why does it take so long to open? 7
Why does File Size increase with reducing spreadsheet information? 7
How to stop in the middle of re-calculation for all cells? 0
Extremely slow response times in Excel 2007 4
Why does it take so long at start-up? 7

Top