Forum Discussion
How to reduce size of an excel file
- Nov 17, 2021
Amand1040 I'm not at all familiar with how Excel file sizes can be calculated, but when you say 366K rows by 283 column, that means your file has over 100 million cells. If these all would contain 1 byte of data, that would already result in a file size of around 100MB. Then, your 140MB isn't all that strange.
Tested this by creation a file with 1 million cells with numbers. Saved it and the file size was 2.9MB. Perhaps my reasoning makes no sense at all, but if performance is an issue, consider connecting to the file with Power Query, rather than opening it in Excel.
Amand1040 But what's in the file then? How many rows, columns? Pictures, objects?
- Riny_van_EekelenNov 17, 2021Platinum Contributor
Amand1040 I'm not at all familiar with how Excel file sizes can be calculated, but when you say 366K rows by 283 column, that means your file has over 100 million cells. If these all would contain 1 byte of data, that would already result in a file size of around 100MB. Then, your 140MB isn't all that strange.
Tested this by creation a file with 1 million cells with numbers. Saved it and the file size was 2.9MB. Perhaps my reasoning makes no sense at all, but if performance is an issue, consider connecting to the file with Power Query, rather than opening it in Excel.
- Amand1040Nov 18, 2021Copper ContributorThanks Riny, i have connected with power query as suggested and the performance is much better.. Thanks