The information in this article applies to:
SYMPTOMSIn Microsoft Excel version 5.0, when you open a workbook that was previously saved in Microsoft Excel version 7.0 with the "Allow Multi-User Editing" option turned on, you will receive the following message where <filename> is the file you are trying to open. The file can still be opened by clicking the Read Only button. However, if you type a password in the Password box, the password will be considered invalid. CAUSEThis problem occurs because the workbook that you are opening was saved from Microsoft Excel version 7.0 as a shared file with "Allow Multi-User Editing." Because Microsoft Excel version 5.0 does not support sharing files between multiple users at the same time, you receive the error message. WORKAROUNDTo work around this problem, use any of the following methods. Method 1If you are using Microsoft Excel version 7.0 for Windows 95, open the file in Microsoft Excel version 7.0 and re-save the workbook with "Allow Multi- User Editing" disabled. To do this, click Share Lists on the File menu. Select the Editing tab and clear the Allow Multi-User Editing check box.Method 2Open the file in Microsoft Excel version 5.0 as a read-only document. Then, save the file with a different name.MORE INFORMATION
This behavior is by design. The password dialog box prevents the file from
being opened with write access privileges.
REFERENCESFor more information about Shared Lists, click the Index tab in Microsoft Excel 7.0 Help, type the following text shared listsand then double-click the selected text to go to the "Sharing a list with other people" topic. Additional query words: 7.00 xl 95
Keywords : kberrmsg kbinterop |
Last Reviewed: October 8, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |