Hi guys, i have a pivot table that is feeded through another workbook,
then i calculate the rest of the pivot with the option Calculated fields
but i have a problem, each time i open the 2 workbooks and make refresh, my
calculated fields disappear leaving #NAME in the cells, and i have to do
the
have you changed name of a name range used in the formula
On Mon, Jul 4, 2011 at 9:23 PM, Jorge Marques leote.w...@gmail.com wrote:
Hi guys, i have a pivot table that is feeded through another workbook,
then i calculate the rest of the pivot with the option Calculated fields
but i have a
Mmm i checked the range, and everything is ok, even if i open the pivot
workbook and choose the source range again, it gives the same error when i
do refresh data :(, gives #NAME, and also on the list formulas appears
#NAME.
2011/7/4 ashish koul koul.ash...@gmail.com
have you changed name of a
can you share the workbooks
On Mon, Jul 4, 2011 at 9:44 PM, Jorge Marques leote.w...@gmail.com wrote:
Mmm i checked the range, and everything is ok, even if i open the pivot
workbook and choose the source range again, it gives the same error when i
do refresh data :(, gives #NAME, and also on