Pivot Tables

C

cassie07

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 ?
 
B

Bob Umlas, Excel MVP

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.
 
D

Debra Dalgleish

You can use a dynamic range as the source:

http://www.contextures.com/xlPivot01.html

Or, in Excel 2003, create a list from the orders log:
Select a cell in the log, and choose Data>List>Create List
Use the list as the source for the pivot table

Then when you add new data, it will be automatically detected when you
refresh the pivot table.
 
C

cassie07

Hi There

Not 100 % sure, what I did bu tthat seems to have worked,.

Many thanks for all your responses.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top