We recently upgraded our Business Objects.
I am now using BO Webi 4.2 SP 4 patch 4 and MS Office 365 ProPlus, Excel 2016.
Every time I export a BO report to Excel it freezes up. I cannot do anything to it. I can save it, and then re-open it and everything is fine then.
No other users in my company have this issue. This is very frustrating.
I did not have this problem in BO 4.1.
I would welcome any suggestions for trouble-shooting.
JoeyB99 (BOB member since 2015-06-17)
Is this a problem on the Excel side? When I run to Excel it sees the file as coming from an internet source and won’t let you edit it until you explicitly tell it to let you do so. When I forget this it feels like Excel is locked up.
Bill K (BOB member since 2011-02-24)
I suspect that your problem is that the file size is large. Your servers may be configured differently, which is why you would experience the issue in one environment but not the other.
see this document
when saving from webi to csv or excel the memory needed to do it is governed in a server setting in cmc. I would check both environments and see if there’s a difference and adjust accordingly.
note that the server mentioned in the link is now called WebIntelligenceProcessingServer.
erik.stenson 
(BOB member since 2012-07-30)
Thank you erik, and Bill.
I did some digging on the internet and found my solution. The size of the exported report does not matter here.
Every time I export Excel it opens up with a ‘standard’ warning message and an Enable Content button. when I click on this button the freeze-up happens!
I go into Excel options, for Trust Center. Then open ‘Trust Center Settings…’. Then I click on Protect View, and disable all three options.
This works! I am no longer experiencing freeze ups when I export to Excel.
I do not like this, and did not have to do this in Webi 4.1
In my humble opinion it is a bug with Webi 4.2, support pack 4, patch 4.
BTW, this occurs in the Rich client version as well.
JoeyB99 (BOB member since 2015-06-17)