2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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

submitted by /u/ready4traction
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#Excel compatibility
#rows.com
#natural language processing for spreadsheets
#financial modeling with spreadsheets
#CSV
#data loss
#Excel
#popup
#save
#file
#Microsoft 365
#temp files
#save as
#editing