Excel deletes the full file path in cell references to the current workbook.
Is there a way to keep the full file path in the cell reference? Example: a
workbook has the file path "My Documents\Example", the following is entered
in a cell on Sheet1 of this workbook "+'\\My
Documents\[example.xls]Sheet1'!A1". When entered, excel defaults to "+A1".
Is there a way to keep the entry in the cell the full file path?