Share Table with Data

[lighting77]

Hi.
I wanted to share the same data across many workbooks to maintain data integrity. Any ideas??

 

[GraH]

One basic idea:
- store the data somewhere central
- import it through Power Query in those many workbooks (it will be a table)
- trigger refresh on open in the table setting

 

[lighting77]

I’ll try it out

 

[lighting77]

I finally learnt power query and was able to sort this out

 

[smozgur]

I finally learnt power query and was able to sort this out

Good to hear you got the solution.
If you would like to post the solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.

 

[smozgur]

Additional note: @GraH outlined straightforward and accurate steps to address this generic question. While it's preferable to present your solution using Power Query's M code for the benefit of future readers, if you're unable to provide a sample code — which is entirely understandable as it might take time to prepare it — I consider @GraH's post as the answer, and mark it as the solution to help future readers. Please feel free to change the solution in case you could provide a sample.