Remove spurious CSV warning
Opening, via drag-and-drop or File > Open (but not File > Import) a just-downloaded CSV file produces the following warning in Excel (on a yellow background):
"Possible Data Loss: Some features might be lost if you save this workbook in the comma-delimited (.csv) format. To preserve these features, save it in an Excel file format."
I then have to click the 'x' to get rid of this warning...and that's really annoying, especially because it doesn't apply. I have just downloaded the CSV file from the net. It's a CSV file, unedited, and as such, it can't possibly contain any features that will be lost if I save it again as a CSV file.
This warning should only appear after editing the opened file, not before. It's annoying to see this every time I open these files, which I do a lot. It's even more annoying to have to move my mouse to dismiss it.
Alon, your approach saved a lot of frustrations!
Thank you Alon!!!!! This has been bugging me forever!
Willie D commented
Alon: Thank you so much for posting the solution. I work with CSV files a lot, and the useless warning was pretty annoying.
Rob Griffiths commented
Alon: Well, that's new! Not sure when it appeared, but thanks for pointing it out!
Just solved: https://cl.ly/9c98297af42d
Have same issue