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 clipboard and then paste special back into the same area selecting the values option.

[ZoTek]

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

[RichardM]

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