XL: Error Messages When Accessing Files from Floppy Disks

CAUSE

Microsoft Excel for Windows can run only when a file-sharing program, such as Share.exe or Vshare.386, is running.

NOTE: Microsoft Windows 95 provides built-in file sharing.

The error messages occur because of the way in which the file-sharing program keeps track of open files. When you open a file from a floppy disk, the serial number (if one exists) of the floppy disk (for example, 2B4A-1ACA), is read into memory. If you attempt to open a file from a floppy disk that has a different serial number while the first file is still open, you will receive an error message.

Note also that a disk formatted with the Format command (included with MS- DOS versions 5.0 and later) will be assigned a serial number.

WORKAROUNDS

If your files are stored on floppy disks that do not have serial numbers, you may be able to open files without receiving an error message.

Opening Files from Floppy Disks

To avoid receiving an error message when you open files from floppy disks, copy the files to your hard disk before you open them.

This is the recommended workaround because opening files from and saving files to the hard disk drive is faster than using a floppy disk drive; in addition, saving to the hard disk drive allows you to avoid problems caused by lack of space on floppy disks.

In Windows 95, you can work around the save error message by saving the file to the original floppy disk before inserting a different disk.

Other Ways to Avoid Getting These Error Messages

• Use a third-party disk formatting program, such as the Sformat (Safe Format) program included with Symantec's Norton Utilities, to format your floppy disks. These programs often do not place a serial number on floppy disks.
  
  -or-
• Format the floppy disks in a computer running MS-DOS 4.0 or earlier. Versions 2.x, 3.x, and 4.0 of MS-DOS do not place serial numbers on floppy disks when they are formatted.

Saving a File to a Different Floppy Disk

If you open a file from a floppy disk and then remove that floppy disk from the disk drive before you close the file, you may receive the error message "Filename is not valid" when you click Save on the File menu. This error message appears if the path for the new file is not applicable to the new floppy disk.

For example, if you open the file A:\Test\Alpha.xls, remove the floppy disk from drive A, and then insert a new disk into drive A, clicking Save on the File menu only works if there is a Test folder on drive A.