Our department is using a shared workbook with multiple cells referring to other workbooks. Some of the linked cells behavior is very strange: in the path inside the cell the source workbook sheet name gets changed disregarding of our wish.
Let me explain based on an example.
I have a cell linked to another workbook:
Then (after I close the book, or another person opens it after I saved the changes) it turns to this:
I also figured out that there is a pattern. If I had a binary workbook format (i.e., "xlsb" extension) this strange behavior would catch letter "b" from extension and replace first sheet name letter with it:
will turn to
And of course if I try to open such broken reference I will get a #REF error inside this cell.
However I can see there is some logic (if you may call it 'logic') behind this error, I cannot seem to discover the root cause.
We use Excel 2016. Thankfuly, not all of the shared workbooks we have behave like this.
Your help is much appreciated.