Posted by Greg Marshall on August 02, 2001 3:17 PM
Here is my issue: When I create a file with external links to other files and send that file by email or another user attempts to open the file from a shared server, they select "no" when prompted whether they want to update the links to the external files. When they decline to update links, all formulas with external references return "#value!". I recently changed PC's and never had this issue before now - typically the last populated dataset remains present in addition to the underlying formulas. Any ideas?? Thanks in advance for any suggestions or ideas on how I might address this problem. Please let me know if I have not articulated sufficiently and I'll try to explain further.