0

I have a excel sheet where a person fills in data. This occurs offline on a laptop.

Excel sheet has auto save.

But to be sure to have a backup if the person delete some rows by mistake, I would like to copy file every 5 minute to another folder on the laptop.

But without deleting the file already copied to the other folder. I know this will give me a lot of excel files in that other folder. But it's only 100 files x max 200 kB a day and then they will be deleted

I have asked in another forum if robocopy could do that. But seems not.

I got a link to a case in this forum here. But not sure I understand fully to transfer this to me. I'm not especially good in scripts :-)

Batch to copy file with subsequent file names

Last comment: The file is in a local google drive folder.. But if that's not possible I could move it to a normal windows folder on C drive.

Improve this question
4
  • 1
    Why not simply use google sheets? This includes versioning, so any edit can be undone.
    – MiG
    Commented Aug 29, 2022 at 13:59
  • If the file is stored on Microsoft OneDrive, OneDrive will also do versioning similarly to google sheets. If you really need software, Free File Sync can be configured using Real Time Sync to do exactly what you want. Make a backup of files every time it changes, with a time-out timer to ensure its not backupping too often. It can also move older versions to another folder with versioning numbers and delete them after x days.
    – LPChip
    Commented Aug 29, 2022 at 14:54
  • Hi.. thanksYes why not use google sheet. Did not know it had that feature...will look at it.. Thanks
    – koden
    Commented Aug 30, 2022 at 11:37
  • There's a 'last edit was x' shortcut in the menu bar, right of 'help'. I'll turn it into an answer.
    – MiG
    Commented Aug 30, 2022 at 11:42

1 Answer 1

Reset to default
0

You're already using google drive to share these files, so why instead not use google sheets? This includes versioning, so any edit can be browsed and undone.

If you click the 'Last edit was ...' link to the right of the 'help' in the menu, you will get a list of edits/versions and which user made them:

enter image description here

Offline use is possible, assuming you have the Google Drive client installed:

  1. On your computer, go to drive.google.com.
  2. Right click the Google Docs, Sheets, or Slides file you want to save offline.
  3. Turn on "Available offline."

You may have to make sure only one offline version is edited at a time, or there might be colliding versions. This is no different from sending the same xlsx file to multiple authors and receiving edited versions from each of them.

Improve this answer
4
  • If you click that 'last edit' link, you'll get a long list of versions. There's a limit of 100 versions in 30 days, after which the oldest ones that aren't marked 'keep' are purged. Note that you should use comments for this, the 'answer' section is for answers alone (I've put my response here in case yours gets deleted). I'm not familiar with the script you mentioned, but it looks like it makes a more permanent series of snapshots, yes.
    – MiG
    Commented Aug 30, 2022 at 15:52
  • sorry yes... not use to this type of forum and comment / answer. But seems that "last edit" solve my issue if I'm online. Will test it offline.
    – koden
    Commented Aug 30, 2022 at 16:14
  • Off course it's a online feature "last edit" is gone when off the internet. using downloaded google drive on laptop. So assume I can't use it without person being online?
    – koden
    Commented Aug 30, 2022 at 16:33
  • I assume that 'last edit' only gets updated from an offline version when Google Drive synchronises it. This I'm not sure about, google sheets I only edit online.
    – MiG
    Commented Aug 30, 2022 at 19:00

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .