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

• Microsoft Excel 98 Macintosh Edition

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)

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