Removing link to another workbook
 

Hello,

I originally did a VLOOKUP into another workbook to populate a cell.
Once that data is retrieved and populated, I no longer need the link to
the other workbook. Is there any way to remove this link and keep the
data in the cell?

The workbook where this data comes from will not be present when I
supply the spreadsheet to others and when you open the xls it pops up
an annoying msg asking whether you want to refresh the linked data.
And, like I said, I only need to populate the data once, then keep it.

Any help is appreciated! Thanks


--
ATC
------------------------------------------------------------------------
ATC's Profile: http://www.excelforum.com/member.php...o&userid=24747
View this thread: http://www.excelforum.com/showthread...hreadid=383160

ATC, here's some information for you:
http://www.officearticles.com/excel/...soft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"ATC" wrote in message
...

Hello,

I originally did a VLOOKUP into another workbook to populate a cell.
Once that data is retrieved and populated, I no longer need the link to
the other workbook. Is there any way to remove this link and keep the
data in the cell?

The workbook where this data comes from will not be present when I
supply the spreadsheet to others and when you open the xls it pops up
an annoying msg asking whether you want to refresh the linked data.
And, like I said, I only need to populate the data once, then keep it.

Any help is appreciated! Thanks


--
ATC
------------------------------------------------------------------------
ATC's Profile:
http://www.excelforum.com/member.php...o&userid=24747
View this thread: http://www.excelforum.com/showthread...hreadid=383160

copy|paste special|Values

When I can't find links, I'll use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm


ATC wrote:

Hello,

I originally did a VLOOKUP into another workbook to populate a cell.
Once that data is retrieved and populated, I no longer need the link to
the other workbook. Is there any way to remove this link and keep the
data in the cell?

The workbook where this data comes from will not be present when I
supply the spreadsheet to others and when you open the xls it pops up
an annoying msg asking whether you want to refresh the linked data.
And, like I said, I only need to populate the data once, then keep it.

Any help is appreciated! Thanks

--
ATC
------------------------------------------------------------------------
ATC's Profile: http://www.excelforum.com/member.php...o&userid=24747
View this thread: http://www.excelforum.com/showthread...hreadid=383160

--

Dave Peterson