![]() |
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 05:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com