ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How can I remove cell reference when calculating outside of the pi (https://www.excelbanter.com/excel-worksheet-functions/48350-how-can-i-remove-cell-reference-when-calculating-outside-pi.html)

Doit

How can I remove cell reference when calculating outside of the pi
 
When I attempt to calculate outside of the pivot table using a cell in the
pivot table, my formula repeats using the cell reference instead of the cell
location. I want to use cell location only.
I am using Excel 2003 & Windows XP Professional



All times are GMT +1. The time now is 07:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com