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?

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

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

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

=F31-H31

"Dave Peterson" wrote:

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

And what's in F31 and what's in H31?



kreeve wrote:

=F31-H31

"Dave Peterson" wrote:

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


--

Dave Peterson

Check to see if the same add-ins are set on both PC's. go to Tools - Addins

"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?

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?

"Joel" wrote:

Check to see if the same add-ins are set on both PC's. go to Tools - Addins

"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?