Hi

I'm not sure if anyone can help with this issue, but here goes. i will label each element (X)

I have Forms (A) collecting data based on a few questions, which in turn populates an excel file (B) within sharepoint.

the data from this file (B) is then required to populate a separate excel file in SharePoint (C)

so far i can Xlookup from (C) into (B) and pull the data required, but i can only generate fresh data to populate (C) if (B) has been opened and saved, after more entries from (A)

so far i have tried automate to export the file at intervals, but can not get this to work on adjusted or updated files.

i have set up sync to one drive to try and gather (C) but again only captures last manual save.

i'm at a little bit of a loss for what else to try to effectively update (C) without having to open (B)

suggestions or help would be appreciated.

KR

Sam