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).