Forum Discussion
Dynamic reference to sharepoint files
Hi, I want to create a file that summaries various other files (e.g. separate business cases) in one. I have already learned how to create dynamic references with the INDIRECT function. But this ...
SergeiBaklan thanks for taking the time to answer. Yes, I use Excel for desktop on Windows. Unfortunately, I haven't understood your answer. So I can obviously get the link to any sharepoint file, which has a weird code in it instead of a file name.
https://location/
What I don't understand is how to create a formula with that which references to the cells I need.
With the INDIRECT formula the logic is known as:
=https://exceljet.net/excel-functions/excel-indirect-function("'["&workbook&"]"&sheet&"'!"&ref)
It doesn't work though to replace the workbook part with the link above.
INDIRECT() requires that both files shall be opened, thus actually you don't need full path, that's only if parse CELL("filename").
Formula will be the same. Here if both are opened
and if targeted file is closed only link without INDIRECT() works