Reduce Really big file?

[lordtopcat]

Hi guys,

I've got a problem with my workbook which is only 10 sheets and about 12 columns and 40 rows. The file is 2.8mb which obviously takes a long time to open.

I've checked the hidden columns and rows and there's no excess formatting. No macros.

My theory is pretty much all cells have data validation and conditional formatting. I need both of these functions but is there anyway I can cut down the file size without removing these?

Thanks in advance!

[FDibbins]

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the adress bar)

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[lordtopcat]

My problem is a really big file. Not sure how much more descriptive I can be.

[Pepe Le Mokko]

You could try " How do I reduce my workbook size?" for example

[Fahads_neo]

Hi there,

Your profile suggest you are currently using MS Excel Ver.2003. Try upgrading to 2007 or above, and then use "save as" option with the same file. MS Excel would automatically reduce your file size. This is one solution that will take care of this problem et al.

Secondly, if you can upload your file here then we can check further to remove and unnecessary formatting. (Hit the star button if you think this helps).

[Pepe Le Mokko]

@Fahads
Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.

If you are unclear about the request or instruction then send a private message to them asking for clarification. Do not post a reply in a thread where a moderator has requested an action that has not yet been complied with e.g Title change or Code tags...etc

[lordtopcat]

@Fahads
Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.

If you are unclear about the request or instruction then send a private message to them asking for clarification. Do not post a reply in a thread where a moderator has requested an action that has not yet been complied with e.g Title change or Code tags...etc

And you have broken the rules too. Or are you exempt from the rules?

I'll change my title to make it less confusing.