Deactivated links in Excel 2007

By rlc2cats ·
In Excel 2003 when a user opened a linked spreadsheet, he/she was asked whether or not they wanted to update links. If they did not, it would leave the values in the spreadsheet based on the last time it was saved. In the 2007 version, this option does not appear and when the user opens the file that has been sent to them, any linked data returns a #VALUE error. How do I prevent this from happening so that I can still send linked spreadsheets without having to send all of the files that link into it?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums