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 |
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 |
All times are GMT +1. The time now is 12:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com