(Not Responding) when Saving As

[cristinik]

Hi All,

I have a 23MB Excel 2007 .xlsm file when crashes every time I try to "Save As". If I copy, paste and rename the file in the file browser I have no problems.
The file contains a lot formulas (specially VLOOKUP) but I disabled automatic calculation, and calculations when saving.
There is one module with VBA code which I already removed, but the problem persists. I have also tried in other computers with no success at all.

Any ideas?

Thanks a lot in advance

[:) Sixthsense :)]

I still believe you have not removed the tick mark from

Recalculate Workbook Before Saving

Alt+T+O>>Formulas>>Calculation Options>>Workbook Calculation>>Manual>>Untick the above mentioned check box and try...

[cristinik]

I had removed the tick mark. Even if I hadn't, calculation normally takes less than a minute so it shouldnt be a problem either.

I have narrowed the problem down to one worksheet now. I am just trying to figure out what exactly in the worksheet is wrong.

[:) Sixthsense :)]

Is there any code in ThisWorkbook code window?