View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mariekek5 mariekek5 is offline
external usenet poster
 
Posts: 62
Default automatic updates while worksheet is protected

Hi,

I am working on an Excel document, to which different users will have access
to. I know I can protect a worksheet, and still allow users to change certain
ranges with a certain password. This is what I want. But almost all data is
based on link (via INDEX formula) to other document, which should be updates
automatically.

Is this combination possible?

Best regards,

Marieke