$$Excel-Macros$$ Help what the hell is wrong with my pivot table?

2011-07-04 Thread Jorge Marques
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

Re: $$Excel-Macros$$ Help what the hell is wrong with my pivot table?

2011-07-04 Thread ashish koul
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

Re: $$Excel-Macros$$ Help what the hell is wrong with my pivot table?

2011-07-04 Thread Jorge Marques
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

Re: $$Excel-Macros$$ Help what the hell is wrong with my pivot table?

2011-07-04 Thread ashish koul
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