Hidden Items visible in Excel 2007

[Tsunami]

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

[rockytopmark]

Not sure what your implementation is, so I'll throw out the use of Render Variables as a possible work-around for your situation.

[Rutulian]

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.