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