Microsoft Excel file is locked after export - does not allow edits to file
At times, after you export an Excel file from DBA, you will not be able to edit the file. We have found that changing settings in the Trust Center will resolve this issue.
Click the Excel File tab, select the Options menu.
- In the Options window, click Trust Center > Trust Center Settings.
In the Trust Center window, click File Block Settings, and then clear the "Open" or "Save" check box for the file type that you want to open or save.
To see which settings you need to modify, refer to the screenshots posted below.