When I run a report and save it's output as Excel 2007, the 'hidden' items are visible in the formula bar. Has anyone came up with a work around?
Here's is the related article: https://www-304.ibm.com/support/docview.wss?uid=swg1PK96992
Not sure what your implementation is, so I'll throw out the use of Render Variables as a possible work-around for your situation.
Hi Tsunami,
I just worked around a very similar situation, I split out the crosstab with a hidden item to its own query with a slicer member set. The slicer member set had the same definition as the item which was previously hidden.