what about the update links option in Edit=Links.

--
Regards,
Tom Ogilvy


"DaveyC4S" wrote in message
...
Hi everyone

I have a shared workbook which is updated on a daily basis by around 5
different people on the same network. Some users reconfigure links to
their
own MS Excel files and when they save the shared workbook all appears
normal.

When other users subsequently access the file they see #REF! in the cells
previously updated with new links.

I understand that this limitation is documented within Microsoft help and
the only way around it is to click into each cell containing #REF!

Is there a way I can provide a facility to automatically refresh these
links
without visiting each cell separately?

Any help very much appreciated.
Dave