Why will links not update unless source is open?
Hi WesJFrank;
Ensure that you have set the folowing settings before save the Workbook:
1. On the Tools menu, click Options
The Options dialog box appears.
2. In the Options dialog box, click the Calculations Tab.
3. Under Calculation, click the Automatic
4. Under the Workbook Options, select the Update remote references and
Save the external link values check boxes
5. Click OK
Challa Prabhu
"WesJFrank" wrote:
What does it signify when a spreadsheet will not update from its links unless
both spreadsheets involved are open under Excel? Sometimes this happens,
sometimes it doesnt. I cannot tell the divergence between the two
situations. value is the usual error message in each cell with a link.
|