Save and Refresh workbook data as default?

[Former Member]

Hi,

we have a question.

Would it be possible to set "Save and Refresh workbook data" as default instead of "save and refresh worksheet data"?

Does anyone have a solution?

Thanks,

Dominic

[former_member186338 · Accepted solution]

Hi Dominic,

Unfortunately no! You can create you own button using VBA...

Vadim

[Former Member · Accepted solution]

Hi Vadim,

What a pity.

maybe next SP?

Dominic

[former_member186338 · Accepted solution]

Very low probability - you need to implement a lot of settings for each ribbon button with multiple options...

Vadim

[Former Member]

Hi Dominic,

with a click of the right mouse button onto the option you want, you can add it to the icons at the top of Excel (Symbolleiste für den Schnellzugriff - no idea what it is called in English) and use that instead of the standard button in the ribbon.

BR,

Arnold

[former_member186338]

Hi Arnold,

This can be done using VBA to somehow automate it for number of users...

Vadim

P.S. Also, the help topic: "Ribbon Extensions: Simple Method" may be useful (not tested)