Hi sir Can you tell me plz I have the pivot table If I enter the values in the one column cell the some columns in same row was filling automatically because of formule. But while entering values into column through Java code it is not reflecting the formule just it is filling the particular column only. But manually formule is apply but for the same sheet .it is not working through Java code how can we do that can you plz any hint or any suggestions plz