Hi everyone,
Can anyone suggest me a way to change the excel files' mode from 'compatibility mode' to normal mode for multiple files at once. I know how to change it using the 'save as' option or clicking at file tab and click 'convert'. But i want to do it for many files at once as its very time consuming to open each file and change it. I have few files which i download from outlook and i want to run a macro on them simultaneously. But since they are in 'compatibility mode', i'm unable to run it.
Thanks in advance
Can anyone suggest me a way to change the excel files' mode from 'compatibility mode' to normal mode for multiple files at once. I know how to change it using the 'save as' option or clicking at file tab and click 'convert'. But i want to do it for many files at once as its very time consuming to open each file and change it. I have few files which i download from outlook and i want to run a macro on them simultaneously. But since they are in 'compatibility mode', i'm unable to run it.
Thanks in advance