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.
Symptoms
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 Object

If 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 object
    Cannot start source application
  • Pasting a new linked or embedded object
    Cannot paste data

Visual Basic Module

If 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 Tables

If the workbook contains a pivot table, and you attempt to edit thepivot table, the following error message appears:
Unable to obtain PivotTable data from disk
Note 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 File

When 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 saved
Note 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
Cause
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.
Workaround
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.
More information
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:

   ~1808.TMP   ~DFT180D.TMP				


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
Properties

Article ID: 114440 - Last Review: 10/26/2013 06:53:00 - Revision: 2.0

Microsoft Excel 95 Standard Edition

  • kbnosurvey kbarchive KB114440
Feedback