Time taken to generate Picklist in Excel between 9.5 & 9.5.1
Posted: Thu Aug 05, 2010 7:50 am
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.
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.