Forum Discussion
EXCEL file takes 15 minutes to save
Hi. I am using Excel on Office 365. I have a file that's approximately 22-25 MB in size with 5-6 worksheets. The main worksheet has approx. 100 columns and 30,000 rows. The file has thousands...
1. Put raw data in Excel tables.
2. Check whether calculations could be done with Power Query.
3. Output in pivot tables not with formulas.
4. Connect to external data with Power Query.
5. Check whether the workbook contains a lot of objects and delete them.
Detlef_Lewin
Thanks for the quick reply.
I am not familiar with how to use Power Query and Pivot Tables, but will look up and try.