Skip to Content

Refresh of only some analysis office workbooks necessary when adding default values

Feb 01 at 01:25 PM


avatar image
Former Member


we are currently facing the problem, that we added in a frequently used query some restictions in the section "Default Values". And in some workbooks this is reflected immediatly when refreshing and in some workbooks not.

Is there any known criteria, when it is (not) necessary to reset the data source in the workbook, or how it can be archived, that we don't habe to reset all those workbooks?

Thanks in advance,



10 |10000 characters needed characters left characters exceeded

Hi Ingrid - would you please share version and SP of Analysis Office you are using?

* Please Login or Register to Answer, Follow or Comment.

1 Answer

Enis Zornic Feb 02 at 07:47 AM

Not 100% sure if I understand your question but I believe your solution will be on Design Panel > Components tab. If you check the box "Merge Variables" all data sources will be refreshed if you change the variables for one. If it is unchecked it will refresh only one data source.

10 |10000 characters needed characters left characters exceeded