XL98: Cannot Save Document After Losing Network Connection

ID: Q184670


The information in this article applies to:
  • Microsoft Excel 98 Macintosh Edition


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 : kbnetwork kbprg kbdta xlloadsave
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbbug


Last Reviewed: August 3, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.