XL: Error Message Clicking Undo Refresh Data on the Edit Menu

ID: Q179687

The information in this article applies to:

SYMPTOMS

If you click Undo Refresh Data on the Edit menu, you may receive one of the following error messages.

Microsoft Excel 97 for Windows

   This program has performed an illegal operation and will be shut down.
   If the problem persists, contact the program vendor.
If you click Details, you receive the following error message: 

   EXCEL caused an invalid page fault in module EXCEL.EXE at
   0137:303e9377.

Microsoft Excel 98 Macintosh Edition

   The application "Microsoft Excel" has unexpectedly quit, because
   an error of type 2 occurred.

   You should save your work in other open applications and restart
   the computer.
Or, the program may close without displaying any error messages and without allowing you to save your work.

CAUSE

This problem may occur when you do the following:

1. You return external data to a worksheet in Microsoft Excel by pointing 

   to Get External Data on the Data menu, and then clicking Create New
   Query.
2. You refresh the external data by clicking Refresh Data on the Data menu 
   or by clicking the Refresh Data tool on the External Data toolbar.
3. You clear the Save Query Definition check box in the External Data 
   Range Properties dialog box.
4. On the Edit menu, you click Undo Refresh Data.

RESOLUTION

To work around this problem, do not click Undo Refresh Data on the Edit menu if you clear the Save Query Definition check box.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

MORE INFORMATION

When you retrieve external data into a worksheet in Microsoft Excel, you can control how the external data behaves by displaying the External Data Range Properties dialog box. To do this, follow these steps:

1. Select a cell in the range that contains external data.

2. On the Data menu, point to Get External Data, and click Data Range 

   Properties. Or, click the Data Range Properties tool on the External
   Data toolbar.
If you clear the Save Query Definition check box, Microsoft Excel removes the settings you used to connect to the external data, and you can no longer refresh the external data.

Additional query words: XL97 

Keywords          : kbtool xlquery 
Version           : WINDOWS:97; MACINTOSH:98
Platform          : MACINTOSH WINDOWS
Issue type        : kbbug

Last Reviewed: January 8, 1999