I have an excel spreadsheet (attached) where a pivot is looking at a range of cells.
After the range is changing (columns titles are updated) I refresh the pivot but then it deletes all entrys and I have to rebuild the table.
I changed the formula's on page Site raw to values.
What happens id that the number of columns stays the same but the WK numbers are updated and they should be used as row labels in the pivot.
What is wrong?