The information in this article applies to:
SYMPTOMSWhen you try to create a data source for a Microsoft Excel 97 for Windows workbook, you may receive the following error message:
CAUSEThis problem may occur if all of the following conditions are true:
-and- -and- WORKAROUNDMethod 1: Remove the workbook passwordTo work around this problem, remove the password from the workbook. To do this, follow these steps:
Method 2: Open the file in ExcelIf you have the password protected workbook open in Microsoft Excel, you will be able to successfully create a data source for this workbook. However, you must have this workbook open when you use this data source or when you refresh a query that is pulling data from this data source.STATUSThis is by design of Microsoft Excel 97 for Windows. REFERENCESFor more information about workbook passwords, click Contents And Index on the Help menu, click the Index tab in Microsoft Excel Help, type the following text passwords, workbooksand then double-click the selected text to go to the "Require a password to open or use data in a workbook" topic. If you are unable to find the information you need, ask the Office Assistant. Additional query words: XL97
Keywords : kbdta xlquery |
Last Reviewed: October 30, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |