Slow excel tables

I replied to you in PM.

also listing the issues here as well

1. many of worksheets has unused unnecessary formatting and styles that caused the workbook size to grow huge. for example whole row and whole column formatting is used where it is not necessary, especially when you have Excel Tables.  
2. the second biggest problem is using the named ranges which references millions of cells unnecessarily for example  named range xxxxxx which was used inside many VLOOKUP formulas has a reference of  ='xxxxx.'!$B$2:$AD$1048364  now if you count from column B to column AD it is 29 columns and the number of rows are 1048364 that means 29x1048364= 29 Millions of cells are pushed for calculations that sucks the memory. Instead you could set up dynamic range or simply use Excel tables structural references which has the feature of dynamic range and this will significantly improve the calculation time and make your workbook much faster
3. Part of workbook is also corrupt, meaning some formulas are broken and are not functioning properly, so you need to find and fix those formulas.  I have attached a version of workbook which has deleted excessive formatting and removed the formulas that were corrupted and could not be recovered (you can look at this workbook and analyse what is missing and you would notice how fast this workbook opens and works)
4. Your Workbook has many broken links and named ranges with errors. I have attached a separate workbook with listed named range report for your easy reference. Also the workbook cells are linked to another workbooks from OneDrive. You can fix the error by checking the source data and correcting them, if those named ranges are not needed you can get rid of them. also, possibliy if you could avoid using the values from other workbooks that are saved in OneDrive which will cause the links to be popped for update, you do not need to have links to values in other files unless you really have to.

Also the macros that are available in the workbook are ineffective, these VBA codes are generated from macro recorder which is not cleaned up and it has a lot of unnecessary steps that aren’t needed and can be eliminated.