Microsoft KB Archive/136307

Mac Works 4.0 Spreadsheet:Excel 4.0 Files Not Converted Properly

PSS ID Number: Q136307 Article last modified on 10-22-1998

4.0 4.0a 4.0b

MACINTOSH

=
=========================================================

= SYMPTOMS =

There may be incorrect numbers in your spreadsheet after you convert an Excel 4.0 for the Macintosh file to Works 4.0 for the Macintosh. Large negative numbers that were originally in a Excel 4.0 file may convert to large positive numbers when opened in Works 4.0.

Examples of this are:

-268435455 converts to 805306369 -134217727 converts to 939524097 -67108863 converts to 1006632961

= RESOLUTION =

NOTE: Works 4.0 fails to convert Excel 4.0 documents only. Excel 3.0 and 5.0 documents convert with no errors.

To resolve the problem, try one of the following solutions.

  Open the document in Excel 4.0 or 5.0.   On the File menu, click Save As.   For Excel version 5.0, click Microsoft Excel Workbook in the Save File As Type dialog box.   For Excel version 4.0, click Options in the Save As dialog box. In the File Format dialog box, click Excel 3.0. 

Open the newly saved file in Works 4.0.   Open the document in Excel.   Highlight the information desired.   On the Edit menu, click Copy. </li>  Open a new Spreadsheet file in Works 4.0 </li>  On the Edit menu, click Paste. </li></ol> </li></ol>

= STATUS =

Microsoft has confirmed this to be a problem in Works version 4.0. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

= MORE INFORMATION =

This problem only appears to affect negative numbers; positive numbers should convert normally. Also, large negative numbers are more likely to be affected than smaller numbers.

= Additional query words: 4.0, 4.0a, 4.0b mac m_works mwksss =

Version : 4.0 4.0a 4.0b Platform : MACINTOSH ============================================================================= Copyright Microsoft Corporation 1998.