#VALUE error

K

kreeve

we are on a terminal server environment, when I bring up a spreadsheet on my
computer, I get #value errors in multiple formulas. when my coworker brings
up the very same spreadsheet on her computer, the formulas result with a "-"
representing a zero value in the formula. this is happening on multiple
spreadsheets, I had many of them open yesterday and no problems. today when
I open them up, #value everywhere. why on my machine and not hers?
 
D

Dave Peterson

I bet you'll get a lot better guesses if you share one of the offending
formulas.

(It could be a few things.)
 
K

kreeve

Thanks Joel, just did and they are the same. We also checked all of the
options under tools and they are also the same. Any other ideas?
 
K

kreeve

Thanks Dave, but since the error doesn't occur when a coworker opens the SAME
spreadsheet, I did not feel the formula in the spreadsheet is the offender.
It must be some setting that I have different from her.
 
K

kreeve

formulas pulling from the F9 "add in" we have installed.

I'm grateful for the help, but I'm lost as to how or why it would be the
formula. We have been using these same spreadsheets for months, no issues.
Yesterday, no issues. Anybody else's machine (same spreadsheets), no issues.
My machine, today - errors. If it is the formula, wouldn't it return the
same errors regardless of who's machine is opening the spreadsheet?
 
D

Dave Peterson

I'm not saying it's the formula.

I'm saying that the formulas may give a hint on what's going wrong.

What do those formulas in F31 and H31 evaluate to?

If they're returning errors, maybe you lost your addin...


formulas pulling from the F9 "add in" we have installed.

I'm grateful for the help, but I'm lost as to how or why it would be the
formula. We have been using these same spreadsheets for months, no issues.
Yesterday, no issues. Anybody else's machine (same spreadsheets), no issues.
My machine, today - errors. If it is the formula, wouldn't it return the
same errors regardless of who's machine is opening the spreadsheet?
Click to expand...
 
D

Dave Peterson

If they evaluate to - (real dashes--not a number format), then you can't do
arithmetic with them.

=n(f31)+n(h31)
may work as a replacement formula.

they evaluate to "-" in place of zeros based on the individual cell format.
Click to expand...
 
D

Dave Peterson

or
=sum(f31,h31)



Dave said:
If they evaluate to - (real dashes--not a number format), then you can't do
arithmetic with them.

=n(f31)+n(h31)
may work as a replacement formula.
Click to expand...
 
Top