I have a pivote table in Excel that is linked to an OLAP cube. The
table is basically an financial income statement. I need to force a
particular sort for the top level rows in the dimention. The
dimension goes something like I/S category - sub category- .... Under
I/S category I want to sort the rows not in either alpha accending or
decending order (which I know how to do through code.) I tried to use
a custom list but when other users try to view the table the list does
not appear for them indicating that the list may be stored locally.
Does anyone know how to force the sort of a diminetion through VBA???
Thanks for any help you may be able to give.

-Scott