I use Indirect to access data from Named Ranges, whose scope can be either Sheet or File-wide.
I notice that some Scopes refer to a separate Spreadsheet. eg G: ... /.../.../....xlsx
I want to make available to end users Spreadsheets with individually tailored Dashboards, that refer to Named-ranges within a Master SS.
Can it be done?