Configuring Excel to Save Local Files in Office 365
If you have Office 365 installed on your local PC, you have the option to configure your apps, such as Word, Excel, and PowerPoint, to save files locally. This article will focus on Excel and cover three different configurations, with the third configuration setting Excel as the sole app for saving local files.
Configuration Case One: Save to Local PC
By default, Excel in Office 365 is set to save files to OneDrive. To change this and save to your local PC, follow these steps:
- Open Excel and click on the "File" tab.
- Click on "Options" on the left-hand side of the screen.
- In the Excel Options window, click on "Save" on the left-hand side.
- Under "Save files," change the default location to your local PC.
- Click "OK" to save the changes.
Configuration Case Two: Save to Other Cloud Services
If you prefer to save your Excel files to a cloud service other than OneDrive, you can configure Excel to do so. Follow these steps:
- Open Excel and click on the "File" tab.
- Click on "Options" on the left-hand side of the screen.
- In the Excel Options window, click on "Save" on the left-hand side.
- Under "Save files," change the default location to your preferred cloud service.
- Click "OK" to save the changes.
Configuration Case Three: Solely Save to Local PC
If you want to configure Excel to solely save files to your local PC, follow these steps:
- Open Excel and click on the "File" tab.
- Click on "Options" on the left-hand side of the screen.
- In the Excel Options window, click on "Save" on the left-hand side.
- Under "Save files," change the default location to your local PC.
- Uncheck "Save to Computer by default" and check "Always create backup copy" for added security.
- Click "OK" to save the changes.
Code Block: VBA to Set Default Save Location
If you prefer to use Visual Basic for Applications (VBA) to set the default save location, you can use the following code:
Sub SetExcelSaveLocation()
Dim objApp As Object
Set objApp = Application
objApp.DefaultFilePath = "C:\MyFolder"
End Sub
- Office 365 apps, including Excel, can be configured to save files locally or to a cloud service.
- You can configure Excel to solely save files to your local PC for added security.
- Using VBA is an alternative method for setting the default save location in Excel.