Tony Miall
Active Member
- Joined
- Oct 16, 2007
- Messages
- 304
Afternoon,
I am trying to decrease the size of a file by clearing all the formating in about 20,000 cells but for some reason when I format the range to no fill, no colour, no bold etc etc instead of decreasing the file size it increases from 7000KB to 41,000KB and I don't understand why. Any help appreciated as usual.
thanks
I am trying to decrease the size of a file by clearing all the formating in about 20,000 cells but for some reason when I format the range to no fill, no colour, no bold etc etc instead of decreasing the file size it increases from 7000KB to 41,000KB and I don't understand why. Any help appreciated as usual.
thanks