Export Wizard doesn't recognise the macro

Hi there,
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!


Can you post the file? Or send directly to me? dpeabody@quest.com