software

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) --------gt;
26,398.45

Is this possible?

Thx--
ZoTek
------------------------------------------------------------------------
ZoTek's Profile: www.excelforum.com/member.php...oamp;userid=34189
View this thread: www.excelforum.com/showthread...hreadid=539521
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.--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: www.excelforum.com/member.php...oamp;userid=10931
View this thread: www.excelforum.com/showthread...hreadid=539521
Thanks, That works but I dont get the row formating, maybe cause Im
using Excel 2000--
ZoTek
------------------------------------------------------------------------
ZoTek's Profile: www.excelforum.com/member.php...oamp;userid=34189
View this thread: www.excelforum.com/showthread...hreadid=539521After using quot;Paste Special Valuesquot; use quot;Paste Special Formatsquot; that
should restore your row formatting to the pasted results.