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...
My guess is that you're pasting the entire table, including the headings. This may confuse Excel. Better to just paste the data, excluding the headers. And while you're at it, if you haven't done so yet, format that range as a table and base your pivots on the table.
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.
