OPS Conosle CubeCellPickListGet Problem

[TM1NB]

Hi togehter,

I have a strange issue on one of my perspective reports in Excel. In some situations (scrolling / clicking in a Cell) TM1 is starting to calculate something even though the automatic Excel calculations are switched off.
The OPS Console shows in this moments "CubeCellPickListGet" and I don't understand why. In the Cube / the Dimensions are neither Picklists nor are some Data validations or picklist-sheets in the Excel map.
The Cube had a Dimension with some picklists in, but they were deleted long ago. I have no idea why TM1 has to do the "CubeCellPickListGet" in some situaions. There is no System Cube showing something with }...picklist... only a dimension called "}Picklist" with an element "Value".
Can there still be some remains in TM1 of the old Picklists which causes this "CubeCellPickListGet" loading times?

Thank you very much,
TM1NB

[tomok]

Hi togehter,

I have a strange issue on one of my perspective reports in Excel. In some situations (scrolling / clicking in a Cell) TM1 is starting to calculate something even though the automatic Excel calculations are switched off.
The OPS Console shows in this moments "CubeCellPickListGet" and I don't understand why. In the Cube / the Dimensions are neither Picklists nor are some Data validations or picklist-sheets in the Excel map.
The Cube had a Dimension with some picklists in, but they were deleted long ago. I have no idea why TM1 has to do the "CubeCellPickListGet" in some situaions. There is no System Cube showing something with }...picklist... only a dimension called "}Picklist" with an element "Value".
Can there still be some remains in TM1 of the old Picklists which causes this "CubeCellPickListGet" loading times?

Thank you very much,
TM1NB

Open the Excel file and check for hidden tabs that start with "Picklist***" in the name. You should delete these.

[TM1NB]

Hi,

happy new year and sorry for the late reply.

Open the Excel file and check for hidden tabs that start with "Picklist***" in the name. You should delete these.

There are no hidden Tabs.

Any other suggentions?