Microsoft KB Archive/76401

= Err Msg in Formula: Reference Not Valid or Wrong Operand Type =

Article ID: 76401

Article Last Modified on 11/16/2006

-

APPLIES TO


 * Microsoft Works 2.0 Standard Edition
 * Microsoft Works 2.0a
 * Microsoft Works 3.0 Standard Edition

-



This article was previously published under Q76401



SYMPTOMS
You may receive the following error message in Works for Windows:

Reference not valid or wrong operand type



RESOLUTION
To resolve the above error message in the Spreadsheet or Database module, use the following steps:


 * 1) Check to make sure each parameter highlighted in the formula bar is typed correctly.
 * 2) Refer to the Appendix A in the &quot;Works for Windows User's Guide&quot; (for version 2.x) to verify the correct syntax is being used.
 * 3) If steps 1 and 2 do not correct the problem, type =SUM(1,2) in an empty Spreadsheet cell. If the error message &quot;Operator missing or not valid&quot; is displayed, the list separator in the Control Panel is probably a character other than a comma . To check the list separator, start the Windows Control Panel from Windows Program Manager. Double-click the International icon and verify that the list separator is a comma. If this entry is a character other than a comma, change it back to a comma, and choose OK.

Additional query words: 2.00 2.0 errmsg 3.00

Keywords: KB76401

-

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

© Microsoft Corporation. All rights reserved.