external link update trouble

denman_351 · Mar 20th, 2002, 08:20 AM

Problem:

Workbook A with charts has links to workbook B and will only update when both files are open. This is fine when local people are trying to view from network, when workbook A is emailed and parties do not have access to workbook B how do I send workbook A out so update is not necessary and #value error is not shown?

RaoulF · Mar 20th, 2002, 09:49 AM

You could ask the recipients to set their calculation options (under Tools/ Options) to Manual and uncheck 'Recalculate before save'. Obviously they will not be able to F9 without losing everything to the #Value!

Alternativly paste/special/ values into a new workbook, then there's no chance of the error.

denman_351 · Mar 20th, 2002, 09:54 AM

Thank you.

The manual option works great.

What I noticed is, if I save the file before emailing with the manual update option, things are all good and the end user didnt have to do anything but open the file...

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 20th, 2002, 08:20 AM	#1
denman_351 New Member Join Date: Mar 2002 Posts: 3	Problem: Workbook A with charts has links to workbook B and will only update when both files are open. This is fine when local people are trying to view from network, when workbook A is emailed and parties do not have access to workbook B how do I send workbook A out so update is not necessary and #value error is not shown?

Mar 20th, 2002, 09:49 AM	#2
RaoulF New Member Join Date: Mar 2002 Location: London, UK Posts: 17	You could ask the recipients to set their calculation options (under Tools/ Options) to Manual and uncheck 'Recalculate before save'. Obviously they will not be able to F9 without losing everything to the #Value! Alternativly paste/special/ values into a new workbook, then there's no chance of the error.

Mar 20th, 2002, 09:54 AM	#3
denman_351 New Member Join Date: Mar 2002 Posts: 3	Thank you. The manual option works great. What I noticed is, if I save the file before emailing with the manual update option, things are all good and the end user didnt have to do anything but open the file...