#1
|
|||
|
|||
Deleting tab of lookup tables and pasting in updated copy
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 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. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I know if my copy of Office 2016 is being updated? | Moondoggy | Office | 0 | 10-19-2020 09:30 AM |
Stop Word from repeating tables when pasting from Excel | 2vbr | Word Tables | 1 | 09-22-2020 06:21 PM |
Copy + Pasting Excel Tables in word have 8pt spacing | Jiing Chiang | Word Tables | 4 | 01-14-2016 05:43 PM |
copying and pasting Excel tables into Word | derohanes | Word | 1 | 01-24-2013 12:07 AM |
How can match or lookup values from two separate tables? | klawk26 | Excel | 1 | 07-31-2012 09:04 PM |