Works: Limitations of Sharing Files with Excel (269273)


The information in this article applies to:

  • Microsoft Works 7.0
  • Microsoft Works Suite 2003
  • Microsoft Works Suite 2001
  • Microsoft Works 6
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.
Modification Type:MinorLast Reviewed:11/30/2002
Keywords:kbinfo kbinterop KB269273
©2002 Microsoft Corporation. All rights reserved.