Characters with Accents Not Recognized in Multiplan File (115903)

SYMPTOMS

When you open a Microsoft Multiplan file that contains characters with accents, the characters are not recognized. If you have saved the file in Multiplan to the Microsoft Excel file format, and you save the file again to the native Microsoft Multiplan format, these characters are displayed as the pipe symbol (|).

CAUSE

This behavior occurs only when you save the file in Microsoft Multiplan to the Microsoft Excel file format, and then save the same file to the native Multiplan file format.

WORKAROUND

To avoid losing accent marks when you open a file created in Microsoft Multiplan file, save the file to the native Multiplan file format only, and then open the file in Microsoft Excel. Do not save the file to the Microsoft Excel file format. In Microsoft Excel version 5.0, you can open native Microsoft Multiplan files (this method is preferred over opening files saved from Microsoft Multiplan to the Microsoft Excel file format).

MORE INFORMATION

The following may also occur when you open a file in Microsoft Excel that has been saved from Microsoft Multiplan to the Microsoft Excel file format:

External references are lost
Font attributes, such as bold and italic, are lost
Some formulas cause Microsoft Excel to crash
Other formatting such as default column width is lost

These things do not occur when you save the Multiplan file to the Normal Multiplan file format, and then open the file in Microsoft Excel.

For more information about opening Multiplan files in Microsoft Excel, query on the following words in the Microsoft Knowledge Base:

5.0 and reads and multiplan and format

REFERENCES

For more information about Multiplan files and Microsoft Excel, choose the Search button in Help and type:

Multiplan