Pivot table field name is not valid - Error

[priyankachatterjee4]

Hi,

I am working with an excel which has not been created by me so i donot know if any pivot table is being used. When this excel is being called from the front end it gives this error 'pivot table field name is not valid'. I am unable to locate the table. Ideally there shouldnt be an pivot table used in the excel. To delete it also i need to select a cell in the table. Please help

 

[JasL]

To find source of data:
Select any cell in the pivot table.
From the menubar, select options then Change Data Source, Change Data Source
This will tell you what data is being used for the pivot table.
This might help in working out which field no longer matches the pivot table.

To delete pivot:
Select any cell in the pivot table.
From the menubar, select options then
Select, entire pivot table, then delete!