Trying to retrieve data from another file using path location and reference cells in a formula

Question

Trying to retrieve data from another file using path location and reference cells in a formula

Anonymous

I'm trying to retrieve data from other files stored on my device and I'm having difficulty finding the correct functions or syntax to achieve this. I have the file path and sheet name ready in a cell, I have the reference data location in that file, and I'm trying to input these two into a cell to calculate the average of those reference cells in the other file. Attached is a screenshot.

Any help would be appreciated, thank you in advance.

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

Answer accepted by question author

0 additional answers

Answer 1

Re: "I'm trying to retrieve data from other files stored on my device"

You have included brackets [ ] in the named range (A6).

Don't add them again in your formula.

'---
Nothing Left to Lose

https://1drv.ms/u/s!Au8Lyt79SOuhZw2MCH7_7MuLj04?e=sAwbHU

(free excel programs)

Share via

Trying to retrieve data from another file using path location and reference cells in a formula

0 additional answers