Linking to another excel workbook (Import Data)

I am importing data from an outside excel file to several other files. I requested that the data be refreshed every time I open the file that references the outside excel file.

Whenever I have a file open that references the outside excel file, I can only open the outside excel file in a read-only state. Why is this, and is there any way around this issue?

Re: Linking to another excel workbook (Import Data)

I'm actually not using links. I'm importing the sheet through the data tab. I have had major issues using links in excel sheets (network permissions), and I've found that this solution is working out much better for me, except for the read only problem.