Yep.

And the formula could give a hint what that difference is.

Good luck.

kreeve wrote:

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.

"Dave Peterson" wrote:

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

(It could be a few things.)

kreeve wrote:

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?

--

Dave Peterson


--

Dave Peterson