I have a pivot-table sheet (let's call Pivot) that I am trying to link to the JDE data sheet (let's call JDE) but I need to refresh the range of the data that the pivot captures (for example right now the range covers JDE!R3C1:R7296C31 but each time that I add new data to the JDE sheet the range will increase)
thx
bg
thx
bg