Description

I have made some changes to an Excel file outside Studio, I have left the Excel file open in the background and when trying to make additional changes to it from within the preview in Studio, it won't allow me modify it. I receive the following error message " This data file is in read-only mode to preserve any formatting, charts and any other elements".

Also if I try to save the excel file within the Studio preview when the filters are on, I get the read only message. If I remove the filters I am able to save the file.

Applies to

Studio 11.X, 12.x

Cause

This was designed to prevent accidental deletion of data in Excel.

Solution

Studio does prevent write access within Studio to preserve any formulas or data that may have been inputted directly in Excel. This has been designed to prevent the user accidentally deleting formulas that they may have entered directly in Excel while the file was being used in Studio.

In Studio 11.1.0, only data files that contain unsupported elements (PivotTables, charts, filters and graphs) open as read-only: 

Studio v11.1.0 release notes