Links to source files

gage25

New Member
Joined
Oct 16, 2002
Messages
16
How do I remove all reference to another source file from an Excel workbook?

If I go Edit>Links> and check the links to external sheets..how do I delete those workbooks that are linking? The only options I am given are Update Now...Open Source and Change Source.

I am unable to update my new spreadsheet because it keeps referring to an old sheet, even though I have removed all mention of links to the original sheet!
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Watch MrExcel Video

Forum statistics

Threads
1,118,819
Messages
5,574,503
Members
412,599
Latest member
Schu94
Top