I have a column where all formulas are the same except row number. Some of
the formulas are returning '#N/A' when I open the file. The formulas link to
another file. When I open the other file, the values update correctly. Only
about a dozen blocks are doing this. All other blocks are calculating
correctly before I open the source file. If I open the Error Checkingbox, it
says 'A value is not available to the formula or function'

Can you post the formula(s),
Regards,
Alan.
"MeSteve" wrote in message
...
I have a column where all formulas are the same except row number. Some of
the formulas are returning '#N/A' when I open the file. The formulas link
to
another file. When I open the other file, the values update correctly.
Only
about a dozen blocks are doing this. All other blocks are calculating
correctly before I open the source file. If I open the Error Checkingbox,
it
says 'A value is not available to the formula or function'

Hi, I am having a similar problem with a spreadsheet I am working with.

I am using a simple 'Match()' function, but occasionally it will not
recognize the exact number, and spits back '#N/A'. This occurs
randomly, as the majority of the cells with the Match function work
properly.

How did you solve your problem?

Thanks,


--
Avendora
------------------------------------------------------------------------
Avendora's Profile: http://www.excelforum.com/member.php...o&userid=37628
View this thread: http://www.excelforum.com/showthread...hreadid=570951