| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#VALUE error
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#VALUE error
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#VALUE error
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#VALUE error
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#VALUE error
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#VALUE error
=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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#VALUE error
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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#VALUE error
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? "Dave Peterson" wrote: 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 |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#VALUE error
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... kreeve wrote: 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? "Dave Peterson" wrote: 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 -- Dave Peterson |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#VALUE error
Or maybe you chose not to update links when you opened the workbook?
Dave Peterson wrote: 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... kreeve wrote: 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? "Dave Peterson" wrote: 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 -- Dave Peterson -- Dave Peterson |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#VALUE error
they evaluate to "-" in place of zeros based on the individual cell format.
"Dave Peterson" wrote: 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... kreeve wrote: 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? "Dave Peterson" wrote: 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 -- Dave Peterson |
|
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#VALUE error
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. kreeve wrote: they evaluate to "-" in place of zeros based on the individual cell format. "Dave Peterson" wrote: 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... kreeve wrote: 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? "Dave Peterson" wrote: 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 -- Dave Peterson -- Dave Peterson |
|
#14
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#VALUE error
or
=sum(f31,h31) Dave Peterson wrote: 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. kreeve wrote: they evaluate to "-" in place of zeros based on the individual cell format. "Dave Peterson" wrote: 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... kreeve wrote: 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? "Dave Peterson" wrote: 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 -- Dave Peterson -- Dave Peterson -- Dave Peterson |
|
#15
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#VALUE error
Presumably you intended to say =sum(f31,-h31) ?
-- David Biddulph "Dave Peterson" wrote in message ... or =sum(f31,h31) Dave Peterson wrote: 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. kreeve wrote: they evaluate to "-" in place of zeros based on the individual cell format. "Dave Peterson" wrote: 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... kreeve wrote: 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? "Dave Peterson" wrote: 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 -- Dave Peterson -- Dave Peterson -- Dave Peterson |
|
#16
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#VALUE error
Same with the N() version, too.
David Biddulph wrote: Presumably you intended to say =sum(f31,-h31) ? -- David Biddulph "Dave Peterson" wrote in message ... or =sum(f31,h31) <<snipped |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error: "Excel encountered an error and had to remove some formatti | Excel Discussion (Misc queries) | |||
| Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
| I have Error 1919 Error Configuring ODBC dataSource Database | Excel Discussion (Misc queries) | |||
| Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) | |||
Linear Mode
