Hi, I have been trying to update a pivot table which data is imported from another excel book.
However, when I refresh the pivot table to update it, the pivot table changeS totally in format and groups up by date.....
Can anyone please tell me how to store the format of the pivot table and not change while updating.
Thank you,
