So the pivot table was overwritten with text. Assuming that to be the case
then the pivot table is gone with no way to get it back.
--
HTH...

Jim Thomlinson


"varsha12" wrote:

Hi,
We have a report in which the data appears in a pivot table. After some
time the pivot table is coverted to text. Is there a way to covert it back to
pivot table. We have the data of pivot table comming from a query. Please
advise.