SandsB
Well-known Member
- Joined
- Feb 13, 2007
- Messages
- 705
- Office Version
- 365
- Platform
- Windows
Simple pivot table. Simple chart. I use a named range of 100,000 rows as the data source because every day there's new data in additional rows.
The pivot table is fine, the chart is fine - but I have to do a refresh to update the table and the chart. Is there a way to make it just happen on its own?
The pivot table is fine, the chart is fine - but I have to do a refresh to update the table and the chart. Is there a way to make it just happen on its own?