Excel 2007 SP2 crashes when attempting to select multiple values in a pivot with lot of values
I have a problem with both Excel 2003 and Excel 2007.
We work with a pivot table sourced from a Analysis Services cube.
When I put the dimension attribute in the row area and try to select multiple values I get a bug.
In Excel 2007, the bug will happen only if the list has many values (17000 in this case)
If I select 2 or 3 or more values in the list, Excel 2007 SP2 crashes immediately.
With Excel 2003 SP3, the bug
is different, it simply ignore the multiple select and always shows everything. Furthermore, there is a private hotfix
kb947648-fix that repairs this bug.
Is there any hotfix to repair the Excel2007 version of this bug?