UNC alternative
Home > IT Answers > Microsoft Windows > UNC alternative
Smf
40 pts.
0
Q:
UNC alternative
Microsoft Excel, UNC path, UNC, Excel worksheets, Excel macros
I have many excel worksheets that link to other worksheets. Some link by drive letter mappings and others have a UNC name. Is there a way to link without using the UNC name? Concern is what to do if the linked server is changed. Do we have to go through each spreadsheet and change the link? Or is the option to write a macro that will do a find and replace? Thanks
ASKED: Mar 26 2009  2:51 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Labnuke99
26290 pts.
0
A:
 RATE THIS ANSWER
+1
Click to Vote:
  •   1
  •  0
  • AddThis Social Bookmark Button
Put all of the files under the same folder structure and use relative pathnames. Otherwise, using the servername in the UNC is the best way. The server could have a different IP address at a point in time if hardware fails and another server provisioned in its place.
Last Answered: Mar 26 2009  3:15 PM GMT by Labnuke99   26290 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0