Working with links

[learningguru1978]

I hope I am able to explain this properly.

I have a document made up of multiple worksheets and I have linked the date
from one worksheet to a graph on a different workseet. This is a company
document that will have to go out to many people. When other users open
the documents, it asks them if they want to update the links. Even if they
hit yes the links do not update and are all broken. Is there any way I can
get these links to work for everyone without Microsoft asking them to update
the links and then having them break?

 

[muddan madhu]

try this

go to edit | links | click update values | click startup prompt |
choose : don't display the alert & don't update automatic links | ok |
close

 

[learningguru1978]

Thanks Muddan. I think what I am looking for is slightly different. First,
I am using MS Excel 2007 (sorry, I shoud have said that).

What I am looking for is for the links that I have created to remain intact
when other people open the workbook, thus there will never even be an error
message to start with. I think what you explained was how to disable the
message if I open up the document. Does this make sense?