Microsoft KB Archive/63829

Works Err Msg: Reference Outside Spreadsheet

PSS ID Number: Q63829 Article last modified on 10-16-1998

1.00 1.05 2.00 3.00

MS-DOS

=
========================================================= 1.00 1.05 2.00 3.00 MS-DOS kbother ENDUSER

= SUMMARY =

The error message “Reference outside worksheet” has one of the following four causes:

  The spreadsheet was created in a program that allowed it to extend beyond the 256 column and 4096 row limit of Works (256 columns and 16384 rows for Works 3.0). Solution: Using the original spreadsheet program, load the file and modify it to fit Works’ limits.   The spreadsheet was written in Works with references beyond the 256 column by 4096 row limit (256 column 16384 rows in Works 3.0). At the error screen, type “Y” to view all the cells that are referencing outside the spreadsheet or “N” to view the number showing the number of errors. Solution: Change the cells affected to reference cells inside the spreadsheet limit.   A range of cells was named, then part of the range was deleted. Solution: Delete the entire range of cells.   The Works Spreadsheet or Database file was deleted, then restored using a utility program such as Norton Disk Doctor or PC Tools. Solution: Use a backup of the file.   The file has become corrupt. Use a backup copy if available. 

KBCategory: kbother KBSubcategory: dworkskb

= Additional reference words: 1.00 2.00 3.00 =

Version : 1.00 1.05 2.00 3.00 Platform : MS-DOS ============================================================================= Copyright Microsoft Corporation 1998.