Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot reporting wrong info-riv
hi peeps
having an issue with my pivot tables was wondering if anyone new how to fix. my pivot tables were created from my source data and worked fine but now after i have refreshed them a few times to collate the new data its started to report things wrong i.e codes linked to products become mixed or brands of the products are linked to the wrong products. currently to fix this i create a new pivot then paste over the old. but this is time consuming and i dont want to have to train others on how to do this maintinence work. does anyone have any ideas whats wrong? or how to fix this? thank you |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot reporting wrong info-riv
i found by creating a backup pivot next to the origional and pasting over the
top will fix the issue PLEASE PEOPLE COPY THIS ACTION AS IT HAPPENS FREQUENTLY TO MOST OF MY PIVOTS ONCE I START USINGTHEM IN ADDITION TO MACROS!!!! "Rivers" wrote: hi peeps having an issue with my pivot tables was wondering if anyone new how to fix. my pivot tables were created from my source data and worked fine but now after i have refreshed them a few times to collate the new data its started to report things wrong i.e codes linked to products become mixed or brands of the products are linked to the wrong products. currently to fix this i create a new pivot then paste over the old. but this is time consuming and i dont want to have to train others on how to do this maintinence work. does anyone have any ideas whats wrong? or how to fix this? thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup function - Wrong info when I add lines to reference spreads | Excel Discussion (Misc queries) | |||
question on links where info is added and cell location is wrong | Links and Linking in Excel | |||
Pivot table for reporting sales performance | Excel Discussion (Misc queries) | |||
Reporting results of pivot table | Excel Worksheet Functions | |||
lookup function bringing in wrong info | Excel Worksheet Functions |