Home Business Intelligence Troubleshooting Excel PowerPivot Replace – insightsoftware

Troubleshooting Excel PowerPivot Replace – insightsoftware

0
Troubleshooting Excel PowerPivot Replace – insightsoftware

[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 information doesn’t replace please seek advice from 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 throughout the replace course of and test for the signs under:

Opening file failed

That is normally both because of the file being locked or the file taking too lengthy to open (giant mannequin or gradual laptop).

Resolutions

Strive checking OptionsDisable Parallel Duties to ensure one other job isn’t locking the file

If the file takes lengthy to open due to a big mannequin, attempt rising 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 normally because of the a difficulty with one of many connections (e.g. community error, question or information error, previous password, password not equipped, and many others).

Resolutions

Test in case 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 short lived / intermittent challenge 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 generally, additionally arrange the next settings in Superior PropertiesSettings:

  • Cease the duty if runs longer than X minutes (based mostly on the conventional run time)
  • If the duty fails restart each X minutes (if the refresh challenge is brought on by a community drawback depart a couple of minutes for it to get better)

If Excel prompts for a password throughout refresh attempt:

– Use OptionsData supply passwords. The DS Identify ought to match the identify 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 information, which shops the password on the pc not the workbook

Excel couldn’t be began

That is normally attributable to an Excel set up challenge (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:

  1. Open the regedit editor.
  2. Open HKEY_CLASSES_ROOT >> TypeLib >> {00020813-0000-0000-C000-000000000046} (The Excel PIA key’s {00020813-0000-0000-C000-000000000046})
  3. Delete the model folders that don’t seek advice from the present model of Excel (Excel 2010 is 1.7, Excel 2013 is 1.8, Excel 2013 is 1.9)
  4. Set the correct 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)

154102 Thumb

  • Attempt to restore/reinstall Excel
  • Strive on a unique laptop

RPC_E_DISCONNECTED or RPC_E_CALL_REJECTED

That is normally occurs when Excel is busy and never responding attributable to a engaged on giant mannequin or a number of refreshes working on the similar 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 an alternative of Refreshing connections individually (which might be sooner too)
  • If the mannequin is giant, attempt rising 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 mix 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]

LEAVE A REPLY

Please enter your comment!
Please enter your name here