Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. XL2000: Error Message: Cannot Open Consolidation Source File

XL2000: Error Message: Cannot Open Consolidation Source File

View products that this article applies to.

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

↑ Back to the top

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.

↑ Back to the top

Keywords: KB214088, kbprb, kberrmsg

↑ Back to the top

Article Info
Article ID : 214088
Revision : 4
Created on : 10/8/2003
Published on : 10/8/2003
Exists online : False
Views : 352