I have an Excel workbook, very large (70 Megas) and inside I have 3 databases, many of Pivot tables with Report Connetcions and a Dashboard. However, the file is being very slow to operate. It takes time to calculate, it's slow. What could I do so that everything goes blazing fast? (Get all data in Dashboard+Slicers working fast).
They're all done by formula (index+match,ifs, vlookps, pivot tables, pivot charts).


thanks for your opinion.