Forum Discussion
Renato F.B.
Dec 04, 2017Copper Contributor
Slow excel with no reason
Recently we are facing in some machines excel slow down with small worksheets with no formulas or macros whatsoever.
I would like to ask help to figure it out whats going on.
Attached is ...
- Dec 04, 2017
Renato,
you have about 26,000 objects in your workbook.
How to get rid of them:
Press F5.
Click on "Special...".
Select "Objects".
Click on "OK".
Wait.
Press DEL.
Wait again.
Be happy.
Detlef_Lewin
Dec 04, 2017Silver Contributor
Renato,
you have about 26,000 objects in your workbook.
How to get rid of them:
Press F5.
Click on "Special...".
Select "Objects".
Click on "OK".
Wait.
Press DEL.
Wait again.
Be happy.
- Gary_MullanAug 09, 2022Copper Contributor
had the same issue and tried the F5- Special-objects but I didnt have any to delete.
But I did have the same issue previous where when I copied the spreadseet I copied all lines including blank lines. This time I selected only the cells with data 1800 lines and pasted them into a new TAB. Deleted the old TAB and now its fine - Renato F.B.Dec 04, 2017Copper ContributorThank you @Detlef
I don't know where this comes from but it worked :-)