Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

decreasing the file size

  Asked By: Idelia    Date: Aug 28    Category: MS Office    Views: 762
  

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

Share: 

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on decreasing the file size Or get search suggestion and latest updates.




Tagged: