TM1 Forum

Where can I set the automatic refresh in a PAX exploration view? It automatically refreshes when I change the order of the dimesions for me, but for other user it does not, couldn't find where is this option. Any help appreciated, thanks.

As a start, are both of you in Automatic calculation mode in Excel? PAfE works better like this whereas Perspectives was better suited to Manual.

What version of PAfE are you both using?

As George has suggested the version being used could be useful.
To the best of my knowledge the behavior of "changing dimension order" should be the same whether in manual or automatic calculation mode for Excel.

There is an option called "Design Mode" under the "Data" subsection within the PAX ribbon; this is an on/off toggle.
The default is "off" which would mean swapping and changing dimensions around within an exploration does not cause a refresh but it instead will remove any data previously shown until you hit refresh manually. This is really useful if you are doing a lot of changes to a bigger view and don't want it to refresh at every step along the way.
It's the only thing I can think of from the top of my head that disables automatic recalculation (when swapping dimensions around) in the more recent versions of PAX; but it does show "<Default>" as text for the Columns and Rows plus a single cell with "<#1234#>" for the data prior to clicking refresh. So I would have expected that your other user would have mentioned that happening if it was the case.