Pivot Tables
Pivot tables need to be "Refreshed" - the red exalamation mark. If that
doesn't do it, then you need to redefine the range which the pivot table
covers. Best to either insert new records inside the already-defined source
range or use a self-defining name for the range & use the range name in the
pivot table -- but you'd still need to refresh the table.
"cassie07" wrote:
I have an order log which is added to on a daily basis.
I have made a pivot table from this to show ordering by divisions, suppliers
etc.
However, when I add new orders to the log, the pivot table does not update.
I am new to this so a little lost, has anyone got any ideas ?
|