1. Click the 'Office' button in the upper left of Excel.
2. Select 'Excel Options.'
3. Click 'Save' on the left hand menu.
4. Change 'Default file location' to the specific directory you want to use. Click 'OK.' Now if you open or save a file, your new directory is the one that will open.