Thing is I wasnt just one table. Was a main table connected to 8 others subtables. Best workflow was duplicating everything and moving the duplicates tables to the new workbook.
You cant directly change the source Abdul S.
For one table that works perfectly Usman
