Then, check the Refresh Data When Opening The File option in the PivotTable Data section (Figure B). You don’t need to do this for this technique to work, but you should know that you can.