han77729
New member
- Joined
- Dec 12, 2012
- Messages
- 31
- Reaction score
- 0
- Points
- 0
All,
I'm an absolute excel noob comparing to you guys. I have a worksheet load of data that are categorized (ex: Part number, part type, application, region etc). I created a pivot table using that data in the same workbook and life is all fine. But when I'm trying to update the database again, I tried to copy and paste it right over or delete everything and paste in new datas my pivot table won't update. I would see the new updated worksheet with all the right numbers but my pivot table is not picking it up.
Please help.
Thanks,
I'm an absolute excel noob comparing to you guys. I have a worksheet load of data that are categorized (ex: Part number, part type, application, region etc). I created a pivot table using that data in the same workbook and life is all fine. But when I'm trying to update the database again, I tried to copy and paste it right over or delete everything and paste in new datas my pivot table won't update. I would see the new updated worksheet with all the right numbers but my pivot table is not picking it up.
Please help.
Thanks,