Break Link To Data In Another Program

Worlds best Ms Office Tutorial content. Find anything about Ms Office Tutorial on this site.

Break Link To Data In Another Program. I know i had saved a temporary version of this file and later on deleted it. Go to the Data tab in the ribbon.

Barefoot Computing On Twitter Computational Thinking Teaching Coding Unplugged Coding Activities
Barefoot Computing On Twitter Computational Thinking Teaching Coding Unplugged Coding Activities from www.pinterest.com

Select Text to Columns in the Data Tools section. Go to the target program Word in the example click on the bottom of the Paste menu on the Home tab and select Paste Special from the menu that opens. Click on Break Link.

I would rather not have to edit the names of all the links if there is an easier way.

This example assumes that at least one formula exists in the active workbook that links to another Excel source. Go to the Data tab in the ribbon. Select the data to be linked eg. Youll see a list of links that are active in your spreadsheet single-clicking one will highlight it.