Skip to Content
0
Former Member
Jul 22, 2016 at 06:33 PM

AO - Issue with large workbook - Workbook redisplay taking a long time

383 Views

Hi,

I have a workbook with one analysis connection (RFC) inserted into a tab of the report. The query / connection runs fine outside of the workbook - it returns in a number of seconds. However when embedded into an excel sheet with various formulas in excel the performance is very poor. The workbook is 9gb so it is very large - but there are no performance issues until i try to refresh the connection. I have done some analysis using the profiling statistics and the issue seems to be with the workbook redisplay - it is taking almost 15 mins to format the display in Excel. Has anyone else had this issue previously - i have searched and haven't found a solution.

I'm on analysis version 2.2 SP02 32 bit - with Office 2010 14.0

I have attached the statistics

Any ideas?

Thanks

Brian

Attachments