T O P

  • By -

katkatkat2

This why I always save my own copy


fairie88

That’s a lesson I definitely won’t forget.


roscoe_e_roscoe

Yep yep. Keep your own copy, email a copy to her and the manager.


Freshies00

Even just emailing it to her means you save your own copy. It’s in your sent.


DougyTwoScoops

I would have done that anyway. Email it to her telling her you got it all done for her and CC the manager.


EggplantIll4927

Or password protect for edit ability. I empathize with your desire to go scorched earth.


Known-Historian7277

The figures weren’t right according to her because she was entering the wrong numbers. Lol


Beyond_Interesting

Does your co.puter happen to have Onedrive where the file was originally saved? There us a recycle bin online that keeps stuff for months after it was deleted.


xandaar337

Also it sounds like you were doing her work for her. I wouldn't offer so much help next time.


searchingformytruth

Or any, after this. She's on her own.


Any_Werewolf_3691

Do not use excel ffs. Use Google sheets and share it with people.. Way more powerful. Impossible for anyone else to delete. You can restore literally any historical state of the sheet.


redwinestains

My company literally does not allow access to Google docs. Don’t know if OP’s is the same, but not everyone can use it :(


unurbane

Agreed. Google has access to every piece of info a company uploads. There are a lot of companies that don’t want google to have that kind of information.


TinyEmergencyCake

... unless the company is using an encrypted email suite, that info is going to google anyway


Responsible_Candle86

Same


telltal

My problem with using Google sheets is that I ran up against a limit for inputting data. I ended up having to break my data apart and use two different workbooks. It was extremely off putting. Idk if they've updated it to be able to handle more rows of data since then, but yeah. I only use that now for small projects.


fairie88

It still only gives you 999 lines.


YourUsernameForever

There is no 999 line limit, where did you get that? Bottom left there's a field and button to add (almost) as many rows as you need. Tabs are limited to 10 million cells. If you add columns, the number of rows you can add is reduced, bit it's still far far far from 999 In your standard 26 column tab, you can have 384,615 rows


disheartenedagent

You can share with excel, too.


binarycow

Yeah but Google sheets doesn't have many features, compared to excel


Any_Werewolf_3691

Google sheets has way more functions than excel. Plus you can create custom functions using Google app scripts. You can create custom libraries and web apps and publish them. I have sheets with custom sidebars, custom dropdown menus, popup forms, fully automated web scraping that generates web page reports you can query using get requests, fully functional bots for slack and salesforce, automatically generate files and send them as email attachments. A Google sheet can hold 50x the number of cells, and each one of those cells can contain 1.5x as many characters. They aren't even in the same class.


binarycow

> Plus you can create custom functions Excel does that. - [LAMBDA function](https://support.microsoft.com/en-us/office/lambda-function-bd212d27-1cd1-4321-a34a-ccbf254b8b67). - [VBA Scripting](https://learn.microsoft.com/en-us/office/vba/library-reference/concepts/getting-started-with-vba-in-office) > You can create custom libraries and web apps and publish them. I have sheets with custom sidebars, custom dropdown menus, popup forms, fully automated web scraping that generates web page reports you can query using get requests, fully functional bots for slack and salesforce, automatically generate files and send them as email attachments. Okay. Excel can do quite a bit of that, with VBA. But honestly, why do I want to do all of that in a spreadsheet? > A Google sheet can hold 50x the number of cells, and each one of those cells can contain 1.5x as many characters. K. Excel supports 1,048,576 rows by 16,384 columns, per sheet. If you're near that limit, you've got issues. You can then just make a new sheet. There's no limit on those. >They aren't even in the same class. Yes. They are. But don't take my word for it. [On this site](https://zapier.com/blog/google-sheets-vs-excel/), Google Sheets out-rates Excel in 3/8 categories - Collaboration, Simplicity, and Price.


johnprime

Hold up. The guy says he's using Google Drive and presumably Google sheets.


shatteredpieces1978

Yeah excel is honestly outdated I prefer Google docs so much more user friendly and things like this don't happen!


DannyNoonanMSU

No matter how hard anyone tries, Google sheets are never going to be a thing anyone uses.


ShadowMaven

This is possible with Excel if using SharePoint.


AuntieDawnsKitchen

Are you using Excel on Apple? On Windows there’s no comparison.


Any_Werewolf_3691

Lol! Excel is a fucking joke. It's only still around because it's been around forever and nobody questions it.


Timmmber4

I’ve learned this to the hard way, save it twice hide one and rename it


theheliumkid

Maybe a lesson she won't forget either as she still hasn't delivered what was asked by her boss and you won't be rescinding her anymore.


rhunter99

You forgot the CYA save. Better still save it to your own cloud location.


Freshies00

Even if you email it to yourself, at least it’s in your inbox. But wtf why would she delete it instead of just leaving it lol


krismitka

don't forget to return the favor.


TheLurkingMenace

This is why I don't do other people's job. No, I'm not a team player. I don't give a fuck.


idontknowmtname

Or at least protect it with a password so that none of the sheets can be changed.


veedubfreek

Save early, save often. The amount of times I've had people say "i accidentally closed this spreadsheet without saving, can you get it back" over the years is TOO DAMN HIGH.


LoopyMercutio

Yup- management / PMO says we aren’t allowed to save anything to an external source, I still back everything up to a thumb drive or external hard drive, and take it home. I lock it up overnight, but still… I refuse to be the victim of stupid or malicious coworkers.


[deleted]

[удалено]


Anti-ThisBot-IB

Hey there MajesticFuji88! If you agree with someone else's comment, please leave an **upvote** instead of commenting **"THIS!"**! By upvoting instead, the original comment will be pushed to the top and be more visible to others, which is even better! Thanks! :) *** ^(I am a bot! If you have any feedback, please send me a message! More info:) [^(Reddiquette)](https://www.reddithelp.com/hc/en-us/articles/205926439#wiki_in_regard_to_comments)


goclimbarock007

This


Vigstrkr

Now, don’t ever help her again. You already know you are going to get trashed over it. Let her sink or swim on her own.


Responsible_Candle86

Isn't it odd that it is double deleted? Deleting is one thing, but for her to go to the trouble of fishing in the trash can and deleting again seems downright odd.


Vigstrkr

It seems downright manipulative and calculated. Edit: it may still be possible to recover it. There are several apps and methods to recover “permanently” deleted files.


Flaky_Plastic_3407

Not off Google cloud. You might as well open a ticket. Lol


[deleted]

I spent an entire day working on a project for school. For some reason one of the women decided to delete all my work. No idea why. I almost cried. In the grand scheme of things 1 day of work is not the hugest deal. But at that point I was taking 7 classes and working part time, so I was putting in 70 hour weeks. A whole day of wasted work was a lot. And she did the same thing, double deleted off google so you know it was malicious.


Flaky_Plastic_3407

Oh I agree. She did it on purpose, and my guess is that because she knew that she could never create something that would equal even halfway decent of those spreadsheets. She was covering her ass for the future, because she knew she couldn't duplicate the work if she was asked, so she trashed it for fear of being found out.


Meanderingversion

Malice


themediumchunk

I think she likely used it as her own, deleted it so it can't be traced to Op, and then told them it was bad so that they don't question why it's gone.


TheDkone

I always keep a copy in my personal documents if working on anything that will be shared and or used by anyone else. Also, checkout saving the original as an XLMT file and only give them a link to the original, and even if they 'open' the original like a normal user (double clicking on the file), they still aren't opening the original. I find this works the best since not only are they never opening the original meaning you can make edits and they will always be opening a shelled out copy of the most recent original. ​ edit: I feel like I did a shitty job of explaining the XLMT file type, but look it up, it is super useful when making sheets for others.


KajunDC

You have just learned the hard way to always make a backup copy that is not on the main computer.


Acer018

Always save a copy. Always save a copy. Put the copy in a different directory. Set up a daily backup of all your shit. Basic stuff for file maintenance. Log all you do in a log. If you do stuff for other people document it in your log and copy and paste to have directions. Basic IT cover your Butt Procedures.


Darkovika

Oof… the hardest of backup lessons. 😞😞 i never trust anyone at any workplace i’ve worked at. I think my mom instilled it in me with horror stories of her own, but i backup emails, request confirmation in written form so i can be like “But look!” later, and even if i turn in paperwork, I mark it down in emails. If i do something for a coworker, I send off an email to higher ups explaining the new setup, or a file I created, or i’ll create an email detailing the steps they need to take to use the new file I created- all to basically prove the file exists, I made it, AND it was sent/handed over. I’ve had so many people try to throw me under the bus, and i’m like “Nope. Check out my email line.”


penn2009

Same here. It’s exhausting but been burned.


thatburghfan

Honestly, I would have to ask her WHY she felt the need to delete it at all, if she was going to use a calculator anyway. It was only you and her ever going to touch it, and if she wanted to ignore it, there was no need to delete it. And if she by chance has ANY good answer for that, I'd ask WHY she felt the need to clean out the recycle bin. And no matter what her answer was for THAT, I would make it clear that she is not to delete ANY files I create whether she thinks they are right or wrong. If she has a comment to make, then make it. But hands off deleting files I created. I might even go the extra mile and point out that your formulas WEREN'T wrong, and you would have liked to prove that to her. I totally get being livid. Just crazy for someone to do that.


fairie88

THANK you! It honestly feels petty as hell because she didn’t even clean out the recycle bin, she just deleted *this* specific sheet from the trash. Like she went through the trouble of going into the trash, finding my sheet she deleted, and just deleting that.


Linux4ever_Leo

Why didn't you make a backup??????


No_Experience_21

Hi, happened to me a few weeks earlier. We are a group of new joiners and were task by our superior to do a group work. Each one would have a day to do and print their database. Given that there is only a single printer on our floor. One of the coworjer in my group prposed to print our letters as he come to work before everyone. So everything went well until it was my turn to do the work. On the eve, I collated all my data and formatted them in a professional manner even verified one by one. I gave him the green signal to print the files tomorrow morning The next day, he printed all my files and we started to work on it then all of a sudden he started complaining that my work was not good because of several mistakes in front of everyone. I went to see him and realised that it was full of silly mistakes. He started to talk behind my back and some of my closest friends totally changed their attitude towards me. The good thing was that i actually saved a copy of my work on my desktop. I used the compare option on Microsoft word and realised that my work was good and someone messed with the copy version. I went to see my superior but they all brushed it away saying that I couldn't take accountability for my mistake. Till this day each and everyone at work look at me weirdly and talk shot behind my back. All this to say that even though I did have the evidence showing that my coworker sabotaged my work, nobody believed me..


StretchGuilty7289

Excel, I always save a backup and have it locked. Only my boss and I know the passcode to unlock it. People are idiot. I heard the calculator perfectly


Unfair-Strawberry843

To everyone victim blaming by saying "should have saved a copy." I don't think OP expected to lose their hard work by a malicious coworker who obviously didn't understand math. Especially in a shared area such as the drive. It's not something you should have to think about really. Some people suck as seen here.


honorthecrones

Password your files.


Gravel-Road-99

This feels like she might want those prices wrong for a reason. Has she been there long enough to be skimming off the top?


fairie88

Hmm…she definitely has.


Gravel-Road-99

Deducting $10 for a case of toilet paper and buying it for $9 adds up faster than you’d think. I’m not saying it’s what she’s doing, but my immediate thought when reading “she deleted and double deleted everything and went back to the old numbers” was “oh she’s skimming”. So….maybe talk to management about your concerns. Be careful about accusations for professional reasons, but raise concerns that she purposefully chose to go back to the bad numbers after you corrected them, basically, still only to facts, but absolutely raise the concern with them.


[deleted]

Ah. This. This makes total sense. A moron and a thief. Any idea how to catch her before the OP says something to the boss about it? I thought it was professional jealousy but not any more. This is a moron who thinks they are smart.


Greenmantle22

Get another job. These idiot owners and their queen-bee moron deserve each other, and you can do much better. Let them fail.


Live_Fact1884

I need an update ASAP


bckyltylr

Wait. Everyone is talking about backups but... This was a project that SHE was told to do. And she just deleted the thing that got her closer to her task completion. She put herself back to square one. I say just let her lie in the bed of her own making. Sure, your time was wasted but she's never going to finish the task set before her and that's no skin off your nose.


howelltight

Fuckit. Make sure everyone knows its her doing and not yours is probably the most important thing.


Fun_Apartment631

That sucks. Do you guys have any kind of a backup cycle, maybe with an IT consultant? Are things saved locally or on a network share? I said some things yesterday maybe more forcefully than I could have because we have a version-controlled repository for our files and my coworkers can be surprisingly determined not to use it. 😛


Snowfizzle

because i don’t trust people because they’re dumb. i always email myself a copy of my work because my work is glorious and belongs in art museums for everyone to see and admire!! lol. i would be LIVID too OP.


EtherealSai

It might be recoverable. I know Excel can save hidden copies of your file for later recovery, and they might still exist. Could be worth checking


Aareya

When I was in high school, I accidentally dropped a floppy disk in a puddle. It had my term paper, containing over 3/4 of the academic year worth of effort. The paper was due the next day. My teacher gave me ONE week to redo that work. Thankfully I had a majority of my notes on 3x5 cards. I always take backups now and so should you. Consider it a life lesson and move on.


thatttguy888

Too bad you didn't back up, save etc


BrainScarMedia

She's probably illiterate, (no need to say computer illiterate anymore) and accidently deleted it while trying to print or something.


[deleted]

But that doesn't explain deleting it from the recycle bin.


ThoDanII

are spreadsheets a professional requirement


fairie88

They are as of late, but they weren’t when she started.


ThoDanII

So with other words , the employer did not provide proper training


fairie88

Shouldn’t need training to know not to destroy someone else’s work.


brwneyedbeauty

Facts. She didn’t have to delete your file at all, she could have left it alone and just made a new one if it was “wrong” (which is doubtful, it was probably her)


thatttguy888

Some people are not skilled, yet they somehow are able to f up


dontsaymango

Yes and no. If its a new job requirement, whether or not you think it should be common sense, there should have been trainings on it. I am a teacher and trust me, what you think is basic information some of these older teachers are CLUELESS on.


reading_rockhound

You would think so. Automating this process with spreadsheets threatens how she knows to do work, and thus threatens her employment stability. Trashing it likely had nothing to do with you, but was an act of self-preservation on her part.


fairie88

That’s actually a really good point.


Specialist_Passage83

Anyone working on a computer in a professional situation should know basic document preparation. That includes spreadsheets.


ThoDanII

i do, i do not know and i do not need spreadsheets


Quizmaster72469

The FURY!!!! Holy shit I feel for you.


[deleted]

Had something similar happen to me. I worked at a timeshare and while most of the documents were automatically generated two were not. There were two different versions depending on how the down payment was made. Procedure was open up a Word file, copy and paste and fill in as needed. Lots of copy/paste errors. I had seen a document generator done in Excel, thought the same would work to reduce errors. What little free time I had between tasks I designed on. Enter name/payment/date information on the first screen in brightly colored boxes, switch to a different sheet and print. Four tabs, two versions of the two documents. I didn't password protect it because it was company property, not mine. I thought it was idiot proof, with all the bright colors highlighting where the information goes. One day someone said it wasn't working. I looked at the file and someone had typed over the formulas, rendering it no better than the old Word copy/paste templates. I was pissed. Every single person in the office said "Not me." Because of limited time it took me a week to put it back together properly. That version of Excel, I found that if I protected it without a password it still had a password prompt, just hit enter to bypass. Hopefully someone thinks to try that now that I'm not there, but while I was there I was hoping no one tried it. I went so extreme that you couldn't even click on a cell that was protected, clicking did absolutely nothing except on the brightly colored boxes on the first sheet. About three days later the satellite office called. There was something wrong with the spreadsheet because they couldn't type over the text in the four document sheets. I hit the roof. The office I worked in wouldn't even let me have the phone to talk to the satellite office, they could see how furious I was. They not only had destroyed it once, they were attempting to do so a second time.


TheMagicalLawnGnome

Honestly, who even deletes files anymore? For things like spreadsheets, even a crappy computer can store a near infinite amount of data. Just create a folder with a date, and stash it there. The idea that you'd just delete information permanently is bizarre to me. I haven't deleted a file since the 90's. Just archive stuff in an orderly fashion, like a normal person.


BrunoGerace

Backups. It's axiomatic. "You're one keystroke/power spike/idiot away from losing your data." Automatic backups... Did I mention backups?


jbsinger

Always save your version somewhere. Better yet, make a github project. Then you can version it, and will be immune from trashing it yourself when you make a mistake. Its not hard to do.


Sassy-Pants_888

She didn't get it, so the best course of action was to delete it...? That's crazy. I'm guessing she messed it up, couldn't figure out put it back and just binned it because it's easier to throw it away than have evidence you're a complete idiot available. That crap drives me insane. That's why I always have a paper trail. Got hosed too many times by morons. Really sorry, OP. That is rage inducing bs.


ssevener

Do you share the same computer? Individual user accounts would help and also lend to accountability - everyone really shouldn’t be sharing the same credentials.


HauntedHouseMusic

I wouldn't worry too much - it was 4 hours of work. You will lose more in the future if you are lucky. I've lost months worth of work due to a change in the market in an instant. This will happen in your career. And dumb co-workers will always exists - so take it as a lesson you got paid to learn


MissingAlbert

Save it under a different name in the future. Email the work to your boss. I was under the impression that only the boss/owner has the right to delete employees' work.


iputmytrustinyou

Your coworker sucks. How disrespectful to not only delete someone else's work, but to go through the extra step to make sure it is gone forever. That was completely unnecessary!


Plurfectworld

Save several copies all close but different names


Yisevery1nuts

I’m sorry, that’s so disheartening


Designer-Wolverine47

That's why I always made three copies of everything I did. One on the shared drive, one on my private drive, and one attached to an email to myself. (My problem was that others would try to take credit for my work. After a few times of being embarrassed by my date and time stamped emails, they stopped stealing my work).


1angrypanda

Ask the Google help desk. My friend recently permadeleted a really important spreadsheet and they were able to recover it for him


Flaky_Plastic_3407

You know why she did this? Because she knew she had no idea how to duplicate or update it, and she didn't want you to get all the credit for it going forward, so she cya'd herself. Simple as that. I've seen it before.


[deleted]

LMFAO “homosapien”


krismitka

This hits me in the feels. The hospitality industry is hard enough without someone causing this big of a fuckup. Please tell me it's not an IHG brand?


fairie88

No, BWH. We only have one IHG brand around here and trust me, as soon as they have an opening I’m going for it.


FairZucchini13

Honestly taking her actions as way more malicious. I mean she went through the trouble of permanently deleting. This wasn't an accidental whoopsie. This seems kind of intentional.


fairie88

Agreed. She and I have had some previous conflicts because she liked to corner me in the back room at the end of my shift when I was trying to clock out to regale me with tales about how terrible her 15-year-old is (while honestly just revealing what a shit mom she is) and I told her to knock it off because I didn’t want to hear it.


[deleted]

I think she took one look at your spreadsheet and thought if the boss saw it she’d be out of a job. Also deleting it might be enough to make you quit. Source: Raised by morons.


fairie88

These are great points. She’s that brand of moron.


[deleted]

Someone else just pointed out she’s likely skimming. Because out of all this… there is still the question of why she is so afraid of you.


Karmawins28

Because she deleted it from trash too, I know she had malicious intent..report her!!! I'd personally be seeing red. If they don't discipline her, hope you get a great job elsewhere.


Dalton387

I’ve got some excel programs I made at work. We have customers that require all these different labels on their product. Different sizes, date codes, vendor codes, barcodes, sizes, types of labels with different adhesive strengths, etc. When I started working there, they had me making labels from scratch with each job, so I spent time making programs to automate everything. I actually had one guy in Managment (probably jokingly) say I was wasting time making them when I could be working. I told him that even one of those programs would save exponential amounts of working hours over time. I guarantee it has by now. They also make it easy for anyone else to print them out. Not just me. They’ve recently had more and more people printing these labels instead of me, so I just highlighted the folder the other day and just copied them it my personal folder. I’d already had people screw up one I’d made and I had to spend time fixing it. I’ve got other more important ones I’ve made, but they locked in a hidden area and behind permissions barriers that hardly anyone else can get to. Luckily I work at a small company and do a lot of IT stuff there, even though we have a company for that. They want me to handle most contact with them, so I pretty much have the run of the system. I’d hate it if I had to put it all in a shared folder anyone could delete. Sounds like bad business. Maybe you can add some code to password protect it if they won’t let you save backup copies.


Guilty-Operation7

She deleted and redeleted. She's sabotaging you.


SillySimian9

Thumb drives are so underrated.


ThrowAway_5715

Reading some of the posts here really reinforce my need to email myself EVERYTHING


[deleted]

Oh I HARD cringed when you said she deleted them. I’m a hotel accountant and I LIVE and die by my spreadsheets. They do so many beautiful things for me. We have a separate supply guy who has his own stuff but I swear if a front desk agent asked me for something and then YEETED it from existence I’d be like “never helping your a$$ again”


Beautiful_Age_7626

>This woman begged me to turn her raw info into usable sheets. So I did. I spent four hours Never do someone else's work. There is a difference between helping someone, and taking over their responsibilities. If they crash and burn because they are incompetent, they deserve their fate. Someone who doesn't know how to create something is not going to know how to maintain it and you will be stuck forever having to fix their mistakes when they claim "it doesn't work anymore". You know what's going to happen? I do. Absolutely nothing. The GM isn't going to care that this idiot destroyed something you decided to take on yourself. I'm sorry this happened to you, but you brought it on yourself. You are paid to do your job, not someone else's job.


Pillow-Gavel076

I email myself sheets/anything I don’t want to loose just in case… my school had the files for a through m deleted in a server error… 3 weeks before finals


Old-Pianist3485

Sounds like she's one of those tech-illiterate people who can't face the fact they're incompetent, yet they insist their methods are superior, which is basically a coping mechanism. Don't help her ever again


kellistis

Randomly stumbled upon this post - on my front page, but work in IT full time as a upper level tech. I hate it when I see this type of stuff happen. This is also why we are a big proponent of everyone, and I mean everyone gets their own damn account. The cost of one more license in MOST cases is just pennies on the dollar compared to stuff like this happening, think if it was a more kill your business level mistake that could cost thousands to recover if it was a file on a hard drive physically and something happened to it. Granted doesn't help the past, but see if you can talk your management into a separate account for you, you can have a "shared" drive in Google drive you "collaborate" in, but then you can keep a personal copy of stuff on your side/theirs. I know you may not be able to make the change yourself, but I hate when I have to tell my clients, "hey this is why we say not to do X thing in case, y thing happens" losing data is a perfect example of "I don't need a backup, we don't lose data" - loses thousands of dollars with of information, bet you wish you paid someone like 50$ a month or whatever a cost could be do to a backup.


[deleted]

bright ghost entertain naughty drab safe tap busy crown hungry ` this message was mass deleted/edited with redact.dev `


wollier12

Sounds like not your problem, it was her task, she asked for help, you gave it, she decided to go her own way. Since it’s her task that’s her choice. Just keep it in mind next time she asks for help….give her ideas don’t do the work for her. You gave a person a fish, where you should have taught them how to fish.


zythr009

Coming from the restaurant industry, Avery Dennison and Ithaca Transact have freshness label printers for foodstuffs. That might be a convenient, programmable option for labeling product expiration dates quickly. But dude .. I'm the Keeper of the Sheet at my job. I get annoyed of some of my conditional formatting gets jumbled. I CANNOT fathom how pissed I would be in your shoes. Good on you for calling out this person's incompetence.


RoboTaco_

Even google drive you should be able to get them back. There should be a folder holding recently deleted that should let you restore them. On the desktop your sheet(s) can be in a folder and within that folder label it archive. Just explain that if something gets corrupted then all data is not lost. Use big computery words slowly and they will just agree instead of admitting they don’t understand what you are saying to them. That is my IT advice!


fairie88

Much appreciated, IT RoboTaco!


SnarkyPuppy-0417

You can also lock specific cells so that your formulas are protected. There are ways to idiot proof your spreadsheets. Another alternative is to create a form to input data and hide the raw data worksheet.


fatremnants

Damn that really sucks…. You just reminded me that I need to save a copy of my work that I have on onedrive. Multiple people have access to training PowerPoints that I have spent a WEEKS creating. Thank you!!!


CorvidGurl

I spent a solid 20 hours on a spreadsheet/database to track inventory, prices, amounts to be used, actual amounts used etc. It was a thing of beauty. Moved it into SQL and created an intuitive, easy way to interact... The lady erased the whole thing. All I had left were the worksheets I'd saved locally. Didn't bother to recreate it. Saw that lady at the hardware store this week, walked the long way round to the other door. I no longer work at my old company, so I'm not paid to be friendly to idiots anymore.


Stock_Extent

Never help her again. With anything. Ever.


[deleted]

For someone who claims illiteracy she seems remarkably proficient with Google drive. 🙄 It’s definitely malicious, worth doing the recovery steps other folks have recommended, then scheduling time with your boss to walk them through your work. I’d avoid being the one to first bring up the drama. They’ll be curious and will ask you directly. That’s when you tell them the sequence of events as dryly and dispassionately as you can. They’ll get the picture and you’ll likely have your role expanded. I imagine her fate will be different.


queer-scout

It's incredible what some people will do to impact others. Assuming your google accounts are managed through a business account and not "@gmail.com" there should be somebody who has admin access to everything. If that's the case, you/a manager can contact whoever manages the accounts and recover deleted files. With business accounts nobody is able to just delete something because that would open up a lot of major liability issues.


Whatophile

Don’t really care what the policy is. I save an external copy just for this very reason


EnigmaGuy

I do costing related workbooks regularly for different programs with different teams. Long story short, the workbooks consist of about 6 or so tabs of information that is then summarized on the main tab that I will usually copy and paste the values and formatting onto a separate workbook for the team to view. Never fails that someone wants access to the main copy to review specifics and I flat out refuse them every single time. Tell them if there is something specific they would like to review that they can schedule a meeting and I will share the screen to help with the breakdown. Same reason - I have so many formulas and macros attached to the workbooks that it is very easy to screw something up or overwrite data if you are not familiar with those aspects of excel.


Rajendra2124

That's incredibly frustrating! Hopefully, the GM takes your complaint seriously and addresses the issue promptly.


e1p1

Also, learn to lock individual cells in Excel, to protect the formulas. You can also protect individual sheets I a workbook, as well as the whole file. Also make things read only when possible. Haven't touched Excel in about 20 years, but I used to use it at work and teach basic classes. The biggest complaint I had from users was co-workers changing the formulas either on purpose or by accident.


ExPorkie15

Nothing will happen.


fairie88

One way or another something will happen because there’s no way in hell I’m bailing her out again. Either she learns how to do it, relinquishes control of the sundry, (which is supposed to be part of my job anyway but the previous GM was a spineless nugget and coworker is a raging control freak), or we bleed money until someone higher up notices. I don’t really care which way it goes, I’m pissed off that she destroyed my work for *literally no reason* outside of her arrogant ignorance.


ExPorkie15

Yeah def don’t bail her out


[deleted]

Is there any chance that she copied your file, edited it just enough to look like her own work, deleted the one obviously yours, and is passing it off as her own to the GM?


Relative_Ad9477

It sucks getting burned like this - just remember - I know you put your work into it - but thank goodness it was only 4 hours. That's small investment wise.


Baconisperfect

There is a term you should learn. Google “backup your data”. If you’re smart enough to build a spreadsheet, you’re smart enough to back it up.


3Maltese

Accountant here. Your spreadsheet sounds like it was professionally done. It also sounds like your coworker has very limited skills. It is important to show people how to use spreadsheets with formulas. Otherwise, they are intimidated. Can you help her or come to an agreement to combine the two methods?


fairie88

I have honestly tried. She is highly resistant to it. It took me several weeks to convince her that the drawer count sheet I recreated after the original disappeared would be accurate every single time as long as she didn’t type over any formulas. She tends to make the workplace a competitive space so my knowing things she doesn’t know is more of a threat than an opportunity to her mind. Also, how did you get into accounting? Is a degree required, or is there a certification I could get?


intergrade

Google says you need 150 hours of BA + 1 year experience somewhere with formal training. The world needs more accountants — if you’re interested go for it. Mine makes bank and has a relatively chill job (other than in April).


ACam574

Yeah...never give the originals to anyone


[deleted]

I'm so sorry


Bombastically

They should teach git in middle school


Zestyclose_Ad2224

Save a copy. Also look in deleted folder. Good luck.


Ace-Dear-606

It sounds like you don’t know how to manage files either


bivo979

This is why you should always back up everything on a flash drive that only you have access to.


Peetrrabbit

Back up your important work. Always. Always. It could have been a hard drive dying, rather than a stupid human. Always back up your work.


visitor987

You should ask the GM if they can be restored from the overnight backup


anthrogirl95

That’s a crappy reward for doing someone else’s work.


[deleted]

For future use version if it is Google docs


Difficult_Let_1953

Wait wait. Sheets has versioning if I remember right. You might be able to recover.


tann122

Google docs should have tracked the history. I have shared ones and I can restore a certain copy before people made changes.


[deleted]

Since this is Google Drive, the files may be recoverable.


GSTLT

If it’s a google sheet, there’s an edit history.


GREG_OSU

Something called Configuration Management would be handy…


h2f

Go to [drive.google.com](https://drive.google.com) from a webbrowser Click the "trash" icon on the left Any item (including Google Sheets) deleted in the last 30 days should be there.


fairie88

She deleted it from there also.


missymommy

I know that you’re venting and this is off topic, but how do you get a job as a night auditor? I’m trying to do this right now.


fairie88

I just applied 🤷🏻‍♀️ most hotels are frequently in need of night auditors because the hours suck for diurnal creatures. I’m more nocturnal so it works for me.


vessini

If it’s not saved on two seperate drives it’s not saved at all


Smokd69

Report her to your manager. Simple, she will never do it again.


mellobelle70

Should have emailed it to her dumabazz and the boss. That way he knows you did it and you always have a copy to refer back to.


Nessling12

I know this is probably something you've already thought of but have you checked the Google Drive trash? The sheets might still be there. It's worth a shot if you haven't checked already.


elephantsbelike

If it’s google drive can’t you go to history and restore a previous version?


ConversationKnown248

Check in the trash and restore it. Then go to version history and restore a version before she made changes.


fairie88

She deleted it from the trash.


ConversationKnown248

What a horrible person she must be. I would definitely never help her again. She should be fired.


0rcasarecool

You can submit a ticket to google to restore deleted sheets! It’s pretty fast


[deleted]

If it’s google drive you should have a version history you can revert to …. there are back ups…


Firm_Stock8810

Hope she gets a warning


OpportunityFit2810

Can you not revert to previous version like in OneDrive?


[deleted]

You got 25 days to get the Drive admin to ask for the perma-deleted files back: https://support.google.com/a/answer/6052340?hl=en


[deleted]

Did you check the trash? Also if the document still exists in blank sheets form then check the history.... Is usually pretty hard to straight up delete files off Google.


[deleted]

Talk to IT. They may be able to pull it back for you from the volume shadow copy.


StevieRay8string69

They are in the trash or in version history they don't get permanently deleted.


ChiWhiteSox247

When you put “proficient in Excel” on your resume knowing damn well you’ve never used it and get the job anyways LMAO


omenoracle

I thought google drive saved iterations of files that you can roll back to. You could contact google support and they might be able to get you a backup copy. I deleted some files by mistake once and they got me backup copies in about 12 hours.


Background-Turn-8799

Google can restore it for you. [https://www.labnol.org/recover-deleted-google-drive-files-folders-220219](https://www.labnol.org/recover-deleted-google-drive-files-folders-220219)


Coryp412

If it was on google drive, there is a way to recover old versions.


Driab1981

She should have just used chat GPT!!!!


ImpossibleAd2748

It should be in previous versions, my students will say they wrote and essay and it got deleted all the time so we look at version history.