Excel 2007 vs. 2010: data not remaining consistent
Posted on 2011-10-27
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.