The information in this article applies to:
SYMPTOMSWhen you open a file located on a Web server and save the workbook, your changes are not saved, and you do not receive an error message. CAUSEThis problem occurs when you do the following:
WORKAROUNDExcel actually saves your changes, but to a different folder. To determine this folder, click Options on the Tools menu. Click the General tab and note the Default file location. The workbook you saved will be in this folder instead of the folder on the HTTP or FTP Web server where you opened the read-only file. STATUSMicrosoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. MORE INFORMATION
You can open workbooks that are stored on HTTP or FTP sites on either your intranet or the World Wide Web. To do this, type the address of the file you want to open, in the File name box of the Open dialog box. However, if you save the same read-only workbook using a Visual Basic macro, no error message will appear and the workbook will appear to save. However, when you close and reopen the same workbook from the Web server, the changes do not appear to have been saved. To open the workbook containing the new changes, open the workbook from the location specified in the Default file location of the Options dialog box. Additional query words: OFF2000 XL2000
Keywords : kbdta kbweb |
Last Reviewed: May 24, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |