Try clicking Tools Options Edit tab,
uncheck "Ask to update automatic links" OK
Save the book. Then re-open to test it out.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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