PAx with multiple workbooks open

Post Reply
Posts: 13
Joined: Thu Oct 11, 2018 10:11 pm
OLAP Product: IBM Planning Analytics
Version: 2.0
Excel Version: 2013 32 bit

PAx with multiple workbooks open

Post by grusty » Wed Apr 10, 2019 4:47 pm

Hi Everyone,

We've been noticing some strange behavior after downgrading to PAx.
- User switches to another workbook, the PAx addin seems to loop through all sheets in the workbook and land on a different sheet than what was selected. The workbook "has a seizure".
- An Excel macro that copies and pastes values to a new workbook crashes as the paste values function becomes unavailable after the copy. Works fine when the PAx addin is disabled. Macros don't seem to play nice with PAx.

Is anyone aware of any parameters to disable these behaviours? Nothing seems to come up in my searches (or I'm bad at googling).


Post Reply