Click the Office button. Click Excel Options. Click Save. Then click Save files in this format list arrow. Then click the default format you want. To set Default File Location. Specify the complete path to the folder location Click OK.