Sep 15 2019 03:48 PM
Sep 15 2019 06:08 PM
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.