Hello,
I have a tab with many tables that other tabs use XLOOKUP to get information from. I have a master copy of this tab that is updated over time. If a project is using an outdated version of the spreadsheet, I want to copy this tab of lookup tables to it so it has the most up to date tables.
My best idea is just copying the tab like this. The issue I am having with this is the XLOOKUP formulas are broken when the updated version of the tab is copied in. How do I do this so my XLOOKUP formulas still work?
Alternative ideas I have tried but do not work:
I have a tab with many tables that other tabs use XLOOKUP to get information from. I have a master copy of this tab that is updated over time. If a project is using an outdated version of the spreadsheet, I want to copy this tab of lookup tables to it so it has the most up to date tables.
My best idea is just copying the tab like this. The issue I am having with this is the XLOOKUP formulas are broken when the updated version of the tab is copied in. How do I do this so my XLOOKUP formulas still work?
Alternative ideas I have tried but do not work:
- I could have these tables be ranges and pasted as links from the master to the copies, but then I don't have the functionality of tables and can't do XLOOKUP.
- I could use DATA->GET DATA->FROM FILE to get the tables from the master, but that does not work well with the files stored on Sharepoint and having multiple users.
