Immatoity
06-12-2009, 12:37 PM
pretty simple and I am sure I have asked this before and found out but alas I cannot find out where and cant locate the file ..
anyway..
excel file with 2 pivot tables "Income Pivot" and "Expense Pivot".. based on two other tabs in the workbook...
I want to
a) refresh both on the closure of the workbook and force a save.
b) refresh the pivot if and when items are added to the 2 source lists
anyway..
excel file with 2 pivot tables "Income Pivot" and "Expense Pivot".. based on two other tabs in the workbook...
I want to
a) refresh both on the closure of the workbook and force a save.
b) refresh the pivot if and when items are added to the 2 source lists