Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data is not refreshing-Excel 2003
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data is not refreshing-Excel 2003
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? Ronnie wrote: 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? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Conditional formatting not refreshing as it did in 2003 | Excel Discussion (Misc queries) | |||
Excel 2003: VLOOKUP not refreshing | Excel Worksheet Functions | |||
Refreshing 2003 Pivot Table w/ Excel 2007 | Excel Discussion (Misc queries) | |||
Refreshing Data In Excel / VBA | Excel Discussion (Misc queries) | |||
Refreshing Access data in Excel | Excel Discussion (Misc queries) |