View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default worksheet protecting interefering with file links

If anyone has advice regarding this question i would very much
appreciate some sinsight as well. Thank you!

coriolis wrote:
Hi!
I have two separate excel files that are linked, and when i do not have any
password protection on the worksheets, i can save modified versions of one of
the files and use the "Edit" "Links" option to change the source file.
However, when i password protect the worksheets, i can no longer do this. Is
there a way around this so that i can have a protected worksheet with some
locked cells, but still be able to update file links?
--
thanks!!