If you have had the experience of Excel shutting down when opening a file you must know how frustrating it is. We experience it regularly, probably due to the size of the spreadsheets we build. However, it is sometimes even a small spreadsheet that perhaps contains a data table.
We haven’t found the particular reason but a way around it. For these types of files, rather open Excel first and open a blank worksheet.
As it often happens when we use Data Tables, we also recommend that you change the Calculation Options to either Automatic except Data Tables or manual and then open the file via the Open File method.
So first open Excel on a blank worksheet and change the calculation method to Automatic Except Data Tables
Then open the file via the FILE ribbon
For some reason this works much better and also gives you control of how long it takes to open (if you are on Automatic, then it first recalculates everything which might take a long time and all you want to do is see the file!).
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.