Excel and Lotus DIF File Differences

View products that this article applies to.

Article ID	:	60997
Last Review	:	February 20, 2004
Revision	:	1.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:

	A	B	C	D
1		1989	1988	1987
2	MARY	10	8	5
3	SAM	9	8	6

	EXCEL	LOTUS
VECTORS	0,3	0,4
TUPLES	0,4	0,3

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.

APPLIES TO

Microsoft Excel 95 Standard Edition

Back to the top

	17.376.995	Kostenlose Z�hler
In memoriam C-BIT Information-Center Hannover (2.241/1075+2.241/1076 - no longer active)
Free webspace
Sicherheitshinweis: Wir weisen vorsorglich darauf hin, dass wir bei der Anmeldung saemtliche automatisch uebermittelten Parameter wie IP-Adresse und/oder Einwahlrufnummer speichern, um uns und unsere Kunden vor Missbrauch zu schuetzen. Selbstverstaendlich werden wir bei Bedarf umgehend strafrechtliche Massnahmen ergreifen, um einen vorliegenden Missbrauch zu ahnden.