EPM-Add In: Change default refresh behaviour in excel-ribbon

[dob1]

Hello everybody!

I have a question relating the EPM-Add In.

The EPM-block within the excel-ribbon line has the (let's say) "big refresh icon" . With the suboptions ... "Refresh Worksheet", "Refresh Workbook", "Refresh Selected Data".

When I click the refresh button (without selecting an option in the dropdown list), the worksheet is refreshed. Is it possible to change this default behaviour from "refresh worksheet" to "refresh workbook"?

Thanks for your help.

Best regards,

Dominic

[Shrikant_Jadhav]

Hi Dominic,

As far as I know, you can not change this default behavior.

You can write simple VBA code to refresh workbook.

Shrikant