Hello,
I am working in Excell in Pro-systems Engagement. I want to link workbooks
but when I use Paste Special to paste the link, I can paste an Excell object
that shows the number I want that is on top of the workbook while all the
other formats are actually in the cell but show #VALUE! instead of the
number.

Any ideas would be appreciated.

Thanks.