I have a workbook which has suddenly and mysteriously showing the workbook name in all the cell references. e.g. ='workbook name.xlsm'!$C$. This phenomena is present through all the sheets in this large workbook.
I wish to remove the workbook name from the reference. I can edit / delete the workbook name (using find/replace) and the cell still works fine, but when I save, close and reopen the workbook name returns. I have never encountered this before. Does anyone have a solution to ensuring the workbook name is permanently removed.
You may rightly ask why do I need to remove the workbook name if the results still pull through - very long story - suffice to say removal of workbook name will save me a lot of time.