Excel Add-In error: Refresh failed due to unexpected error.
Found out that when the Excel template is created with Regional settings [ ex. decimal symbol as Dot / . ] is different from your system settings [ ex. Decimal symbol Comma / , ] then the refresh fails and shows up unexpected error.
This is solved as soon as the Changes are made in Control Panel > Change Date Time Settings > Additional Settings.