You are working on what is a relatively small spreadsheet (couple of hundred rows, not many sheets), but you find that a sheet or sheets within the spreadsheet are extremely slow. A client recently experienced this and we tried a few things to speed it up (to see all reasons for slow spreadsheets look at the post on speeding up Excel spreadsheets)
Excel Sheet Slow- what are you not seeing?
We discovered (using GOTO Special- Objects) that on this one slow sheet, there were hundreds of ‘blank’ picture links.
If you are unaware of what a Picture Link is, it allows you to Copy and Paste as a Picture Link an area of the spreadsheet. Useful when building dashboards but it is processing heavy (especially on Apple Macs). Below a YouTube video explaining the issue.
If you paste as a picture, Excel just pastes a picture, but a picture link keeps monitoring the area you copied. Because of the way it is set up in the Paste Special dropdown, it is easy to accidentally choose the link rather than the picture. As shown below, the one on the left just pastes a picture, the one on the right pastes a link.
In the client example, blank cells were copied and pasted as picture links all over the place. As a result, you could not see all these objects but Excel was working hard to show in these pictures blank cells elsewhere.
Once deleted, the sheet went back to normal speed!
Want to learn more about Microsoft Excel? If you prefer attending a course and live in South Africa look at the Johannesburg MS Excel 3 Day Advanced Course or the Cape Town MS Excel 3 Day Advanced training course. If you prefer online learning or live outside South Africa, look at our online MS Excel training courses.
Related
Speed up a slow Excel spreadsheet (5 fixes for slow spreadsheets)