Error Editing/Saving File When Can't Access File on Disk
This article was previously published under Q114440
This article has been archived. It is offered "as is" and will no longer be updated.
In Microsoft Excel, if you remove a floppy disk or disconnect from anetwork drive that contains a workbook file that you are editing, anerror message appears when you continue editing the workbook. Theerror message that you receive depends on the data that is containedin the workbook you are editing and the types of changes you make to theworkbook. The following is a summary of these error messages and whenyou receive them.
Linked or Embedded ObjectIf the workbook contains a linked or embedded object, when you editthe object or create another object, you receive the following errormessages:
- Editing or inserting an embedded or linked objectCannot start source application
- Pasting a new linked or embedded objectCannot paste data
Visual Basic ModuleIf the workbook contains a Visual Basic module, and you try to run aprocedure contained in the module, or to insert a new module in theworkbook, you receive the following error message:
Unable to read from the disk
Pivot TablesIf the workbook contains a pivot table, and you attempt to edit thepivot table, the following error message appears:
Unable to obtain PivotTable data from diskNote that you can create a new pivot table in the workbook under theabove conditions without receiving an error message, even if theworkbook already contains a pivot table.
Saving FileWhen you save a workbook file to another location, such as your hard diskdrive, the following error message appears if the workbook file contains apivot table, linked or embedded object, or a Visual Basic module, and youdo not have access to the disk that contains the workbook file:
Document not savedNote that when you save a workbook that contains a Visual Basicmodule, you may also receive the following error message:
Unable to write to the disk
In Microsoft Excel version 5.0, workbook files are not storedentirely in memory. Some elements of the workbook are stored on thedisk your file is stored on. This is a change from the way theearlier versions of Microsoft Excel stored files.
When you create a pivot table, an OLE object, or a Visual Basicmodule in a workbook, you must have continuous access to the drive thatcontains the workbook, because these items are stored on the drive.
To avoid running into problems when you are working on files off of afloppy or a network drive, do not remove the floppy or disconnectfrom the network drive until you have closed the file you are workingon.
To avoid receiving an error message in any of the above situations,you must insert the floppy disk, or connect to the network drive thatcontains the workbook file. You can then edit and create OLE objects,pivot tables and Visual Basic modules, and you can also save theworkbook file.
When you open a new workbook file in Microsoft Excel, two temporaryfiles are created in your TEMP directory. The location of your TEMPdirectory is determined by the SET TEMP statement in yourAUTOEXEC.BAT file. The two temporary files have names similar to thefollowing:
These files created because Microsoft Excel version 5.0 uses theDocfile format in object linking and embedding (OLE) version 2.0.
When you open an existing workbook, a temporary file is createdeither in your TEMP directory or in the directory that contains thefile.
err msg XL
Article ID: 114440 - Last Review: 10/26/2013 06:53:00 - Revision: 2.0
Microsoft Excel 95 Standard Edition
- kbnosurvey kbarchive KB114440