I have a few users that have MS Excel freezing up when they open a spreadsheet that connects to a data source. Not just one spreadsheet, but any that connect to a data source.
In MS Office 2007 with those connections all in "Allow" mode in Trust Center, it freezes up upon opening. In MS Office XP you can actually see what is causing the freeze.
They open the excel sheet and click Enable Macros when that window opens, and then the Update window opens for the links to other data sources. If they click Update Excel freezes if they click Don't Update the file opens fine, but they are not getting all of the data they need.
Only Excel freezes up. They can switch between other applications just fine. We end up having to close Excel through task manager.
A little background:
We have uninstalled and reinstalled a few different versions of MS Office with no luck. We have updated to all the latest Windows updates with no luck.
Here is the strangest part : This only happens for these users on some days. Sometimes they can open it no problem, but within a few days the problem has returned. These are desktop PC's that do not leave the office ,and it does not matter if the file is on their C: drive or a network drive.