View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chris Chris is offline
external usenet poster
 
Posts: 788
Default Update Files Automatically with Links

Here is my dilemma. I have several files that have a link to a pricing
sheet. I normally have to change the price and then open and update each
file to show the changes I made on the link page. Is there a short cut where
when I update the link page and save it that it would automatically update
all the pages it is linked too? I have so many files it almost takes half a
day to open and close every file to update the links. Any help would be
appreciated.
Thanks
Chris