Automatic Links Question
 

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


--
ZoTek
------------------------------------------------------------------------
ZoTek's Profile: http://www.excelforum.com/member.php...o&userid=34189
View this thread: http://www.excelforum.com/showthread...hreadid=539521

Automatic Links Question
 

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: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=539521

Automatic Links Question
 

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


--
ZoTek
------------------------------------------------------------------------
ZoTek's Profile: http://www.excelforum.com/member.php...o&userid=34189
View this thread: http://www.excelforum.com/showthread...hreadid=539521

Automatic Links Question
 

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