Takes way to long to save.

Hello everyone i am new to this Forum so let me just say thanks in advance for any help I may receive here. I have had a workbook that ive used for work for 2 years now. The file has always only taken a few seconds to save. I exhausted all excel had to offer with formulas and have tried a simple VBA function. That code worked great but it slowed my saves to about 1 min . So I removed the code and the module but it still takes that long to save. I tried other excel files and just by opening VBE causes my save time to go way up. Makes no sense to me so I thought I would leave it to the experts. I would like to attach the file but its to large to post here (3 MB).

I would try CodeCleaner by AppsPro.

I have a 4MB template for pricing that I instance regularly, and it takes about 10s to save. It is loaded with formulas and VBA, but the formatting variations are deliberately modest. What about yours?

That is a great idea! I have the file shared at this address:

http://workspace.office.live.com/?id...hhcnRlci5uZXQA

I hope that link works. The file name is called Old_Forms_Master

Can someone take a look at the above file?
Thanks

Hi

Had a bit of a look and was astonished to find 291 sheets.

Just for the heck of it, I started deleting sheets and found save time decreased as the number of sheets decreased.

On a quick look, many of the sheets seem to be in the same format, with just a minor difference. Any chance you could reduce the number of sheets?

rylo