View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MarkT MarkT is offline
external usenet poster
 
Posts: 67
Default not allow update for workbook w/ Links

Hi,

I have a workbook (excel 2003) that contains many links to other workbooks,
but I don't want the user to update those links. I need to keep the
historical data. Is there a way to prevent a user from updating them?

When a user opens up the workbook, they get a message that states "This
workbook contains links to other data sources." and then the options to
Update or Don't update.

I can't find any settings to not allow updates.

Hope someone can help!

Thanks in advance,

Mark