Automatic Links Question

Z

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
 
M

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
 
Z

ZoTek

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

RichardM

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