Forum Discussion

Jacob Windle's avatar
Jacob Windle
Copper Contributor
Jun 21, 2017

Linked Data Retrieval in Excel

I curretnly take Data from a worksheet that is updated by multiple people from different departments, who input various data, and manually input it into another worksheet to compile information (the worksheet I am pulling from is a temporary internet file). I am trying to link cells from my worksheet to cells in the worksheet that I currently pull the data from, so that the data is self populated and doesnt require manual entry. I used the following formula:

='C:\Users\My Username\AppData\Local\Microsft\Windows\Temporary Internet Files\Content.IE5\UUC1B6IN\[File Name.xls]File Name'!$W$17      ("My Username", is private for obvious reasons as well as the "File Name"

However when I go to the Data Tab, Edit Link to update the data i get a #REF error. Is there a way to resovle this issue or a better formula to use?

excel
  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Jun 21, 2017
    You linked to a file which is on a temporary location. Best is to download the file to a fixed folder. Then you can link to that file in that folder. If you want to refresh, you can download the file again to the same folder using the same filename. Another option is to have the file on your OneDrive and then link to it from the OneDrive folder on your computer.

Resources