Yes the data in wks 1-12 did change
That was a great question and one I didn't think of.

-----Original Message-----
Is the data on a sheet in the same workbook?
What happens if you change the data in weeks 1-12? Does
the pivot table
change when you refresh it?

Steve wrote:
Yes I that was the first thing I checked and the range
was
included

-----Original Message-----
Is the new data included in the pivot source? To check:

Select a cell in the pivot table
On the Pivot table toolbar, choose PivotTableWizard
Click the Back button
If the range doesn't include the new rows, select them.
Click Finish

If that was the problem, you might find it easier to
use

a dynamic range

as the pivot table source. There are instructions he

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

Steve wrote:

I looked at everything.
Since I have updated data sheet my pivot table is not
updating. It still only shows wk 1-12 (last time I
updated).

I click the update pivot button and nothing.
I checked the pivot table and it captures all rows and
columns for weeks 1-48.
I checked the Week Pivot button and it has a check
next

to

show all and also next to each week 1-12 but does not

show

any week past 12.

Please help
Steve


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.