Works Err Msg "Cannot Save Formula" Saving Spreadsheet

MORE INFORMATION

The error message "Cannot save formula" occurs once for each formula that is invalid in Microsoft Excel. For example, the formula "=+A1-B2" is invalid in Microsoft Excel. The leading plus sign (+) in this formula is the invalid portion of the formula. If you remove the plus sign, this formula is valid in Microsoft Excel. (In Works, this plus sign indicates the sign of the number, not an operation to be carried out.) NOTE: If the spreadsheet also contains a range name that would be invalid in Microsoft Excel, you will receive the following error message when saving in the Excel format: A range name may be invalid because it contains characters other than numbers, letters, backslashes (\), or underscores (_). For example, the range name "Time/Date" is invalid because it contains a forward slash (/).

Steps to Reproduce Problem

WARNING: Following these steps causes a GP fault on your computer. You should save and close all work on your computer before following these steps.

1. Open the sample spreadsheet WINGSALS.WKS in the Works\SAMPLES directory. This spreadsheet contains an invalid formula and range name.
2. From the File menu, choose Save As.
3. In the Save File As Type box, select Excel 4.0/5.0 SS and then choose the OK button.
4. Start Microsoft Excel and open the converted WINGSALS.XLS file.