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

E

Eric

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

VBA to see if a Section exists in Word Document, and if it does, delete it 2
Why does it take so long? 5
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Why does it take so long to open? 4
Why does it take longer time for re-calculation? 2
What process is performed behind excel? 2
Why does my spreadsheet re-calc so slowly ? 1
why does it take so long to open files 2

Top