Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
paste formulas between workbooks without workbook link | Excel Discussion (Misc queries) | |||
removing automatic link | Excel Discussion (Misc queries) | |||
Cells to link to "current workbook" | Excel Discussion (Misc queries) | |||
how do i link a list of items in a workbook to worksheets in the . | Excel Discussion (Misc queries) | |||
Link to password protected workbook | Excel Discussion (Misc queries) |