| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linkage File
I have a few excel files in a folder.These files interlink to each other.I am
planning to rename all files in folder & ensure the linkage formula also updated as per new name. any suggestions? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Linkage File
After having renamed the files at opening the files Excel will ask you "Do
you want to update links?" Choose Update and mark the new file names as link names! Regards, Stefi €žAFA€ť ezt Ă*rta: I have a few excel files in a folder.These files interlink to each other.I am planning to rename all files in folder & ensure the linkage formula also updated as per new name. any suggestions? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Linkage File
Get Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm Get Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name Manager: http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.asp And Jan Karel Pieterse's RefTreeAnalyser http://www.jkp-ads.com/RefTreeAnalyser.asp AFA wrote: I have a few excel files in a folder.These files interlink to each other.I am planning to rename all files in folder & ensure the linkage formula also updated as per new name. any suggestions? -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Linkage File
thanks stefi.
"Stefi" wrote: After having renamed the files at opening the files Excel will ask you "Do you want to update links?" Choose Update and mark the new file names as link names! Regards, Stefi €žAFA€ť ezt Ă*rta: I have a few excel files in a folder.These files interlink to each other.I am planning to rename all files in folder & ensure the linkage formula also updated as per new name. any suggestions? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Linkage File
thanks dave!
"Dave Peterson" wrote: Get Bill Manville's FindLink program: http://www.oaltd.co.uk/MVP/Default.htm Get Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name Manager: http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.asp And Jan Karel Pieterse's RefTreeAnalyser http://www.jkp-ads.com/RefTreeAnalyser.asp AFA wrote: I have a few excel files in a folder.These files interlink to each other.I am planning to rename all files in folder & ensure the linkage formula also updated as per new name. any suggestions? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date linkage | Excel Discussion (Misc queries) | |||
| Linkage. Returns #N/A for certain entries | Excel Discussion (Misc queries) | |||
| Excel and Access linkage | Excel Discussion (Misc queries) | |||
| worksheet linkage | Excel Discussion (Misc queries) | |||
| how to change cell linkage | Excel Discussion (Misc queries) | |||
Linear Mode
