Exact worksheet function

  • Thread starter Thread starter R. Choate
  • Start date Start date
R

R. Choate

My wife has an Excel2000 file where the EXACT function returned a #Value error. The function was typed correctly. I copied and
pasted the formula to a blank sheet in a new workbook and it worked fine. After that, I took it further and moved that new sheet
with the working formula over to the problem file, and it continued to work fine. What would cause the EXACT function to return an
error?
Thanks,
 
My wife has an Excel2000 file where the EXACT function returned a #Value error. The function was typed correctly. I copied and
pasted the formula to a blank sheet in a new workbook and it worked fine. After that, I took it further and moved that new sheet
with the working formula over to the problem file, and it continued to work fine. What would cause the EXACT function to return an
error?
Thanks,
Click to expand...


The EXACT function's argument(s) refer to a cell (or consist of a formula)
which is generating a #VALUE! error.

--ron
 
Thanks for the suggestion. Unfortunately, that is not the answer. As I tried to describe, the formula worked fine if I copied it off
to another new worksheet (but still feeding from the exact same source). It has me really stumped.
--
RMC,CPA


My wife has an Excel2000 file where the EXACT function returned a #Value error. The function was typed correctly. I copied and
pasted the formula to a blank sheet in a new workbook and it worked fine. After that, I took it further and moved that new sheet
with the working formula over to the problem file, and it continued to work fine. What would cause the EXACT function to return an
error?
Thanks,
Click to expand...


The EXACT function's argument(s) refer to a cell (or consist of a formula)
which is generating a #VALUE! error.

--ron
 
My wife has an Excel2000 file where the EXACT function returned a #Value
error. The function was typed correctly. I copied and pasted the formula
to a blank sheet in a new workbook and it worked fine. After that, I took
it further and moved that new sheet with the working formula over to the
problem file, and it continued to work fine. What would cause the EXACT
function to return an error?
Click to expand...

Check if Transition Formula Evaluation is enabled in the worksheet in which
EXACT is evaluating to #VALUE!
 
Harlan,
You are the man. I always know that when a question that is either hard or unusual comes in, that you will come through. This is, of
course, not to mean that JWalk and all the other MVP guys don't come through, they do, but you are clutch, and I appreciate it.
--
RMC,CPA


Harlan Grove said:
My wife has an Excel2000 file where the EXACT function returned a #Value
error. The function was typed correctly. I copied and pasted the formula
to a blank sheet in a new workbook and it worked fine. After that, I took
it further and moved that new sheet with the working formula over to the
problem file, and it continued to work fine. What would cause the EXACT
function to return an error?
Click to expand...

Check if Transition Formula Evaluation is enabled in the worksheet in which
EXACT is evaluating to #VALUE!
 
Thanks for the suggestion. Unfortunately, that is not the answer. As I tried to describe, the formula worked fine if I copied it off
to another new worksheet (but still feeding from the exact same source). It has me really stumped.
Click to expand...

Well, I didn't realize it was using the same data on both worksheets. So
clearly there is something different about the particular worksheet. But I see
that Harlan has already answered your problem.


--ron
 
Harlan Grove said:
...

Check if Transition Formula Evaluation is enabled in the worksheet in which
EXACT is evaluating to #VALUE!
Click to expand...

I'm just lurking in this thread because it's interesting. I've used Excel
from its first inception through Excel 2000, and I've never heard of
Transition Formula Evaluation. How would one determine if it's enabled, and
what is it, briefly?

-Doug
 
Wake up and smell the coffee! <g> Tools>Options>Transition tab>*check the
Transition Formula Evaluation box>OK.
 
Jim said:
Wake up and smell the coffee! <g> Tools>Options>Transition tab>*check the
Transition Formula Evaluation box>OK.
Click to expand...

Oh fer cryin' out loud. I hate it when people miss the one thing they're
looking for in the options dialogs.

I'll buy the donuts today. :-)
 
I usually get very impatient with people from my home office when they don't
even bother clicking on the menus to see if the feature they need is there.
Now, to balance my karma, I have to be nice to the next one who calls me.
But just once. :-)
 
Doug,
The transition formula evaluation, if I'm not mistaken, was designed to help people come over from Lotus. It looks at the formula
the same way Lotus would look at it, instead of evaluating it from the native Excel perspective. We accountants are terrible about
reusing a spreadsheet file until it won't go any more. I think you could go to any accounting department in the country, and if the
company is older than about 1991, then you find lots of files that started as 123 files and have just been unceremoniously switched
to Excel at some time in their history. Such is the case with the company my wife works for. The file I wrote about is probably 15
years old, and somebody at their company checked Transition Evaluation because they thought it was the fastest way to just get the
work out, and eventually it crept up and bit them in the ass.
--
RMC,CPA


Harlan Grove said:
...

Check if Transition Formula Evaluation is enabled in the worksheet in which
EXACT is evaluating to #VALUE!
Click to expand...

I'm just lurking in this thread because it's interesting. I've used Excel
from its first inception through Excel 2000, and I've never heard of
Transition Formula Evaluation. How would one determine if it's enabled, and
what is it, briefly?

-Doug
 
R. Choate said:
Doug,
The transition formula evaluation, if I'm not mistaken, was designed to
Click to expand...
help people come over from Lotus.

OK...that's what I thought, based on the last time I even looked at that
part of the options dialog (318 yrs ago).
It looks at the formula
the same way Lotus would look at it, instead of evaluating it from the
Click to expand...
native Excel perspective. We accountants are terrible about
reusing a spreadsheet file until it won't go any more.
Click to expand...

Hey...I still have sheets which use the old style Excel macros. I'm the only
one at this company who understands them, which may be the reason they keep
me around. :-)
 
Back
Top