![Troubleshooting Excel PowerPivot Replace – insightsoftware Troubleshooting Excel PowerPivot Replace – insightsoftware](https://bizagility.org/wp-content/uploads/2023/03/23-03-WBN-S4HANA-UndoImplementationMistakes-Share-FB-LI.png)
[ad_1]
If you’re utilizing Excel 2010 and Energy Question and have a difficulty throughout UI Automation, or if the duty succeeds however the knowledge doesn’t replace please confer with the associated article
In any other case please test the error messages within the C:Customers[USER]AppDataLocalTempPU.log file and activate OptionsDiagnostic Mode to see if Excel shows any popup messages in the course of the replace course of and test for the signs under:
Opening file failed
That is often both as a result of file being locked or the file taking too lengthy to open (massive mannequin or gradual pc).
Resolutions
Strive checking OptionsDisable Parallel Duties to ensure one other process just isn’t locking the file
If the file takes lengthy to open due to a big mannequin, attempt growing the WaitAfterOpen, WaitBeforeRefresh, WaitBeforeProcess2010 (ms) settings in C:Program FilesPowerPlannerPower UpdatePQRefresh.exe.config (copy the file to desktop, change setting in notepad, save, and duplicate it again), to 30000-200000 relying on how lengthy the workbook takes to open.
Refreshing connection failed
That is often as a result of a difficulty with one of many connections (e.g. community error, question or knowledge error, previous password, password not equipped, and so forth).
Resolutions
Examine when you can manually refresh the workbook and ensure all connections are working.
If utilizing Excel 2010 test that the Energy SQL Excel Addin is put in and enabled (each in Excel and Energy Replace Choices)
If it’s a brief / intermittent difficulty throughout refreshing connections, set the Retry Rely and Retry wait settings within the Superior Settings web page of the duty wizard (e.g. Retry Rely: 5, Retry Wait: 5 min). If the Refresh hangs typically, additionally arrange the next settings in Superior PropertiesSettings:
- Cease the duty if runs longer than X minutes (primarily based on the traditional run time)
- If the duty fails restart each X minutes (if the refresh difficulty is attributable to a community downside go away a couple of minutes for it to recuperate)
If Excel prompts for a password throughout refresh attempt:
– Use OptionsData supply passwords. The DS Identify ought to match the title of the connection (case delicate) in PowerPivot
– Save the password within the workbook:
- Go to ExcelDataConnectionsYOUR CONNECTIONPropertiesDefinitionSave password
- Do a Refresh All in Excel (enter the password when prompted)
- Save the workbook
– Use Energy Question to import knowledge, which shops the password on the pc not the workbook
Excel couldn’t be began
That is often resulting from an Excel set up difficulty (e.g. one other model of Excel was just lately put in uninstalled, or present set up is damaged)
Resolutions
Strive the next registry repair:
- Open the regedit editor.
- Open HKEY_CLASSES_ROOT >> TypeLib >> {00020813-0000-0000-C000-000000000046} (The Excel PIA key’s {00020813-0000-0000-C000-000000000046})
- Delete the model folders that don’t confer with the present model of Excel (Excel 2010 is 1.7, Excel 2013 is 1.8, Excel 2013 is 1.9)
- Set the right Model in HKEY_CLASSES_ROOTInterface{00020843-0000-0000-C000-000000000046}TypeLib (Excel 2010 is 1.7, Excel 2013 is 1.8, Excel 2013 is 1.9)
- Attempt to restore/reinstall Excel
- Strive on a distinct pc
RPC_E_DISCONNECTED or RPC_E_CALL_REJECTED
That is often occurs when Excel is busy and never responding resulting from a engaged on massive mannequin or a number of refreshes operating on the identical time
Resolutions
- Strive putting in .NET 4.6.2
- Strive checking OptionsDisable Parallel Duties
- Strive checking OptionsDiagnostic mode to see if there are any popup messages displayed by Excel
- If you’re utilizing Excel 2013 or 2016 attempt setting the RefreshEachConnection setting to False in C:Program FilesPowerPlannerPower UpdatePQRefresh.exe.config (copy the file to desktop, change setting in notepad, save, and duplicate it again). This does a Refresh All as a substitute of Refreshing connections individually (which might be sooner too)
- If the mannequin is massive, attempt growing the WaitAfterOpen, WaitBeforeRefresh, WaitBeforeProcess2010, WaitBeforeSave, WaitAfterRefresh, WaitBeforeClose (ms) settings in C:Program FilesPowerPlannerPower UpdatePQRefresh.exe.config (copy the file to desktop, change setting in notepad, save, and duplicate it again), to 10000-200000 respectively relying on how lengthy the workbook takes to open, save, shut.
- Strive altering IgnorePopups setting in PQRefresh.exe.config (or a mixture of that and the IgnorePopupsWithEmptyTitle setting)
Different points
If the above doesn’t resolve the difficulty, contact us and ship us the:
– C:Customers[USER]AppDataLocalTempPU.log, PU_UI.log information
– C:Customers[USER]AppDataLocalPower UpdateSettings.xml file
– Energy Replace model in Management PanelProgramsPower UpdateVersion
– Excel model
[ad_2]