I created a pivot table. But when I enter a new value in a cell it doesn't appear in the pivot table. I have to create a new pivot table and than I can see that new data is entered in a cell.
For instance, my pivot table holds dates as ROW LABELS and COUNT OF these. And when I enter a new date, that date is not shown in the ROW LABELS until I create a new pivot table. What's wrong ?
Excel 2007
make an table from your data.
Insert => Table.
If you add new information direct below the last value in the row or direct right to the last column (and you make an header in this) the table will expand.
Then those rows and columns also belong to the table.
You make after that an pivot table.
Excel 2007 => Insert => pivot table
If new data are added you can just refresh the data and there also in the pivot table.
Hope I explained it well enough.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
When you create a Pivot table, Excel makes a copy of the source data and stores it in a separate (hidden) datatable that the pivot datas table uses. That is why changes in the source data does not affect the pivot table. To update the pivot table with the new data from the source you will have to refresh the data. Just right click on any cell in the pivot table and select Refresh.
Ok thanks. Simple, fast solution
@pic2pic
On your treath have respond several members.
Its nice (and interesting) to know to whom your responding.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks