Microsoft Excel 2010 - Choose Where Saved and AutoRecover Files Go

SUMMARY: If you need to store workbooks and AutoRecover files elsewhere, configure Excel 2010 as to where they should be placed.

Do you have multiple hard drives or partitions and want to save Microsoft Excel 2010 workbooks and AutoRecover files on a location reserved for data? Or do you just want to organize your files differently on your one hard drive / partition?

By default, Excel 2010 saves AutoRecover files in your user's "AppData" folder (for Windows 7 users, this is C:\ Users\ [YOUR_USER_NAME]\ AppData\ Roaming\ Microsoft\ Excel\). While workbooks can be saved anywhere, the default location is your Documents folder (for Windows 7 users, this is by default C:\ Users\ [YOUR_USER_NAME]\ Documents). Here's how to change these locations:

1. Select the "File" tab in the Ribbon.

2. The Microsoft Office Backstage View appears. Click the "Options" button.

(Or instead of steps 1 and 2, press Alt + T, then the letter O.)

3. The "Excel Options" dialog box appears. Click "Save" in the left pane.

4. In the right pane, underneath "Save workbooks", you will find two text boxes. One is next to "AutoRecover file location", the other next to "Default file location". Click on a box and enter a new path to change the respective file location. Note that you must enter path names exact as there are no "Browse" buttons.

Configuring Excel 2010 where to save AutoRecover files and workbooks

5. Click "OK" on the bottom-right of the dialog box to close it.

Everyone is invited to submit comments. Registered users also receive their own visitor profile page with a summary of recent posts.
Register | Login

Print This Tip

Get E-Mail When New Tips are Online

Return to the Microsoft Excel 2010 page.

View the original article here