I am trying to decrease the file sizes, which are coming from many
sources, althogh its not easy to do that. Previous users have done
something which i couldnt find and the files becamed many many MB. So
i please you answer my questions or leed me to another solution:
1-to find every sheets size(in terms of KB)
2-Delete every named range with a macro
3-Any program which is decreasing the file size?
4-There is a limitation of 4000 cellformats in one workbook. Is there
any way to find out where are the 4000 different cells are located? I
am combaning from many files from different people and somehowe I
reach the 4000 cellformat limitation. So I need to split the files
althogh I dont think its neccecery to split.
5-To find how many different types cellformats are used in each sheet?
In case somebody had already asked and been answered already, please
accept my sincere apologies.
Thank you in advance