XL2000: Error Message: Cannot Open Consolidation Source File (214088)


The information in this article applies to:

  • Microsoft Excel 2000
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 filename
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.
Modification Type:MajorLast Reviewed:10/8/2003
Keywords:kberrmsg kbprb KB214088
©2003 Microsoft Corporation. All rights reserved.