A customer of mine gave me an Excel workbook that was too slow to see if there’s anything I can do to make it go faster.
It isn’t a particularly big workbook, something like 800 rows by 10 columns, but originaly it was 60MBytes in size.
It has no links, no formulas, no VBA. Just text and dates with very little formatting (some columns are a different color).
The original had lots of empty cells so I selected only the used cells and copied the to a new excel file and magically the size dropped from 60MB to just 500KB.
But while the new file opens significantly faster, scrolling is still a nightmare.
So I started removing stuff to see if things get better. Nope! I ended up deleting everything but the scrolling was still horific, while the file size was still 500kb (an empty excel file for comparison is 9kb).
So there’s still something there that causes the horrible scrolling
I have uploaded the file here so you can test it for yourself https://www.dropbox.com/s/iq9r37tdk7exrxj/Worksheet.xlsx