Johnny C
Well-known Member
- Joined
- Nov 7, 2006
- Messages
- 1,069
- Office Version
- 365
- Platform
- Windows
I've a file, 5 sheets, 200 rows, 24 columns in each. Say 60% of the cells are populated, all with values (i.e. no formulae).
There are no embedded objects, and no conditional formatting. There are no macros, no hidden sheets.
The file size is 25Mb, I would have expected 2-3% of the size. Excel has no problem but our network is slow and the file can take 2 mins to load on a bad day.
It has no custom fonts beyond the standard ones.
I am guessing that some numty has formatted each cell separately. I copied values and set up identical formats in a new sheet, and the file size was <½Mb
If it is the formatting, how can I remove it?
I'm guessing that the file was generated by a macro, possibly initiated from SAS.
There are no embedded objects, and no conditional formatting. There are no macros, no hidden sheets.
The file size is 25Mb, I would have expected 2-3% of the size. Excel has no problem but our network is slow and the file can take 2 mins to load on a bad day.
It has no custom fonts beyond the standard ones.
I am guessing that some numty has formatted each cell separately. I copied values and set up identical formats in a new sheet, and the file size was <½Mb
If it is the formatting, how can I remove it?
I'm guessing that the file was generated by a macro, possibly initiated from SAS.