Microsoft KB Archive/269273

= Works: Limitations of Sharing Files with Excel =

Article ID: 269273

Article Last Modified on 1/27/2007

-

APPLIES TO


 * Microsoft Works 7.0
 * Microsoft Works Suite 2003
 * Microsoft Works Suite 2001
 * Microsoft Works 6.0

-



This article was previously published under Q269273



SUMMARY
You can use the most frequently used features of Microsoft Excel in Microsoft Works Spreadsheet.

Some of the less frequently used features and formatting in Excel worksheets may not appear or work as expected when you open an Excel file in Works Spreadsheet.



MORE INFORMATION
The following list describes some cell features and characteristics that are available in Excel but are not retained when you open the Excel worksheet in Works Spreadsheet.
 * Cell comments
 * Data validation
 * Change tracking
 * OLE objects
 * Images and pictures
 * Macros

The following list describes some data in an Excel worksheet that may be lost or truncated when you open the Excel worksheet in Works Spreadsheet.
 * All rows greater than of 16,384 rows do not appear.
 * Data in any cell that exceeds 2,047 characters is truncated to 2,047 characters.

The following list describes some cell features and characteristics that are available in Excel but do not work as expected when you open the Excel worksheet in Works Spreadsheet.
 * Hyperlinks are changed to text only and are not functional.
 * PivotTables are converted to text data.
 * Charts are not retained and must be re-created in Works Spreadsheet.

NOTE: Worksheet or cell protection must be removed in Excel before you can open an Excel worksheet in Works Spreadsheet.

Additional query words: works7 w2003 w2002

Keywords: kbinfo kbinterop KB269273

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.