This has a direct correlation with the Excel file size. If you have an Excel workbook that has some worksheets that are not needed (and are not being used in any formulas), see if you can get rid of those. The best solutions are often the easiest ones.Īnd this technique is more of common sense and less of any Excel wizardry. The results you get would vary depending upon your data and files.īased on your workbook, you can use one or more of these tips. Keep the Pivot Cache and Delete the Source Dataīelow are the techniques you can use to reduce the file size of your Excel workbook.įor each tip, I have done some testing and have added the snapshots to show you the impact on file size.Keep the Source Data and Delete Pivot Cache.Compress Images (Before and After Uploading).
0 kommentar(er)
