Time taken to generate Picklist in Excel between 9.5 & 9.5.1

Post Reply
harrytm1
Regular Participant
Posts: 226
Joined: Thu Apr 02, 2009 2:51 pm
OLAP Product: IBM Planning Analytics
Version: Latest version
Excel Version: 2003 to 2019

Time taken to generate Picklist in Excel between 9.5 & 9.5.1

Post by harrytm1 »

Hi all,

With the introduction of picklist in 9.5 onwards, Excel will now dynamically create a validation list if a user clicks on a cell that has a defined picklist in TM1. I have a picklist that will return around 900 elements for user to select in the Excel validation list.

When I was using picklist in Excel in version 9.5, the list was returned relatively fast e.g. around 3 seconds.

however, after I have "upgraded" to 9.5.1, it seems to take longer e.g. around 7 seconds.

Is it only me or have others notice the same thing too? I have since switched back to 9.5 given the serious bug on Drill-Through which I had posted earlier http://forums.olapforums.com/viewtopic.php?f=3&t=3178.
Planning Analytics latest version, including Cloud
Post Reply