Csv file size is too big

[Ponto]

Hi,

Help please, i have created a master list of all our products, approx 5,864 lines with 26 columns.

I have just added in approx 1200 items and when exported as a CSV file the size is 94mb, the previous version was approx 1.2mb.

There are no links to external data sources and there is only CONCATENATE use in two columns.

The exported file is too big to import into a Ipad App that we use.

Any ideas?

Thanks

 

[mole999]

your concatenate can be overcome by copying and paste special (values),its possible that more than the single sheet was outputted, or many more rows than intended

 

[Ponto]

Fixed it, had to open the saved CSV file (94mb) and then re-safe it and it came down to 1.4MB.

Very strange and a bit of a work around but it works.