Troubleshooting Excel PowerPivot Update

If you are using Excel 2010 and Power Query and have an issue during UI Automation, or if the task succeeds but the data doesn’t update please refer to the related article Otherwise please check the error messages in the C:\Users\[USER]\AppData\Local\Temp\PU.log file and turn on Options\Diagnostic Mode to see if Excel displays any popup messages[…]

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,[…]