I'm working to get a file size down, yet getting what I think is strange behavior.
I have data spanning 50+ columns and over 5,000 rows. The file size is currently ~ 8.2MB.
And in experimenting, when I delete about 7 of those columns (all with data in those 5000 rows) and resaving the file, the file actually grows in size to ~8.7MB. Why would it grow 500k when I'm actually deleting data?
Do you have Conditional Formatting? If you do, check the rules and the ranges they apply to. You might find there are dozens of identical rules applied to subsets of the original range.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks