CSV Possible Data Loss warning Popup
So I just lost a days work because I opened a csv file, did a bunch of editing and new tabs, saved and closed, and it's still a csv. I completely understand why the csv file doesn't have my work, and I've already checked for temp files, so I think I'm just out of luck there.
However, I swear that excel used to give an actual in-your-face popup when you hit save reminding you that you have a csv open. I'm not referring to the annoying and mostly useless little yellow bar up top, which seems to be what the show data loss warning checkbox under file>options>save. That seems to happily let you save your file as csv with no change to your screen. I mean something that took over the screen and explicitly forced you to acknowledge you are saving as csv and could lose data.
Is there any way to get that behavior back?
Edit: I found a very old video that shows what I mean. that is the one I mentioned that as far as I can tell, only gives the annoying yellow static header. At this timestamp, he saves as a csv and then gets a popup forcing him to acknowledge that it could cause data loss. The video this is a "save as", but I remember this same popup appearing if you just did a "save" while having a csv open. youtube
Microsoft 365 MSO (Version 2601 Build 16
[link] [comments]
Want to read more?
Check out the full article on the original site