Task List refreshing too fast
It might happen when working with many tasks that you cannot select some of those that are on the bottom because the list refreshes too often.
To solve this problem:
1. Navigate to the program's installation folder.
2. Open up the PQRefreshManager.exe.config file (if you can't find this file install the latest Power Update version). Make sure you have the permissions to read and write the file so after editing you can save the new data (or copy the file to your desktop, make the changes, and copy it back).
3. In the file, find this section:
<setting name="TaskListRefreshPeriod" serializeAs="String">
by default the value is 5000, which is 5 seconds. To increase the time between each automated refresh, increase this value.
4. Save the file.
Tasks not appearing
If your a tasks are not visible, and adding new ones don't appear, the issue is usually due to one of the xml files becoming corrupted under C:\Windows\System32\Tasks\Power Update. Try removing them (or moving them to a different folder) one by one ...
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 ...
Power Update Maintenance
Power Update is sold by a one-time fee that gives users a perpetual license to use the software forever. PowerON offers an optional maintenance contract in order to receive updates for the software. Purpose of the document In this article, you will ...
Microsoft.Mashup.OleDb.1 provider is not registered issue
A recent Office update seems to be causing issues for some users, with refreshing connections that use the default Power Query connector in Excel using Power Update. Users who experience this issue usually can find the following message in the Power ...
Power SQL Update not loading in Excel
Search the registry under both Current user and Local Machine for: PPSQLConnector and set the LoadBehaviour to 3 at all occurances e.g.: If the above doesn't resolve the issue, search for Addins in the registry under both Current user and Local ...