Analysis workbooks are slow to open

[Former Member]

Hi ,

Can you please help me with the below information.

We are using BOBJ Analysis version 1.4 . Users are creating workbooks connected to several to data sources (Bex) and these workbooks are saved and reused. But they are reporting issues saying workbooks are taking long time to open ,load and refresh. so when we checked the scn sap , we found out that style sheets are the reason for poor performance.

Can you please let me know why style sheets are copied in workbooks because we dont have any and is there any way we can avoid style sheets.

If I download the macro to remove style sheets does it have any other impact on workbooks.

Thanks,

Bharathi.

[Former Member · Accepted solution]

Hi Bharathi,

My understanding is that this is an Office Issue. What we found was that our users had to migrate workbooks so they would copy a sheet from another workbook to the new workbook which will result in the styles that exist in the original workbook being copied into your new workbook.

We have used the style remover on a few hundred workbooks with no impact that we have picked up yet.

Hope that helps you.

[Former Member · Accepted solution]

Hi Michael ,

For Testing Purpose :

I logged into analysis , connected to BW and executed Bex queries . So by default each workbook has 83 styles.

I tested it for multiple queries and it has 83 styles. Even if I add extra rows and columns it did not change. so by default each workbook created from Bex query has 83 rows.

But the workbooks created by users has multiple sheets , copied from somewhere else and it has link to other sheets. this workbook has around 24,000 styles. when I removed it using the macro it came back to 160 and performance is normal.

so Can you please help make me understand , how the styles are created in workbooks. Is it because of excel or analysis office. I am thinking its not analysis , its the issue with workbooks.

Thanks,

bharathi.

[maagp · Accepted solution]

Hi Bharathi,

In fact it is Excel itself which is copying / duplicating the styles and this usually happens when copying information or complete worksheets between workbooks. Then Excel will often also copy the styles from the source.

There's also a Microsoft KB article (which is also linked in SAP Note 1899658) related to this problem which contains some suggestions how to solve this:

https://support.microsoft.com/en-us/kb/213904

Best regards,
Patrik

[Former Member · Accepted solution]

Hi Patrik ,

Helpful information . When I tried to open the SAP Note 1899658. It did not work for me.

I would like to see the information provided in the note. Can you please share the link which works.

Thanks,

bharathi.

[maagp · Accepted solution]

Hi Bharathi,

The link works fine from my side and as far as I know it also should be working when accessing it outside from SAP. Maybe you can access at least the related SAP KBA article 2076788 (http://service.sap.com/sap/support/notes/2076788)? This KBA article is also referencing note 1899658.

Best regards,

Patrik