Numerous pivot reports are generated from a separate base data file. All the
reports files and the data file are currently under one folder, however, I
would like to move the base data file to a separate folder (and leave the
reports where they currently are). I tried moving it, but the reports lose
the link to the base data.

Is there a way to move the source data file and still ensure the pivot
reports still point to it? (without having to go into each report and repoint
the file... there are too many reports for this).

Thanks,