ExcelBanter - PIVOT TABLE

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - PIVOT TABLE (https://www.excelbanter.com/excel-worksheet-functions/82850-pivot-table.html)

Siva - Hyderabad

PIVOT TABLE

I want to disable refresh options while working in PIVOt table since it is
disturing my own format while refreshing or adding my data... pl. advise...

PIVOT TABLE

Right click on the pivot table and select "pivot table options", then check
the box beside "preserve formatting".

"Siva - Hyderabad" wrote:

I want to disable refresh options while working in PIVOt table since it is
disturing my own format while refreshing or adding my data... pl. advise...

All times are GMT +1. The time now is 01:47 PM.