Is the formlua referring to a circular reference. I.e is
the value dependant on its own cell value?

Is the formula Array Entered? CTRL & SHIFT & ENTER

What version of XL?

If XP, try using the formual auditing toolbar, and
checking the calculation steps. It may show the section
of the formula that is erroring.

If not, post the formula in the NG for all to see, you
may find that the problem is easy to see (for a fresh set
of eyes).

HTH Paul.

Post to all replys to Thread.

-----Original Message-----
I have a macro which does a paste link from several
worksheets to rows in a
main worksheet within the same workbook.

The problem is that the main worksheet, while containing
the correct linked
formulas referencing the other worksheets, does not
display the value of the
linked cell. The interesting thing is that when I click
on one of these
linked cells, click once in the formula bar and press
enter, then and only
then does it display the value. This without having done
anything to the
formula.

I've checked the format on both sides of the link -
they're both formatted
as numbers, commas with no decimals.

I've checked the macro to make sure that screendisplay
updating is set to
"True" and calculation is reset to automatic.

Anyone seen a link behave like this?
I don't know what else to check.


.