20
submitted 8 months ago* (last edited 8 months ago) by appledinosaurcat@beehaw.org to c/technology@beehaw.org

I am no stranger to Excel and Tech in general, however this stumped me! This all occurred on the corporate laptop where we connect to the network remotely using a security token ID. Any help is extremely appreciated as I would hate to have to do hours of re-work. Adulting is hard.

I was working in an Excel spreadsheet, when suddenly the Excel application started glitching. Any updates to a given cell would not immediately reflect. I could only view the change after toggling to a different tab and returning to the tab with the updated cell. Instead of clicking the Save button, I clicked the Exit button on the Excel file as I know a pop-up would be triggered if changes were made since the most recent save. The file closed with no pop-ups, so I figured that was because I had already recently saved the file which I remember doing. I then rebooted the laptop, logged in again with new token as we do each time, expecting to see all my updates when re-opening the file. Especially because the time stamp of the file clearly indicated the moment right before the reboot. But the file had completely reverted to the original state! I even checked many other local folders including Downloads, Documents, Desktop. I checked the Recent Files panel within the Excel file but all versions were also in original state. I looked for the Auto-recovery panel but none was available.

I'm panicking as I'm really in a bind and time crunch. I considered consulting our IT team but they are usually so slow and would most likely be too late, if they can even recover the updated file. Is it possible to recover the updated file in general now? What was the issue in this series of events, and what would have been the best solution? Any other advice or insight to help me out? Thank you all!

top 4 comments
sorted by: hot top controversial new old
[-] BCsven@lemmy.ca 11 points 8 months ago

It is possible it is opening a cached copy that has the same time and date, even if content is different.

Or the file actually did save like that and MS excel dropped your changes. It has happened to me before.

You or IT should be able to see versions if your company runs that option, to let you load as version X.

IT is going to be your best bet on figuring out if you have a good copy somewhere or if it went into the void

[-] jarfil@beehaw.org 4 points 8 months ago

We don't know the exact setup of your AD, or what tools your IT might be running.

As a general rule of thumb however, whenever you see an app "glitching", immediately stop whatever you're doing, "save as" with a different name, close, and reboot.

It might've been a connectivity problem, or it might've been RAM corruption, either case you don't want to put in work in that state.

[-] Donut@leminal.space 3 points 8 months ago

Have you checked the status of the file on Sharepoint, provided office files are automatically synced via OneDrive?

[-] some_guy@lemmy.sdf.org 1 points 8 months ago

What other people said. Maybe try opening recent files from the File menu. Hope you get it back.

this post was submitted on 14 Apr 2024
20 points (100.0% liked)

Technology

37801 readers
320 users here now

A nice place to discuss rumors, happenings, innovations, and challenges in the technology sphere. We also welcome discussions on the intersections of technology and society. If it’s technological news or discussion of technology, it probably belongs here.

Remember the overriding ethos on Beehaw: Be(e) Nice. Each user you encounter here is a person, and should be treated with kindness (even if they’re wrong, or use a Linux distro you don’t like). Personal attacks will not be tolerated.

Subcommunities on Beehaw:


This community's icon was made by Aaron Schneider, under the CC-BY-NC-SA 4.0 license.

founded 2 years ago
MODERATORS