Linking Data / Refreshing Existing Connections Issue

Hello everyone,

I'm running Excel 2013.

In a nutshell, what I have are two spreadsheets. One is a master diary of events that's taking place in a building. The second is a weekly events sheet. I'm trying to link the master diary to the weekly event sheet so it's automatically populated with the data from the master diary, therefore meaning if the master diary is changed, whenever the weekly events file is opened, that data will refresh automatically.

The problem i'm having is - whenever I make a connection to the master diary from the weekly events file, it opens a read-only copy of the master diary along side it, even if I tell it to put the data into a new table within the weekly events sheet.

Also, even if I close the read-only copy of the master diary, whenever I press 'Refresh Connections' it re-opens a read-only copy again!

Any ideas what I'm doing wrong?

Please accept my apologies if I've been vague - I can clarify anything if you're not sure.

Thanks in advance

Yes, but the master diary is password protected, but surely I can create a read-only connection and still use the data? It literally has to be a one way connection.

Thanks,

Wes