ExcelBanter - deactivate the get pivot formula when I link a cell to a pivot

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

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - deactivate the get pivot formula when I link a cell to a pivot (https://www.excelbanter.com/new-users-excel/62985-deactivate-get-pivot-formula-when-i-link-cell-pivot.html)

hwtradezheng

deactivate the get pivot formula when I link a cell to a pivot

Currently I using excel 2003, but every time when I link the cell to a pivot
table it will convert to a "Get pivot" formula. Is there any way I could
deactivate it?

Ron Coderre

deactivate the get pivot formula when I link a cell to a pivot

See Debra Dalgleish's website for instructions:

http://www.contextures.com/xlPivot06.html

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

"hwtradezheng" wrote:

Currently I using excel 2003, but every time when I link the cell to a pivot
table it will convert to a "Get pivot" formula. Is there any way I could
deactivate it?

All times are GMT +1. The time now is 08:32 AM.