We have an Excel file on SharePoint that our automation writes to. The workbook opens read only no matter what settings we select in Excel. This is causing issues with our automation as the Edit Workbook selectors work fine for a week or two but will then throw errors.
I saw a previous topic on the subject that suggested running a macro to keep the file from opening in edit only mode but it did not work. Does anyone have any suggestions how to correct this issue?