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...