Whenever I use formulas in lookup functions (v-lookup, h-lookup and index),
then I save the spreadsheet and close it, when I open the file again, MS
imbeds in my lookup functions formula +1-1. This is added each time I save
and close. I could end up having many +1-1's and eventually causes an error
in the program. If I use regular numbers, i.e. 1, 4, 8, the +1-1 does not
occur.

I am using Microsoft Works 8.0.

What's going on???
--
cityboyjerry

Suggest you present this problem in a news group dedicated to MS Works.

This is an MS Excel group and the two applications are not the same other than
they both use columns and rows.


Gord Dibben MS Excel MVP

On Wed, 27 Feb 2008 11:05:03 -0800, cityboyjerry
wrote:

Whenever I use formulas in lookup functions (v-lookup, h-lookup and index),
then I save the spreadsheet and close it, when I open the file again, MS
imbeds in my lookup functions formula +1-1. This is added each time I save
and close. I could end up having many +1-1's and eventually causes an error
in the program. If I use regular numbers, i.e. 1, 4, 8, the +1-1 does not
occur.

I am using Microsoft Works 8.0.

What's going on???