K
Kevin
I created a pivot table and since I was not able to protected, I inavertly
typed some data into one of the cells in the pivot table, since then every
time I enter a number in the source of the pivot table the pivot table now
gives me the wrong number. Per example in one of the cells of the pivot
table I change the number 3 for the number 4.10 now every time I type the
number 3 in the table source, the pivot table writes 4.10, in any cell that
contains the numeral 3. Is there a way to revert back?
I try by typing the number 3 into the pivot table to match with the source
and it seams to work, but some of the formulas are not adding up properly
the formulas are ignoring the numeral 4.10(or know as 3).
thanks in advance for your help!
typed some data into one of the cells in the pivot table, since then every
time I enter a number in the source of the pivot table the pivot table now
gives me the wrong number. Per example in one of the cells of the pivot
table I change the number 3 for the number 4.10 now every time I type the
number 3 in the table source, the pivot table writes 4.10, in any cell that
contains the numeral 3. Is there a way to revert back?
I try by typing the number 3 into the pivot table to match with the source
and it seams to work, but some of the formulas are not adding up properly
the formulas are ignoring the numeral 4.10(or know as 3).
thanks in advance for your help!