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.