1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel 2010 SUM Formula updates, save file and reopen - values revert to old

Discussion in 'Business Applications' started by HaydnWVN, Oct 19, 2011.

Thread Status:
Not open for further replies.
Advertisement
  1. HaydnWVN

    HaydnWVN Thread Starter

    Joined:
    Oct 19, 2011
    Messages:
    7
    Excel 2010 SUM Formula updates, save file and reopen - values revert to old yet SUM totals are new

    Hi guys


    We have a very strange problem, our user opened his .xls document (97-2003 format) yesterday and updated several values, copied formula and updated (eg monthly/weekly totals). The worksheet includes many small SUM's spanning a couple of cells with sub-totals. He then saved his work and shut down as usual.


    When opening the .xls document this morning, to continue his work, he noticed some of the values had changed (we assume to the previous ones) yet the totals where still the updated 'saved' values. Changing any values causes Excel to recalculate the totals (which then become correct, yet old totals)


    Yesterday I updated the computer from a Windows XP (SP3), Office XP (SP3) to a Windows 7 (32bit, SP1), Office 2010 (SP1).


    We've advised him to change document types to the new .xlsx format and to doublecheck everything.

    Any ideas to the actual cause? Thanks
     
  2. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,560
    First Name:
    Hans
    If the user did indedd use the same file, then this is quite strange thing.
    You cannot just tell him / her to change docuemnt types, you have to select Save As and if he/she still uses Office 2003 then the conversion software form the Microsoft site must be downloaded so that xlsx or xlsm files can be opened with 2003 and he / she can also choose to save as Excel 2007 file types.
    I think the user worked with two different versions
     
  3. HaydnWVN

    HaydnWVN Thread Starter

    Joined:
    Oct 19, 2011
    Messages:
    7
    The user has a new Windows 7 PC now and he is the only one who will be opening it (so no need for older .xls format). We're just trying to avoid the same thing happening again as it could prove to be a VERY expensive problem... The 'user' is our Director of Finance!

    The user did work with 2 different versions (old to new) but not between times...

    Any further ideas about things we can introduce to track the problem down or stop it from happening again?
     
  4. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,560
    First Name:
    Hans
    I don't have any idea, just make sure the he uses only one version.
    If he runs if fro the same folder all the time if should run normally.
    People generally get confused when the get attachments in the mail, open then edit and the save without thinking then they loose that data because it's in Outlook's temp folder, but I imagine this was not the case.

    You could add a line of vba code (macro) that adds a row to a log sheet stating the username and time and date when opening, this maybe just to keep track of who uses the file.
     
  5. HaydnWVN

    HaydnWVN Thread Starter

    Joined:
    Oct 19, 2011
    Messages:
    7
    It's within his own personal (private) area so nobody else has access to it. He has no other versions of Office except Office 2010 on his PC.

    Opening an attachment, logging what happens in the future (it has already happened and hasn't happened since) and opening a .xlsx document in Excel 2003 are not related to this issue.

    Sorry Keebellah but nothing you've suggested helps us to resolve or diagnose what caused this issue! :)

    I've recently replaced 6 old Windows 2000/XP machines (Office 2000, XP and 2003) with 6 of these new Windows 7 PC's (Office 2010). Nobody else has reported anything remotely similar happening. (30+ PC/user network).

    We're hoping it's isolated to this individual sheel within this document as we have not seen the issue anywhere else, but until we can diagnose/repeat/isolate the problem we just don't know! Very fustrating! :(
     
  6. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1022958

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice