We have SharePoint 2013 installed, and we edit files by using Office 2010. This worked fine until this week.
It might be caused by an update for Office 2010 (KB3101540)
When I try to open an Excel file from SharePoint 2013, I get the message: "An unexpected error has occurred", without Excel even showing up.
If I save the Excel file to my disk, than I can open them without any problems. But obviously there's no connection to SharePoint then.
I've also tried the same with Excel 365 (the latest), which can connect without any problems.
I did a clean installation of Office 2010, without any SP and other updates. It worked then. But when I installed the updates (via Windows Updates) it stopped working
Some details:
Microsoft Excel 2010 14.0.7015.1000 SP2 (64-bit)
I uninstalled the latest update (KB3101540) but this didn't solve anything.
OS: Windows 8.1, colleague tried has Windows 7, same problem
UPDATE
Apparently uninstalling Office 2010 Service Pack 2 , DOES fix this issue. But i don't think this is a valid solution since I would need to insure that all 200+ employees uninstall this Service Pack. And the service pack is there for a reason...