I have a strange excel behavior I have only seen after switching to Excel 2013 - AKA worst excel "upgrade" ever, but I digress.
I download and work with several data extraction tools such as cognos and others and I notice when opening some files "Freeze Panes" is grayed out. No amount of saving as, switching view to normal or other tricks work. The only thing that does work is closing excel and restarting which is not an ideal method. Any thoughts?
Also on a side note how do i get rid of the awful save as views with a myriad of non-useful folder selection methods.
I download and work with several data extraction tools such as cognos and others and I notice when opening some files "Freeze Panes" is grayed out. No amount of saving as, switching view to normal or other tricks work. The only thing that does work is closing excel and restarting which is not an ideal method. Any thoughts?
Also on a side note how do i get rid of the awful save as views with a myriad of non-useful folder selection methods.