data connections between excel online files
We created an excel file PARENT which needs to retrieve data from few diffrent CHILD excel files owed by (or shared with) diffrent users within the company. Each user controls and enters data daily in his excel file (CHILD)
Those data entered in CHILD files need to be instantly retrieved in PARENT file (not manually!!) and based upon them we set some sheets in PARENT file to calculate reports and statistics. This is the point where the need of connections between files arises.
We couldn’t find any way to connect files in Office 365 and I can not understand why this external connections are not supported. They are imperative for our work.
Is there any possibility to set this connection I need between files in Office 365, particularly between excel files in Office 365? Is there any alternative?
Paul Patenaude commented
Tied to this - we need to allow XLOOKUP to access other Excel file data sets.
VLOOKUP can still work in the o365 environment - but not the new XLOOKUP functionality