IBM Support

Unable to get task pane to render in Planning Analytics for Excel - Error "Specified restriction conflicts with the current dock position"

Troubleshooting


Problem

When a user launches Excel and signs into Planning Analytics (PA) for Excel, they are unable to get the task pane to display. 

Symptom

Error thrown by PA for Excel:
"Specified restriction conflicts with the current dock position"

 

Cause

Exact cause is unknown.

 

Diagnosing The Problem

  1. Launch Excel
  2. Sign into PA for Excel
  3. Click "Task Pane" to display the task pane.

 

Error will be thrown.

 

Resolving The Problem

Reset the user's Cognos Office settings. To do this:

  1. Close Excel and make sure there are no Excel.exe processes running in Task Manager
  2. Navigate to C:\Users\<username>\AppData\Local\Cognos
  3. Delete the folder "Office Connection"
  4. Relaunch Excel / PA for Excel. This will recreate the "Office Connection" folder and files.

 

Retest with PA for Excel to confirm the issue is resolved.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSD29G","label":"IBM Planning Analytics"},"Component":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
28 August 2018

UID

ibm10729551

Page Feedback