Make Excel stop babysitting me.
December 5, 2011 9:11 PM Subscribe
Excel is treating me like a child because it thinks I can't tell the difference between .csv and .xlsx. It's wasting my time. Help?
posted by ootandaboot to computers & internet (9 answers total) 1 user marked this as a favorite
Whenever I save an Excel (2011 for Mac, Leopard) spreadsheet in a format other than .xlsx, such as .csv or .txt, it gives me the following warning:
"This workbook contains features that will not work or may be removed if you save it in the selected file format. Do you want to continue?... plus more fine print"
This happens every time I reflexively hit command-s as I work, and it happens when I close the file even if I've *just* saved it. Worse, the response button that's highlighted is "Cancel" so I can't just hit return to get through the warning -- I have to pick my mouse up to deal with it.
This has been irritating me for a while, but I don't use Excel that often so I was never driven to try to fix it. Right now I'm using it a lot more and I'm up against a big deadline, and this is getting in the way of being able to work efficiently. How do I convince Excel that I'm already very well aware of the nature of .csv and .txt files (that's why I'm saving files in those formats!), I'm keeping track of which files are in which format, and I do not need or want to be warned every single time? Please help me!