That was Excel 2007 by the way. We have many cubes, and all cubes when
brought into Excel 2007 the rows have the Expand/Collapse buttons, except a
couple cubes. Is there a BI attribute that needs to be turned on when
building a cube that would affect the Excel Expand/Collapse buttons from
showing?

"578117" wrote:

When point a blank Excel file at a cube, the expand/collapse buttons don't
show after adding rows and columns to the pivot. However looking at this
cube in SQL via Browse, the same rows and columns, the rows fields have the
expand/collapse buttons.