Automatic Links Question

[ZoTek]

My workbook has Automatic Link Values to several other workbooks (over
100). I would like to email my End Workbook, but I would like to just
have the linked values and not the linked function show in my end
workbook. I hope I making sense.

=SUM('F:\work\[WorkbookA.xls]Sheet 1:Sheet 50'!$I$51) -------->
26,398.45

Is this possible?

Thx

 

[mrice]

You could select the area containing the links, copy to the clipboar
and then paste special back into the same area selecting the value
option

 

[ZoTek]

Thanks, That works but I dont get the row formating, maybe cause I
using Excel 200

 

[RichardM]

After using "Paste Special Values" use "Paste Special Formats" that
should restore your row formatting to the pasted results.