Microsoft KB Archive/258781

= You receive an error message when you try to open multiple documents in Excel =

Article ID: 258781

Article Last Modified on 1/27/2007

-

APPLIES TO


 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q258781





For a Microsoft Excel 98 version of this article, see 177193.



SYMPTOMS
When you start Microsoft Excel, Excel attempts to open multiple documents and you may receive one or more of the following error messages:

This file is not in a recognizable format.
 * If you know the file is from another program which is incompatible with Microsoft Excel, click Cancel, then open this file in its original application. If you want to open the file later in Microsoft Excel, save it in a format that is compatible, such as text format.
 * If you suspect the file is damaged, click Help for more information about solving the problem.
 * If you still want to see what text is contained in the file, click OK. Then click Finish in the Text Import Wizard.



SYLK: File format not valid.

File not loaded completely.

Note that these error messages may appear more than once.



CAUSE
This problem may occur if the following conditions are true:  You click Options on the Tools menu, and then click the General tab. The folder that you specify in the Alternate startup file location box is a folder that contains files that Microsoft Excel cannot open, for example:

C:\Program Files\Microsoft Office 2000\Office

C:\Windows\Desktop



If you specify either of these folders in the Alternate startup file location box, Microsoft Excel attempts to open all of the files in the folder, including program files. Because Microsoft Excel cannot open all of these files, you receive one or more of the error messages in the &quot;Symptoms&quot; section.

Note You may have to restart your computer to stop receiving the error messages.



RESOLUTION
To resolve this problem, follow these steps:  Start Excel, and then quickly hold down the SHIFT key.

Holding down the SHIFT key prevents Microsoft Excel from opening any of the files in the alternate startup file location. After Microsoft Excel has started, release the SHIFT key.

Note If you have add-ins that load when you start Excel, you may receive the following error message:

Cannot open Microsoft Excel Add-In for editing. Please edit the source document instead.

This error appears once for each add-in that loads with Excel. Click OK for each one that appears.</li> On the Tools menu, click Options and then click the General tab.</li> Click to clear the Alternate startup file location box, and then click OK.</li> Quit and then restart Microsoft Excel.

When you do this, the problem does not occur.</li></ol>

<div class="moreinformation_section">

MORE INFORMATION
In Microsoft Excel, you can set an alternate startup file location. When you do this, all of the files in the specified folder (except for Excel templates) are automatically opened when you start Microsoft Excel. To set the alternate startup file location, follow these steps: <ol> On the Tools menu, click Options. Click the General tab.</li> In the Alternate startup file location box, type the path to the folder that contains the files that you want to open when you start Microsoft Excel, for example:

C:\My Documents\My Data Files\Excel Files\

</li> Click OK.</li></ol>

Note The alternate startup folder is not the same as the default file location (default working folder).

An alternate startup folder is a folder in addition to the Xlstart folder that contains workbooks or other files that you want opened automatically when you start Microsoft Excel. The alternate startup folder can be a location on a shared network drive. Templates placed in this folder are available in the New dialog box (click New on the File menu).

The default file location (default working folder) is the folder that appears in the Open and Save As dialog boxes.

<div class="references_section">