(Solved) – Excel Workbook opens as Read-Only because Connection Files

(solved)-–-excel-workbook-opens-as-read-only-because-connection-files

I have an group of 3 interconnected workbooks that pull data from each other. The way I have it pulling data is through Connections. All files are located in the same drive. What I am trying to do is to open all three files at the same time to make edits. However, once I open workbook “A”, I can not properly open files “B” or “C” as it displays that the file is in use by another user and only gives the option to open as Read-Only.

Is there a work around to open all files at the same time in Write mode? I have tried including a ChangeFileAccess to Read but that does not work.

Thanks!

Leave a Reply

Your email address will not be published. Required fields are marked *