Is it possible to make all formulae and cell references refer to the active directory instead of the current path? I want to prevent my references being nullified if the folder is moved to a new location.
Any advice would be useful![]()
Is it possible to make all formulae and cell references refer to the active directory instead of the current path? I want to prevent my references being nullified if the folder is moved to a new location.
Any advice would be useful![]()
The linked workbook must be opened for the link to work, so even if it is in a different drive it will ressemble: =[Test.xls]Sheet4!$F$5
Best regards,
Ray
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks