I have a table of data from Access that I paste into a sheet titled "Data" in
Excel as a data source, field names and all. The pivot table is in another
sheet of the same workbook. I've checked to be sure the data source is the
tab I am using (Data!A$:AC$). Even though I paste into the same place and
have much different data now the same percents that I had before still show
up when I run my calculated amounts. All of the headings are the same as
before. I even tried a "Refresh data" but it made my calculated fields
return zeros. Any ideas what went wrong? Is a "Refresh" from the data in
another tab of the same workbook necessary? How can I be sure it is using
the new data and not remembering the old data somehow?
--
Tmarsh7407