+ Reply to Thread
Results 1 to 4 of 4

Excel 2007 Formula files not opening properly in Excel 2010 #Name

  1. #1
    Registered User
    Join Date
    10-13-2010
    Location
    Chennai,India
    MS-Off Ver
    Excel 2007
    Posts
    2

    Excel 2007 Formula files not opening properly in Excel 2010 #Name

    Hi,

    Was wondering if you’ve heard of any issues with Excel 2010 and excel 2007 .
    Excel Files are created in 2007 version with contain formulas and also linked with external files. If I open the files in Excel 2010, all the numbers in the excel file cell numbers are changes to #Name. In Excel 2007, I can open the same excel files and the number stay without any error.

    It would be great if anyone could help us to solve this problem.

    Regards
    Balaji

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,667

    Re: Excel 2007 Formula files not opening properly in Excel 2010 #Name

    Please post the formula which results #Name error. May be the formula consist function of some other addin which needs to be enabled in your excel 2010, I believe.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    10-13-2010
    Location
    Chennai,India
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Excel 2007 Formula files not opening properly in Excel 2010 #Name

    Yes you are right! it is opening properly in the plugin installed PC, but others are not able to view the last saved cell value, but in excel 2007 it is opening with last saved value even though not installed the Plugin. I guess Excel 2010 try to update the link automatically when I open it, If I make it Manual Calculation before open the file, it shows last saved value, Once change to Auto Calculation the formula contain cell value become #Name.

    It is would be great if you could help me to solve this issue.

    Regards
    Balaji

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,667

    Re: Excel 2007 Formula files not opening properly in Excel 2010 #Name

    Try this...

    Alt+T+O>>Advanced>>When Calculating This Workbook>>
    • Unpdate Links to Other Documents
    • (Tick) Save External link values
    Alt+T+O>>Trust Center>>Trust Center Settings>>External Content>>
    • Security Setting For Workbook Links>>(Select) Prompt User on automatic update for workbook links

+ 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