When your Microsoft Excel spreadsheet slows to a crawl, you canâ€™t help but notice. It may take longer to open and save your files, longer for Excel to calculate your formulas, and longer for the screen to refresh after entering data, or sorting and formatting the cells. System memory is the other issue that relates to Excelâ€™s slowness.Â
Slow spreadsheets take longer to manage and, as always, time is money. Weâ€™ll show you how to tackle this problem.Â
When Excel spreadsheets get too big
Excel is capable of creating a very big spreadsheet, but the bigger it gets, the more memory is needed to keep it open on your PC.
In the current version of Excel, each spreadsheet has 1,048,576 rows and 16,384 columns (A1 through XFD1048576).Â Each cell can hold a maximum of 32,767 characters. I would not advise pushing these limits.Â