More information: When I expand the hierarchy in the display, then try to go to the uderlying data I get 'out of memory.'
I managed to fix the error by removing a large VARCHAR field from the view. And limiting the data by one more year.
Have others seen this behavior?
And the error is back again.
Can someone explain why this error occurs? Is it too much data (<700,000 rows)? Is it too complicated a model - there is a hierarchy with the finest-grain data usually not shown on the main page? Is it affected by other worksheets in the same workbook?