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

[Former Member]

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

[reyemsaibot · Accepted solution]

Hi Brian,

are you sure, that your workbook is 9GB large? Maybe one of these notes help you:

• 2039134
• 2076788
• 1899658

BR,

Tobias

[Former Member · Accepted solution]

Hi Tobias,

Thanks for the response - apologies the file is 9mb large not gb - my mistake.

I am aware of the issue of files being corrupted by styles and i have the macro to remove the styles - but in this case it isn't an issue.

Any other ideas?

Thanks

[reyemsaibot · Accepted solution]

Hi,

have you got any VBA code in your workbook? Or do you use many VLOOKUPS? Maybe the Excel internal calculation need this time to calculate all your formulas. Do you have calculation on automaticly or manually?