Even if the user isn't allowed to update links when they open the workbook, they
could use Edit|Links to update them or even hit F2, Enter on one of the cells
(or anything that would cause those links to be updated).

You may want to consider changing the formulas to values in the workbook that
you share with others.

MarkT wrote:

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

--

Dave Peterson