Microsoft KB Archive/184670

= XL98: Cannot Save Document After Losing Network Connection =

Article ID: 184670

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q184670



SYMPTOMS
If a macro is running when you lose a connection to a shared disk (network share) from which you opened your workbook, you may receive the following error message when you try to save your file:

Microsoft Excel cannot access the file 'hard disk:share'. There are Several possible reasons:
 * The file name or path name dos not exist.
 * The file you're trying to open is being used by another program. Close the document in the other program, and try again.
 * The name of the workbook you're trying to save is the same as the name of another document that is read-only. Try saving the workbook with a different name.

If you try to save the workbook to the local hard disk or to another shared disk, you may receive the following error message:

Document not saved.



CAUSE
This problem may occur because of the way in which the file is loaded into memory from a shared disk.



RESOLUTION
To save the workbook, copy the contents of the workbook to a new workbook. Then, save the new workbook.

To copy a worksheet, follow these steps:
 * 1) Press CONTROL and click the tab for the sheet. Then, click Move Or Copy on the shortcut menu.
 * 2) In the Move Or Copy dialog box, click (new book) in the To Book list.
 * 3) Click the Create A Copy check box.
 * 4) Click OK.

If you want to save the macros, start the Visual Basic Editor and copy the text of the modules into new modules that you have inserted into the new workbook. There is no way to copy the module sheet as an object into the new workbook.



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

Additional query words: XL98 hang

Keywords: kbbug kbnetwork kbprogramming kbpending KB184670

-

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

© Microsoft Corporation. All rights reserved.