Forum Discussion
Size increase when saving spreadsheet
I am working in a new company and I have noted the excel file sizes are ridiculously big. Just for an example to prove my point, I work with SAS and export data into excel files, a 1M file output from...
Hi IPF_au
The data model size will depend on the uniqueness of data. The more columns with more unique items will be harder to compress and therefore a 200k row table of unique data would be much bigger in MB than a 1 million row table with less unique data.
In terms of your non data model Excel file growing to 2MB from a 1MB file, I'm not sure. If it's a single sheet you could try pressing End then Home to check that unused columns/rows aren't being used.
Might be expected that a 1MB text file becomes a 2MB Excel file.