+ Reply to Thread
Results 1 to 4 of 4

Excel 2010 Auto Calculate Not functioning

  1. #1
    Registered User
    Join Date
    05-09-2012
    Location
    Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    2

    Excel 2010 Auto Calculate Not functioning

    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.

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Excel 2010 Auto Calculate Not functioning

    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>
    DILIPandey
    +91 9810929744
    dilipandey@gmail.com

  3. #3
    Registered User
    Join Date
    05-09-2012
    Location
    Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Excel 2010 Auto Calculate Not functioning

    Hi Dilip:

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

    Thanks.

  4. #4
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Excel 2010 Auto Calculate Not functioning

    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>

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1