I am using formulas that use ranges in outside file locations. Due to my company's file management "nuances" the file paths are exceedingly long and make it difficult to read formulas. Can I use the Define Name feature to enter the external file path and file name? My attempts so fare don't seem to be working.
Any quick advice?
I just ran a test. I entered Name Manager and created a new name and in the formula field entered this formula and it returned the contents of cell B1 of the addressed file when I entered =mytestname in a cell.
Formula:
Please Login or Register to view this content.
The complete path in the NAME MANAGER changed to this when I saved the file with the named range:
Formula:Please Login or Register to view this content.
I then opened the file and entered =mytestname in a cell and the contents of B1 of the target file was returned. So my conclusion is that you can assign a path to a Defined Name and have it work on demand.
Last edited by newdoverman; 11-28-2013 at 07:20 PM.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks