Data is not refreshing-Excel 2003

R

Ronnie

I have a pivot table from a data source which I update monthly. I added data
for this month, but am unable to get the tables to update. I have check the
data fields in the wizard and seem to have the information correct, it is
just not pull in the new data into my table.

Any ideas?
 
D

Dave Peterson

Did you click on the "refresh data" icon on the pivottable toolbar.

Is there a chance that your pivottable is based on an exact range and your new
data isn't within that range?
 

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

Similar Threads

Add additional information to excel form after original data entry 0
Dealing with the error: unable to filter on excel hc home school 0
Dates In Excel 5
Consolidation Table from Different Excel Tabs with Different Format 1
Creating a Search using a combo box and then creating a report. 4
Create a chart from a table in word thats dynamic 0
Setting column width in a table with a macro is not working 0
Creating a Chart on form from selected data in query. 0

Top