If you change any of the text or numbers in your data set, you need to refresh the pivot table. If you change the size of your data set by adding or deleting rows/columns, you need to update the source data for the pivot table. This way your data source will be updated automatically when you add or delete rows/columns. Reports created in versions before 7.0 will still maintain the legacy behavio unless explicitly changed.
At this level of sales, you would normally have a thousands separator and probably no decimal places.
Although the original data had a numeric format applied, the pivot table routinely formats your numbers in an ugly general style.
This functionality has not come to regular pivot tables yet.
For example, in the figures in this chapter, the numbers are in the thousands or tens of thousands.
But if you then update one of the source tables while the report is already opened, the downstream tables would NOT update automatically before version 7.0.