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
 

======================================================================
 
----------------------------------------------------------------------
The information in this article applies to:
 
 - Microsoft Works for the Macintosh, versions 4.0, 4.0a, and, 4.0b
----------------------------------------------------------------------
 
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.
 
1. Open the document in Excel 4.0 or 5.0.
 
    a. On the File menu, click Save As.
 
    b. For Excel version 5.0, click Microsoft Excel Workbook
       in the Save File As Type dialog box.
 
    c. 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.
 
2. Open the document in Excel.
 
    a. Highlight the information desired.
 
    b. On the Edit menu, click Copy.
 
    c. Open a new Spreadsheet file in Works 4.0
 
    d. On the Edit menu, click Paste.
 
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.