I am trying to automate a excel report with a pivot table. The excel has macros in it. However, the export wizard doesn’t recognise the macro even when I select the output option as the excel file with the macro. The excel file has been save with .xlsm and I have turned on the trust center settings for the macros to run.
What am I missing here?
Any help would be awesome!