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.

  1. Click the Microsoft Office ButtonOffice button image, and then click Excel Options.

  2. In the Options window, click Trust Center > Trust Center Settings.
  3. 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 screenshot posted below.