XL2000: Error or Page Fault Linking to Workbook or Creating Formula

When you enter a formula to create a link from one workbook to another workbook in Microsoft Excel, you may receive an error message similar to the following:
If you click Details, you receive an error message similar to the following
and Microsoft Excel quits.

This problem occurs when the following conditions are true:

• The values in the workbook to which you are linking are not recalculated before you save the file, and this workbook is not open.
  
  NOTE: For information about how this situation can occur, see the "More Information" section later in this article. -and-
  
  
• The workbook in which you are entering the formula is stored in a different folder from the folder that contains the workbook to which you are linking.
  
  As a result, when you enter the formula to link to the other workbook, a File Not Found dialog box appears and you are prompted to select the correct workbook.

When you select the correct workbook and click OK, you receive the error message in the "Symptoms" section of this article.

To work around this problem, include the complete path to the other workbook when you enter the formula. For example, instead of this formula
type this formula:
NOTE: When you include the complete path and enter the formula, you receive the following error message:
However, the problem described in the "Symptoms" section in this article does not occur.

You can also prevent this problem from occurring by recalculating workbooks before you save them.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

In Microsoft Excel, you may save a workbook in an uncalculated state if you follow these steps:

1. On the Tools menu, click Options. Click the Calculation tab.
2. Click Manual, and click to clear the Recalculate before save check box.
3. Click OK.
4. Make a change to the workbook that would normally force calculation; for example, enter a formula in cell A1.
5. On the File menu, click Save, and then save the workbook.

If you enter a formula that links to this workbook, and then select the workbook in the File Not Found dialog box, the problem described in this article may occur.