Microsoft KB Archive/60997

= Excel and Lotus DIF File Differences =

PSS ID Number: 60997

Article Last Modified on 1/30/2002

-

The information in this article applies to:


 * Microsoft Excel for Windows 95 7.0

-



This article was previously published under Q60997



SUMMARY
A DIF (Data Interchange Format) file created by Microsoft Excel differs from one created by Lotus 1-2-3. This may pose a problem for those programs such as Charting Gallery, which require imported data to be Lotus DIF compatible.



MORE INFORMATION
All parts of Lotus and Excel DIF files are similar except for the VECTORS and TUPLES entries. The following table would create the respective VECTORS and TUPLES entries in a DIF file:

In order to make the Microsoft Excel DIF file compatible with the Lotus format, use a text editor and swap the VECTORS and TUPLES number entries.

Keywords: KB60997

Technology: kbExcel95 kbExcel95Search kbExcelSearch kbExcelWinSearch

-

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

© 2004 Microsoft Corporation. All rights reserved.