Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Run Macro on Refresh Not Saving


I recently generated a macro in a module for a BEx workbook that has a query setup to "Refresh Workbook on Open".  Ideally I want this macro to execute on each Refresh.  After searching google I came across this linked article.

I then went into Workbook Settings opened the "Exits" tab and clicked on "Run Macro on Refresh".  I input the name of my subroutine from the recently added module.  On my macro I added "ParamArray varname()" as a parameter (ie: Sub CopyFormulas (ParamArray varname())    ).

When I test it and repull in data through "Change Variable Values" it seems to work.  My sub is called and appears to be working.  I then use the BEx save workbook option, but when I close and re-open my workbook the "Run Macro on Refresh" toggle is off and my macro name not listed.

Any help to resolve this issue would be greatly appreciate.


Not what you were looking for? View more on this topic or Ask a question