Hi.
I have Excel (excel 2002 sp1) pivottable as my client, and keep
getting some strange behavior from the app. In order to present the
Report correctly to the customer, I've hidden som levels in the
dimension (rows). But when I refresh the Report, some of the members
in the level "falls down" to the bottom of the report. There's not
always the same members, but seem to bee rather random... I've also
created a dimension that holds only the level I want to look at, but
that does'nt do much of a difference. Keep in mind that I've dragged
some of the "sum"-members to a spesific place in the report (Sum's are
mostly calculated members..). Theese members are holding their
positions though.
Is this a bug in Excel or is it something I can do preventing members
falling down?
Any ideas?

Jan