Results 1 to 12 of 12
  1. #1
    4 Star Lounger
    Join Date
    May 2003
    Location
    Austin
    Posts
    401
    Thanks
    0
    Thanked 0 Times in 0 Posts

    A Save in time (Excel97-SR2)

    Is it possible for Excel to lose data even after saves?

    I have an operator who swears they lose data occassionally.
    Sometimes whole blocks, sometimes select areas.
    Ironically, it's only the one operator <img src=/S/razz.gif border=0 alt=razz width=25 height=17>

    The sheet tracks time with each entry and only has about 25 rows, so it's not a large chunk of data.
    The time is also hand entered NOT system calculated, so it's not 'missing' a calculation.

    Is there a way to automatically invoke saves?
    Perhaps a 'hidden' way for me to monitor the time of the last entry
    or perhaps an event collector which notates each change made during the day.

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: A Save in time (Excel97-SR2)

    As far as I know, there is no way to lose changes if the workbook is saved. Of course, if the user does a SaveAs to a new workbook, then the changes will not be in the original file.

    There are a lot of things that you can do. Macro code can automatically save the workbook, you just have to decide when you want this to happen. On a time interval, after a set number of changes, when the user changes sheets. If you can define what you want, we can probably help you do it.

    You can also use the many workbook and worksheet event routines to log what the user has done or not done. For example, you can use the BeforeSave event routine to log when the user saved the workbook. Again, you need to better define what you want to do.
    Legare Coleman

  3. #3
    4 Star Lounger
    Join Date
    May 2003
    Location
    Austin
    Posts
    401
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: A Save in time (Excel97-SR2)

    Yes, I realize that I was being rather vague.
    I've looked into several of the possiblities as far as properties and events go.

    My favorites were 'keep change history' and 'list changes on new sheet'.
    Both seemed applicable in this case.

    I'm thinking the least memory-intensive one, because the file is on a network drive
    and this person leaves EVERY app used on the computer that day, open and running.

    Ideally, something that documents WHEN changes were made on each worksheet and if that sheet was saved. Especially, if cell contents were deleted.

    I only really need to apply it to one range also.<font color=red> [RangeA]</font color=red>
    That is the primary focus and source of validating whether any data was actually entered.
    Now I hope I'm not too fractured...

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: A Save in time (Excel97-SR2)

    I am not an expert on the "Keep change history" or "List changes on a new sheet", but I do not think those are going to help with your problem. I believe that both of those will be lost if the workbook is not saved as it appears is your case.

    Some code like this in the worksheet change event routine might get you started:

    <pre>Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Not Intersect(Target, Range("RangeA")) Is Nothing Then
    ' Do whatever you need to do when a change is made to RangeA here.
    End If
    End Sub
    </pre>

    Legare Coleman

  5. #5
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: A Save in time (Excel97-SR2)

    What network software are you using?

  6. #6
    4 Star Lounger
    Join Date
    May 2003
    Location
    Austin
    Posts
    401
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: A Save in time (Excel97-SR2)

    We're on a WinNT 4.0 OS while using a Novell 4.60.604 SP1 network client.

  7. #7
    4 Star Lounger
    Join Date
    May 2003
    Location
    Austin
    Posts
    401
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: A Save in time (Excel97-SR2)

    I checked both out. <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>

    The MS autosave may do, but it requires confirmation from the user to save.
    I need it to force the save. Totally ignore the user's desire.
    What's with the password when it loads the XLA file?

    The other group had a very nice series of useful tools and tricks.
    I am a state worker, wouldn't you know !!
    They won't BUY anything.
    We're still using Office 97... <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>...Nuff said.

  8. #8
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: A Save in time (Excel97-SR2)

    Now promise not to laugh........

    The memories are hazy, but I had a problem a while back. I'd save a file to a novel drive on an NT server at 7pm on a friday night. Another process would pick the file up at 3am and none of my changes were flowing in to this process. To the best of my recollection, after a period of doubting my sanity, it turned out that system backups started at 5 because that's when everyone goes home on a friday night(!) and therefore were being taken whilst I was working on the file, and that at the end of the backup process - a variable amount of time - the whole lot was then copied back again. No-one I spoke to could explain this part of the story. So, if I managed to finish work before the initial backup copy got to my file, I was fine. But if I saved my file later than the initial copy was taken then all my hard work was wiped out. This was only proved by saving duplicate copies to hard drive - and suffering a lot of raised eyebrows.

    Just a thought.

  9. #9
    4 Star Lounger
    Join Date
    May 2003
    Location
    Austin
    Posts
    401
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: A Save in time (Excel97-SR2)

    It may be the geek in me, but that sounds totally logical ...
    Thanks for validating of my paranoia
    <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15>

  10. #10
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: A Save in time (Excel97-SR2)

    It looks as if Jan Karel's utility assumes that network = corporate environment, and the product is not freeware to corporations. If Brooke hasn't already discovered your problem, you may still want to approach Jan Karel about a solution, he checks in here every so often, he may or may not be willing to help with code for your issue. (At some point Jan Karel is going to start getting questions about that feature of AutoSafe from folks with home networks.)

    And, hey, I'm still using '97 both at work and at home, so I'm with you on that score!
    -John ... I float in liquid gardens
    UTC -7ąDS

  11. #11
    4 Star Lounger
    Join Date
    May 2003
    Location
    Austin
    Posts
    401
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: A Save in time (Excel97-SR2)

    I have nothing against making a profit from your own hard work.

    My grievence is with the organizations who purchase software, not the developers.
    I've found that appropriations via government channels is a near impossible thing to do.

  12. #12
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: A Save in time (Excel97-SR2)

    See if Microsoft's AutoSave add-in, or Jan Karel Pieterse's AutoSafe utility, will help this user.

    Edited Mar 13th 2004 to update link
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

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