Microsoft KB Archive/270092

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

Article ID: 270092

Article Last Modified on 1/27/2007

-

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.

Additional query words: off2001kb mac XL2001KB

Keywords: kbbug kbpending KB270092

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.