Pivot Tables

Sharon Hillier

New Member
Joined
Nov 28, 2005
Messages
1
I only know the basics in Excel & have been given a file to update daily with a worksheet that feeds pivot tables which then feeds another file that creates graphs. Each time I add a new customer to the data sheet it automatically ticks it and adds to each pivot table so then I have to go through manually and untick each sheet. Is there anyway around this? Also is there a way to set the file to automatically refresh data in the pivot tables when you save/close the file? Many thanks
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Watch MrExcel Video

Forum statistics

Threads
1,118,284
Messages
5,571,304
Members
412,380
Latest member
Angelagrace
Top