Office365 vs Office2010

I have been experiencing issues with the combination of Bloomberg and Excel (Office 2016) since upgrading from an earlier version of Office a number of months ago.

Had both Bloomberg tech support as well as our own IT people look at this, but so far have been unable to resolve my issues. (Problems seem to be related to the Bloomberg .Com add-in, but are difficult to replicate as they seem more random than described by OP)
Already did a fresh Bloomberg and Office installation, and my registry was cleaned to remove every reference to older Office versions. I'm now trying to schedule for a complete fresh Windows install...

Note, I am running the latest versions of Office 2016 Home & Business as well as Bloomberg.
 
Bloomberg might be the problem. That would explain why google isn't giving me a thousand pages of people with the same problem as I am describing. I will try the safe mode and see if that clears it up.
 
newwurldmn said:
I had to upgrade from office 2010 to office365 because of licensing issues. I run my entire trading operation on excel and Bloomberg addins. However, since the installation my excel spreadsheets have slowed down. Typically I have about 10 different spreadsheets open (some calculating risk, some run as screeners, some for pnl analysis). Nothing is computationally intense and everything ran smoothly on Office2010.

With Office365, once a spreadsheet is "active" it works fine. The problem is that when I maximize a spreadsheet, I can wait up to 2 minutes while my computer freezes. Once the computer unfreezes, it works fine until I maximize the next spreadsheet. If I wait 24 hours to reuse the spreadsheet (say for a screener), the 2 minute freeze happens again. It's almost as if the spreadsheet is being loaded into memory from a cache and then after some time of no use, the spreadsheet is taken out of that cache and put somewhere else until I request it again. Has anyone else seen this behavior?

And for what it's worth, I'm running Win7, Dell Precision T5810 with Xeon E5-1620 3.5Ghz with 16GB ram. I run each spreadsheet in its own instance of excel using the "/x" option. Looking at the Performance Information and Tools everything is at 6.0+ except Graphics which is at a 4.8.

I have a similar issue with Outlook365 too. I don't know if it's related.
More...

Try opening independant sheets in separate instances.
 
it looks like safemode works better. I called Bloomberg tech support and it looks like it was an addin issue. The add-in needed to be repaired and one setting needed to be changed to 5. So far it's running really smooth. Will see how it goes.

Thank you everyone.
 
You must log in or register to reply here.
Back
Top