I have two workbooks in OneDrive. I want one file to contain pivot tables, and the second to store raw data in a table. Is it possible to link the pivot tables to the data table in the second workbook? I can link cells from one workbook to another but haven’t found a way to do this for pivot tables.
I have this setup desktop version, but wondering if possible to do online.
Thanks