Pivot Table and Slicers COPYING Workbook

[Anton Jansen]

I have a sales program I re-structure every year because the COPY FILE does not work. Copying the file for a new year returns an error saying the data it is looking for is external. I have 5 worksheets with pivot tables and slicers. Sheet 1 contains the data only in a table. For every new year I would like to copy the file, delete the data on Sheet 1 and leave the structure, pivot tables and slicers intact. However this does not work.