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 assume you use links to do this. I've never had this situation before, can easy open both files in write mode.

  • 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.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!