Troubleshooting Excel 2010 UI Automation

If you are using Excel 2010 and Power Query datasources Power Update needs to perform UI automation. If UI automation fails for some reason please try the common resolutions below: Check if you can manually refresh the workbook and make sure all connections are working. If it’s a temporary / intermittent issue during refreshing connections,[…]