Analysis for Office not refreshing reports on hidden sheets

[Former Member]

Hi,

I have created a number of Analysis workbooks connecting to various DataSources in BI/BW.

For the most part this is all working very well.

The only issue I have is that if there is a DataSource inserted on a hidden sheet, this does not refresh when running the prompts.

do I really need to have all sheets unhidden in order for the data source within to refresh upon running the prompts?

Thanks.

<<Using SAP BusinessObjects Analysis for Microsoft Office Version 1.4.10.3295 and Excel 2013>>

[TammyPowlas]

Hi Ian - I moved this to the Analysis Office space

I don't see any relevant notes that would apply - is it possible to apply SP11 and retry this scenario?

[Former Member]

Hi Ian,

I did a quick test using version 1.4 SP 7 no issues using either a hidden workbook or a very hidden workbook.