Excel 2007 vs. 2010:  data not remaining consistent

Posted on 2011-10-27
Last Modified: 2013-12-25
We have multiple excel files stored on a domain on shared server.  We've had excel 2007 users working in these files for years.  We upgraded a couple to 2010 office (excel).  We have since run into an issue with the 2010 Excel opening a file, updating a cell in the file then saving back to the share folder; when excel 2007 user opens the file they do not see the changes made.  When 2007 user makes changes to excel file and saves, 2010 excel user sees the changes properly.  The issue only occurs when excel 2010 users open file, edit file, save file back that 2007 users cannot see updates.  When i go back to execl 2010 to share folder the changes still exist even after the 2007 excel users has opend the file and resaved it back to server.  There has to be something going on with versioning or where temp file is stored....just can't figure out issue.
Question by:amarraina
    LVL 10

    Expert Comment


    Expert Comment

    is this happening to a specific spreadsheet? what format are they saved in? .xls? try the newer format .xlsx and use a different computer to make a change.

    Author Comment

    It's happening when in either direction.  When he creates a new excel workbook in 2010 and someone edits it 2007....the 2007 edit only shows when another 2007 office user opens it.  When 2010 office edits the workbook both 2010 and 2007 users see the changes.  As there are a handful of both 2010 and 2007 users you can see the issue.  Taking them all to 2010 is not an option b/c we are talking about 30+ users.
    The compatibality mode did not fix the issue as he is saving the file so excel 2003 users can open it also.  We have not tested any 2003 computers b/c there are none onsite (some of thier customers have 2003).
    LVL 10

    Expert Comment

    Just a check, did you view the unsupported features of 2010 (from the link above)? I can say from experience, that we have received 2010 Excel file from others. While we could open and view them in 2003, via conversion, the color formatting was not visible. Only when we used the 2010 viewer ( were we able to see all of the formatting on those computers.
    LVL 44

    Accepted Solution

    The issue is almost certainly one of 'upward/downward' compatability -  when Office 2010 was created, new features were added which obviously would not be compatible/accessible with earlier versions of Office. When Office 2010 opens an earlier version file, ALL of the earlier features are suported - Microsoft is VERY careful about 'upward' compatibility.  When an Office 2010 file is saved in 'normal mode' the new features will NOT be seen by the earlier versions of Office)  To resolve this issue, Office 2010 supports saving a field AS an earlier version of Office - yes, this does have the effect of eliminating all of the newest feateure of Office, but it does make the file accessible to user of the earlier version.    The best answer I can offer is :

    Until ALL (Every single user, with no exceptions) of your users are upgraded to Office 2010, instruct ALL Office 2010 users to ALWAYS - (again with no exceptions) Save their work (new files and updates) as the Office 2003 version (SAVE AS...) then the Office 2003 users will be able to see the work of their Office 2010 co-workers.  Yes, this is a royal pain, but it the only way to get this to work.

    LVL 100

    Expert Comment

    This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
    Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
    Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
    Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now