Changes on Workbook not work

[Former Member]

Dear all,

There is a issue when I modify the workbook, new Macros added. I saved the workbook successfully. However, when execute this workbook, the change on this workbook is not working, just the reult of before change

[former_member186358 · Accepted solution]

Hi Gerald,

You may wish to refer the link.

Regards,

Anil

[Former Member · Accepted solution]

Hi.

If you want the macro to be executed everytime the workbook is refreshed, then on the Exits tab of the Workbook settings write the name of the macro in the field provided below the option "Invoke macro on refresh".

[Former Member · Accepted solution]

Thank you,

The root cause is that I don't set the role which the Workbook saved to my profile.

Hope you got the score I commit.