Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula links in file
We have a master data file that about 50 other related spreadsheets have
formula links to. Permission to this master file has now been restricted for many people so when they open some of the other 50 files the links don't work to master file. Can we cut and paste (rather than just copy) the master file to another location and will the links follow the file to the new location? If not, is there a bulk way of changing the addresses in the formulas to the new location of the master file. Ideally for all 50 at once or at worst for all tabs in each file at once. Thanks Rick |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula links in file
You can change the links one by one following prompts when opening workbooks
after master is reproduced in new location, or write a macro looping through all workbooks, opening them and change links with such a VBA line: ActiveWorkbook.ChangeLink Name:="old_location_and_name.xls", NewName:= _ "new_location_and_name.xls", Type:= _ xlExcelLinks -- Regards! Stefi €žRD€ ezt Ã*rta: We have a master data file that about 50 other related spreadsheets have formula links to. Permission to this master file has now been restricted for many people so when they open some of the other 50 files the links don't work to master file. Can we cut and paste (rather than just copy) the master file to another location and will the links follow the file to the new location? If not, is there a bulk way of changing the addresses in the formulas to the new location of the master file. Ideally for all 50 at once or at worst for all tabs in each file at once. Thanks Rick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
file links incorrect when file is re-opened | Excel Worksheet Functions | |||
Include password in formula that links to a protected excel file | Excel Discussion (Misc queries) | |||
Problems with my links to an excel 2007 file from a word 2007 file | Links and Linking in Excel | |||
file links - arrays??? | Excel Worksheet Functions | |||
Automatic update of links in destination file when source file mo. | Excel Discussion (Misc queries) |