Files

Tips, Tricks, and Answers

The following articles are available for the 'Files' topic. Click the article's title (shown in bold) to see the associated article.

Saving a Workbook Thumbnail
When you save your workbooks, Excel can also save a preview image (thumbnail) that can be displayed in the Open dialog box. Here's how to configure Excel to save that preview.

Sorting Files when Opening Workbooks
When opening a workbook from within Excel, it can be helpful to have the workbooks available in a folder be sorted. This tip shows how easy it is to get those workbooks in the desired order.

Specifying the Number of MRU Files
MRU (most recently used) files can be a great help when you work with a given set of common workbooks. Excel allows you to easily adjust the number of MRU files it tracks for you.

Specifying Where Excel Saves AutoRecover Files
Excel, by default, periodically writes information to AutoRecover files that can help protect your data in case Excel is ended abnormally. You can specify where you want these AutoRecover files stored by using the information in this tip.

Unwanted Files Loading when Starting Excel
Imagine how painful it would be if every time you started Excel it tried to load all the files in your root directory? That is what was happening to Stephen, and here's how to fix it.