Hello,

I've got an overview excel sheet that links information from around 25 other workbooks. The overview sheet is used to sum up figures from the 25 other workbooks, so when reviewing the overview sheet I always update the links by going to 'Edit', 'Links' and then update the files I need to.

However, when opening up 'Links', the list of 'Source Files' include sheets that is either not linked to the overview sheet anymore or no longer exists. When I choose the Source Files I want to get rid of and click 'Break Links', they simply stay on the list.
I want to be able to select all sourcefiles and update all at once but when I do that currently, excel will start to try and find the obsolete Source Files, which makes it an unhandy proces.

How can I take Source Files of the Links-list permanently?

Many thanks in advance,
Lea