+ Reply to Thread
Results 1 to 6 of 6

Thread: Excel file keeps deleting     submit to reddit submit to twitter

  1. #1
    Special at 11:30 or w/e
    Sweaty Dick Punching Enthusiast

    Join Date
    Feb 2012
    Posts
    10,267
    BG Level
    9
    FFXIV Character
    Kalmado Espiritu
    FFXIV Server
    Gilgamesh
    FFXI Server
    Sylph
    Blog Entries
    4

    Excel file keeps deleting

    This is for my work machine which I have very limited admin access to. So for commission purposes we keep our sales for each month in an excel file which is stored on the server shared drive. I save the file multiple times a day and keep a shortcut on my desktop. In the five months that I've been at this position on four separate occasions I'll log in and my desktop shortcut is no longer valid. The file on the shared folder is gone.

    Usually I can pull one of the previous saves out of the recycle bin and do a little catch up from a few days, but today when attempting to restore any previous file from the month of November it backdates itself all the way to mid October. So now I have to search for all sales that took place for the last five weeks.

    Obviously I would not delete this file because this creates more work for myself. There are only four of us in this office, one being my boss who relies on these files for our commission plan, so I do not think it's someone deleting the file. How the heck is this happening?

  2. #2
    2600klub
    I donated 5 bucks and all I got was this shitty title from Zet

    Join Date
    Jun 2007
    Posts
    2,690
    BG Level
    7
    FFXI Server
    Ragnarok

    Make a scheduled task on your machine to make a backup copy of the file several times a day.

    Also, does your company not have daily backups to pull the file from?

    I realize this does not explicitly answer your question, but...

  3. #3
    Special at 11:30 or w/e
    Sweaty Dick Punching Enthusiast

    Join Date
    Feb 2012
    Posts
    10,267
    BG Level
    9
    FFXIV Character
    Kalmado Espiritu
    FFXIV Server
    Gilgamesh
    FFXI Server
    Sylph
    Blog Entries
    4

    Quote Originally Posted by Arkanna View Post
    Make a scheduled task on your machine to make a backup copy of the file several times a day.

    Also, does your company not have daily backups to pull the file from?

    I realize this does not explicitly answer your question, but...
    I hear ya. My permissions are extremely limited and I cannot schedule a task on the shared drive. This specific file/program is serviced by a third party. I've reached out to their only line of support (email) and will await a response. I went to my boss and told him about it because this is fucking up my October commission now and to be fair he isn't the most computer literate, says I keep deleting the file and need to figure out how I'm doing it. I asked him why would I do that and he just said idk but stop doing whatever you're doing. Ugg.....

  4. #4
    Special at 11:30 or w/e
    Sweaty Dick Punching Enthusiast

    Join Date
    Feb 2012
    Posts
    10,267
    BG Level
    9
    FFXIV Character
    Kalmado Espiritu
    FFXIV Server
    Gilgamesh
    FFXI Server
    Sylph
    Blog Entries
    4

    I found another place the files are sometimes save, being /user/appdata. Was able to retrieve more of my records. Sad I'm now going to need to make multiple backups because this is not going to happen again.

  5. #5
    Salvage Bans
    Join Date
    Mar 2008
    Posts
    852
    BG Level
    5
    FFXIV Character
    Niya Kouya
    FFXIV Server
    Odin

    Do you have access to your local windows task sheduler settings? This shouldn't require admin permissions.
    If you do, you could write a simple script that runs every day, let's say in the morning when you log in, and create a (local) copy of that excel sheet with the current date in the name. That way you always have a recent copy of the sheet and don't have to search through your recycle bin or hope for appdata copies.

    Something like...
    Code:
    REM current date in format yyyy-mm-dd
    SET TODAY=%DATE:~6,4%-%DATE:~3,2%-%DATE:~0,2%
    copy "X:\path\to\sheet.xls" "C:\sheet-backup\%TODAY%sheet.xls

  6. #6
    Special at 11:30 or w/e
    Sweaty Dick Punching Enthusiast

    Join Date
    Feb 2012
    Posts
    10,267
    BG Level
    9
    FFXIV Character
    Kalmado Espiritu
    FFXIV Server
    Gilgamesh
    FFXI Server
    Sylph
    Blog Entries
    4

    Support just emailed me and I guess our corporate side also keeps 30 days of backups for all files. I'll fiddle with that scrips Niya, and I appreciate you posting it. Today has been an absolute shit show so far and I already feel like I've put in 10 hours and a stiff drink sounds like the greatest thing ever.

Similar Threads

  1. Corrupted Excel File
    By Alvinho in forum Tech
    Replies: 14
    Last Post: 2017-04-12, 07:50
  2. IPhone keeps deleting notes
    By Melena in forum Tech
    Replies: 3
    Last Post: 2010-08-18, 17:41
  3. Replies: 0
    Last Post: 2010-03-08, 09:14
  4. How do you delete files that are 0 Bytes?
    By Funkworkz in forum Tech
    Replies: 14
    Last Post: 2009-10-10, 14:24
  5. Cannot delete file...
    By Pikarya in forum Tech
    Replies: 4
    Last Post: 2009-08-14, 11:56
  6. Deleted Vista Profile, can't find files
    By Dmitry in forum Tech
    Replies: 2
    Last Post: 2009-03-25, 12:20
  7. Replies: 7
    Last Post: 2008-06-24, 10:18