ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Keep full file path in cell reference (https://www.excelbanter.com/excel-discussion-misc-queries/121563-keep-full-file-path-cell-reference.html)

dan

Keep full file path in cell reference
 
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?


All times are GMT +1. The time now is 03:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com