LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 19
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
file links incorrect when file is re-opened s-steege Excel Worksheet Functions 2 November 8th 08 11:26 PM
Include password in formula that links to a protected excel file PR2000 Excel Discussion (Misc queries) 1 June 26th 07 07:16 PM
Problems with my links to an excel 2007 file from a word 2007 file sc Links and Linking in Excel 0 February 21st 07 10:12 AM
file links - arrays??? dh Excel Worksheet Functions 4 May 19th 05 07:07 PM
Automatic update of links in destination file when source file mo. Brucgil Excel Discussion (Misc queries) 0 December 2nd 04 04:07 PM


All times are GMT +1. The time now is 08:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"