Excel 2010 Auto Calculate Not functioning

**yimtiaz** · 05-09-2012, 01:33 PM

I have a huge file with a lot of formulas and cross references. The file was originally created in Excel 2007. Recently we upgrated to Excel 2010 after which the file is giving all the trouble in the world. It takes a minute to open and save any change. The biggest concern is that all the numbers are not being updaed automatically. Even though in the option, the Workbook Calculation is set to Automatic but actually the numbers to dot get updated. The strange thing is that when I open the file in Excel 2007, it starts working pefactly.

Anything, any solution which I can use to fix the issue. Appreciate your help.

Thanks.

**dilipandey** · 05-09-2012, 01:40 PM

HI Yimtiaz,

That version of Excel 2007 is installed in the same system or it is another system?

Regards,
DILIPandey

<click on below 'star' if this helps>

**yimtiaz** · 05-10-2012, 12:17 AM

Hi Dilip:

Excel 2007 was installed on my system which was upgraded to Excel 2010.

Thanks.

**dilipandey** · 05-10-2012, 05:47 AM

The strange thing is that when I open the file in Excel 2007, it starts working pefactly.

Above statement suggests that you are opening the file in Excel 2007 as well. Yes, itt may be some other system as you have now Excel 2010 in your particular system.
I am looking for a possiblity if both the system are equally powered having these two different versions of Excel. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>