Results 1 to 9 of 9
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    Belfast, Ireland
    Posts
    339
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Changes aren't Saved (XP)

    Something weird is happening to Excel documents in our organization.

    On Friday, Liz spent all day updating a spreadsheet created by Anne, but when both Anne and she opened the document today, all the info Liz entered is gone! They KNOW they saved it (Anne SAW Liz hit Save), so they are both stunned. To recreate the problem, Liz made further edits to the Spreadsheet and closed it. Anne opened it on her PC, but--sure enough--the changes aren't there. I reopened the File on Liz's PC, and the edits Liz made today ARE visible.

    This spreadsheet is *not* being tracked for changes, and both users have FULL CONTROL NTFS Permissions, so this isn't a permissions problem.

    Can anyone explain how data is visible when Liz opens a Spreadsheet but invisible when Anne opens it?

    We're all VERY confused and concerned.

    NOTE: None of the Cells are hidden or locked, and neither user is comfortable enough to change Tools -> Options. These are simple spreasheets that are opened, edited, saved, and closed.

    Thanks for any insight or help. We're all exasperated! <img src=/S/shocked.gif border=0 alt=shocked width=15 height=15> <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Changes aren't Saved (XP)

    Sorry for the naive question, but are you absolutely sure that Anne and Liz are looking at the same file? Perhaps they are working on different copies of the workbook.

  3. #3
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    Belfast, Ireland
    Posts
    339
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Changes aren't Saved (XP)

    Hi Hans!

    Always count on you for a super-fast reply, huh! <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    Anyway, no it was not a naaive question. The document that was opened and closed today was in fact an E-mailed document (sorry, but they didn't tell me that <img src=/S/sigh.gif border=0 alt=sigh width=15 height=15> ). So that explains the one today, as it was saved in the Temporary Internet Files Folder. However, there definitely does seem to be a problem with Data not being saved, as this is the 3rd time that Anne has reported changes she made to her own documents not being saved when she reopens them the next day?

    Any thoughts on that? If not, we'll have to assume it's user error, although I know Anne is confident she hits save when she modifies her own files (obviously, as otherwise she'd never have any files saved LOL!)

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Changes aren't Saved (XP)

    I have never experienced problems like that with Excel. The only times data weren't saved were when I clicked "No" instead of "Yes" by accident when prompted whether I wanted to save changes...

  5. #5
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    Belfast, Ireland
    Posts
    339
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Changes aren't Saved (XP)

    Sounds about right, but you know how users INSIST they hit Save?!!! <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    Anyway, as always, thanks for your reply.

    Have a great week.

    Brian

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Changes aren't Saved (XP)

    Search thru the hard drive and the network folders for xls files saved on that day. I have found people having files with the same name in multiple locations or the shortcut pointed to an older archive and not realizing it.

    As Hans, has pointed out, (and I concur) this is the only situation where I have seen files "not-saved", the user saves/works on a different file.

    Steve

  7. #7
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    Belfast, Ireland
    Posts
    339
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Changes aren't Saved (XP)

    OK. Thank you both for your input.

    With Liz, I think she didn't hit 'Yes' in Outlook when asked about saving changes, but she did hit save in Excel.

    The Open and Save As dialog boxes both point to the Temporary Internet Folders, so in this instance, I don't think Liz navigated Folders. I think she just hit Save and that was it.

    Regards

  8. #8
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Changes aren't Saved (XP)

    If you have them change the default folder where files attached to Outlook messages are saved, the problem _MAY_ disappear. This is something that we have discussed a number of times in the Lounge. In <post#=303617>post 303617</post#> there are links given to MSKB articles that explain which key in the Registry to alter. (You'll probably want the one for Outlook XP.) HTH
    Gre

  9. #9
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    Belfast, Ireland
    Posts
    339
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Changes aren't Saved (XP)

    Oh, that's very useful. Thank you very much!

    Thanks to all for your help. [img]/forums/images/smilies/smile.gif[/img]

Posting Permissions

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