XL2001: Prompt for Filename Option Has No Effect When Refreshing Data Imported from FileMaker Pro (270092)


The information in this article applies to:

  • Microsoft Excel 2001 for Mac
This article was previously published under Q270092
The third-party products that are discussed in this article are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.

SYMPTOMS

When you import data from a FileMaker Pro database, you can set an option in the External Data Range properties to make Microsoft Excel prompt you for the file name each time that you refresh the data. However, the Prompt for file name on refresh option does not remain selected, and you are not prompted for the file name when you refresh the data.

CAUSE

This behavior occurs because Excel does not prompt users for a FileMaker Pro file name when the data is refreshed, and the Prompt for file name on refresh option is erroneously available when you import a FileMaker Pro file.

STATUS

Microsoft has confirmed that this is a problem in Microsoft Excel 2001 for Mac.

MORE INFORMATION

For more information about retrieving data from an external database, follow these steps:
  1. On the Help menu, click Contents and Index, click Index, and then click D.
  2. Scroll down until you locate data, and then click the arrow to the left to view a list of topics under the general topic.
  3. Click Ways to retrieve data from an external database.
If you cannot find the information that you want, ask the Office Assistant.

Modification Type:MajorLast Reviewed:9/11/2002
Keywords:kbbug KB270092
©2002 Microsoft Corporation. All rights reserved.