Hello,
I have about 20 pivots that are used every week and the data behind them is changed every week.
Does it make a difference if I make tie pivot A$1:R$186 (where the data ends) (number of entries changes every week)
Or keep it open like A$:R$?
Will there be any difference ?
Bookmarks