I am automating a process that send 5 tabs from an Access db macro to an excel template file (.xlsm). These 5 tabs feed 8 pivot tables in the template. 5 minutes later, my vba script opens the excel template and try to run a macro in the .xlsm template to set up the final report.
My problem is that when the template opens I am getting the message "Cannot edit a pivot table in group edit mode" so when my vba script calls the excel macro nothing happens until I click "OK" to the warning message.
Any ideas of how to get around this message will be greatly appreciatte,
Cheers!