Microsoft KB Archive/214088

= XL2000: Error Message: Cannot Open Consolidation Source File =

Article ID: 214088

Article Last Modified on 10/8/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q214088





SYMPTOMS
In Microsoft Excel 2000, if you use the Consolidate command to consolidate closed files that are saved in text, CSV, SYLK, DIF, or dBASE (DBF 2, DBF 3, or DBF 4) file formats, you receive the following error message:

Cannot open consolidation source file

You receive this error message for each file that you want to consolidate. This error message is followed by the following error message:

No data was consolidated



WORKAROUND
If the source files are formatted in text, CSV, SYLK, DIF, or dBASE (DBF 2, DBF 3, or DBF 4) file formats, open the files before you run the Consolidation command.

For the Consolidation command to work properly on a closed file, the file must be saved in either the Microsoft Excel file format (Normal) or the Lotus 1-2-3 (WKS, WK1, or WK3) file format.

Additional query words: link alert file combine XL2000

Keywords: kberrmsg kbprb KB214088

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.