Hi,
I've seen something weird with Pivot Table. All datasources of all PT of my file where corrupt. This could be a manual error (document on a public file at my work), but I can't figure out why somebody would change it "accidently". The worst part of it ; I have one list to feed 10 PT in seperated sheet, Normally, I only need to refresh the 1st one and all 10 PT refreshed. But all datasource point now somewhere else then my data.
It would be strange that someone change voluntary 10 datasource with exactly the same location but ; its weird.
Is it possible that the DataSource of a Pivot Table change by itself ???
If so, how can we correct it ??
Thanks,