I right-clicked a row in the pivot table and in the dropdown menu selected
hide and the row disappeared.

While I'm at it, is there a way to get the datasource of a pivot table? I
have an excel file with some pivot tables from sql server that were created
using Microsoft Query. Is it possible to retrieve that sql or the stored
procedure name used? I know that the pivot table was created using either a
plain tSql statement or a plain stored procedure (as opposed to an MDX
query). Is there a way in VBA to retrive the sql or name of the sp?

"Jim Thomlinson" wrote:

> There should be no need to re-create the pivot. When you say you hid some
> rows, what exactly did you do to hide the rows?
> --
> HTH...
>
> Jim Thomlinson
>
>
> "Rich" wrote:
>
> > Hello,
> >
> > I have been practicing with pivot tables and hid a few row sections. But I
> > have not been able to unhide the row. Is there a way to do this? or do I
> > have to recreate the pivot table?
> >
> > Thanks,
> > Rich