Excel File Error: Open, Read-Only, or Review State

The Excel linking document needs to be saved and closed:

  • prior to updating the CrossLink, if a structural change has been made (adding or deleting rows or columns)
  • before applying a new CrossLink

When applying or updating a link, you may see this error message:

Cannot update the source Excel file. Possible reasons are: the file is currently open by another user, the file is set to read-only, the file is a DM report in a review state.

Troubleshooting

  1. Save and close Excel, and try updating the link again
  2. Open the Excel file to confirm it is not in use by another user
  3. Wait longer between saving and updating the link, to allow the Excel file to finish saving to the network
  4. Contact Support for assistance