Forum Discussion
Keeping slicer report connections as I add new data to the tab driving the pivot tables
I have an Excel file with multiple tabs which I use as a template. The file has one tab (Data Tab) where I place raw data which is used to drive pivot tables. The columns are always the same name and...
JKPieterse Thanks for the answer. I haven't done the table thing, but was thinking that might be the way to go. You're right, I am just copying/pasting the data rows from my data sheet into the tab which drivers the pivot tables and slicers. I will give this a shot. Thanks!
JKPieterse Thanks again! I changed the Data Tab to a table and that has fixed this issue and has made the file much quicker to complete and adding additional data analysis.