Thread: #VALUE error
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default #VALUE error

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