I want to change the default save location for Excel files (Office Mac 2016), but cannot find anywhere to do it (unlike Word).
- Save an Excel file in the folder you wish to set as default
- Select "Open" from the File menu
- In the green vertical banner, select "Open"
- Navigate to the folder
- Select and open an Excel file from that folder
The folder will now be the default save location.
This seems clumsy and there may be another way, but it seems this unhelpful opacity is a feature of Office 2016.