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.
Time taken to generate Picklist in Excel between 9.5 & 9.5.1
-
- 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
Planning Analytics latest version, including Cloud