View Single Post
  #1   Report Post  
Eric
 
Posts: n/a
Default Links to other files

I have approximately 100 spreadsheets that have the prices for items that are
linked to a master price list. Each spread sheet is set to allow you to open
it without updating the links. The spread sheet will show if there has been
any change to the price. If the spread sheet is opened without updating the
links the price doesn't change.

This configuration worked for 10 months without problems. Now if I open one
spread sheet without updating the links the pricing doesn't change but if I
open a second spread sheet (they are identical other than job specific
information) without updating the links the prices are automatically being
updated in the first spread sheet. Any ideas as to why the links are
updating automatically even though it's configured to not update?