We have an Excel file that is accesed by many computers multiple times a day. Most every row in the file has a hyperlink associated with it. Every once in a while someone has the box "Update Links on Exit" checked and it messes up all the hyperlinks. Is there a way that we can use a macro or something else that is embedded in the file that ensures that if the attribute UpdateLinksOnSave = False? This file will be opened mainly by people that this is already false for in Excel. For the most part this is taken care of by making sure that all copies have this setting correct, but sometimes it slips through the cracks. Thoughts?

Thank you in advance for any help!!!

Paul Silzle