Smart view reports in hidden worksheets
SummarySmart view reports in hidden worksheets
I am using smart view 710, excel 2016 and essbase version 126.96.36.199.508.
I need to consolidate several smart view reports in separate worksheets in one file to create a big report but the user does not want to smart view reports to be "visible" to the receiving party of the report. too many worksheets in a file will create unnecessary confusion and perusal. It has to be separate worksheets because each is using different essbase cubes.
But if I hide those worksheets, "refresh all" will not work on these worksheets.
Is there a way to hide those smart view worksheets but "refresh all" will still work?