Morning all,

I have a few individual workbooks now which i have linked to 2 master info workbooks to enable quick and easy data availability via the Data, Get External Data, From Other Sources, Excel Files. These are set to refresh the data pulled in from these master files each time the workbook is opened.

However

If someone is in either of the Master Info files doing maintenance or developments, when opening the workbook which links to the masters, excel will also open the Masters and because they are large workbooks it can take a good few minutes depending on PC age, which is very frustrating.

Is there anyway to disable this from happening??

Many Thanks

Simon