ExcelBanter - Issue with pivot table

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Issue with pivot table (https://www.excelbanter.com/excel-discussion-misc-queries/261662-issue-pivot-table.html)

varsha12

Issue with pivot table

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.

Jim Thomlinson

Issue with pivot table

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.

All times are GMT +1. The time now is 06:10 AM.