Hi! I have 2 Excel tables in different folders in the Share Space Collaborative spaces.

1 folder with restricted access contains a table1 with source data, where I input some statistical data.

2nd contains a table2 with open access which should contain a pivot graph with the data I chose to share from table1.

Still, I have not managed to make a connection within these tables and eventually create that pivot chart.

Can anyone kindly advise what can I do?
Thank you in advance.