delete pivot table

Hello,
Is there a way to delete a pivot table from a worksheet. Right now my
method is to delete the whole sheet the pivot table resides on.
thanks
bill

Bill,

Select all the cells, or more. Edit - Delete. Clear (delete key) won't do
it

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"billq" <[email protected]> wrote in message
news:[email protected]...
> Hello,
> Is there a way to delete a pivot table from a worksheet. Right now my
> method is to delete the whole sheet the pivot table resides on.
> thanks
> bill
>

Select the pivot table and do edit>clear>all

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"billq" <[email protected]> wrote in message
news:[email protected]...
> Hello,
> Is there a way to delete a pivot table from a worksheet. Right now my
> method is to delete the whole sheet the pivot table resides on.
> thanks
> bill
>

Peo's Edit - Clear - All is a better solution, as it doesn't involve the
shifting of cells that goes with Delete.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Earl Kiosterud" <[email protected]> wrote in message
news:%[email protected]...
> Bill,
>
> Select all the cells, or more. Edit - Delete. Clear (delete key) won't
> do it
>
> --
> Earl Kiosterud
> mvpearl omitthisword at verizon period net
> -------------------------------------------
>
> "billq" <[email protected]> wrote in message
> news:[email protected]...
>> Hello,
>> Is there a way to delete a pivot table from a worksheet. Right now my
>> method is to delete the whole sheet the pivot table resides on.
>> thanks
>> bill
>>
>
>