XL98: Header and Footer Not Saved in Lotus 1-2-3 File Formats (176007)


The information in this article applies to:

  • Microsoft Excel 98 Macintosh Edition
This article was previously published under Q176007

SYMPTOMS

When you save a file in the Lotus 1-2-3 file format in Microsoft Excel 98 Macintosh Edition, and then reopen it, the header and footer may be missing or corrupted.

CAUSE

This problem may occur when you save the file in the following file formats: 
   WK3 (1-2-3)
   WK1 (1-2-3)
   WKS (1-2-3)

WORKAROUND

To work around the problem, save the file in the one of the following file formats: 
   WK3,FM3 (1-2-3)
   WK1,FMT (1-2-3)
   WK1,ALL (1-2-3)
When you save the file in one of these formats, two files are created. One file contains the formulas and values that are in the worksheet while the other file contains the formatting you used in the worksheet. You must include both files if you want to distribute this workbook to another user.

The following table lists the files that Microsoft Excel saves with each file format. In this example, the file that is saved is named "Mybook." 
   File format          File names
   ---------------------------------------

   WK3,FM3 (1-2-3)      Mybook, Mybook.fm3
   WK1,FMT (1-2-3)      Mybook, Mybook.fmt
   WK1,ALL (1-2-3)      Mybook, Mybook.all

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

REFERENCES

For more information about saving files to non-Excel file formats, click the Index tab in Microsoft Excel Help, type the following text

saving files, file formats

and then double-click the selected text to go to the "View or save files from other programs as Microsoft Excel workbooks" topic.
Modification Type:MajorLast Reviewed:9/11/2002
Keywords:kbbug kbprint KB176007
©2002 Microsoft Corporation. All rights reserved.