Linked excel spreadsheet getting locked and so cant be updated

gcdrake

New Member
Joined
Mar 16, 2015
Messages
1
Excel 2010

I have created 2 connections to 2 excel spreadsheets on a shared drive that contain the data I need to reference. I created the links using connections button in the data tab and then I have created 2 tables in 2 seperate sheets using the get external data, exsiting connections button.

My trouble is that when I come to update the 2 reference spreadsheets they are locked by a user which is my other spredsheet that is doing the referencing.

How can I get excel to only use the connection at the referesh period defined in the connections - properties window? Or is it not that simple?
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Forum statistics

Threads
1,136,435
Messages
5,675,849
Members
419,587
Latest member
leronardo092004

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top