Forum Discussion

MVP

Re: Auto Refresh for Pivot tables created on sheets (Master data also on the same sheet)

Thanks. See the attached version.

Draft.xlsm20 KB

8 Replies

Chris525
Tin Contributor
Apr 01, 2024
HansVogelaar

Many thanks. It works now.

Please let me know which step I missed?

Thanks
- HansVogelaar
  MVP
  Apr 01, 2024
  Chris525
  
  I converted the source range to a table, and set the pivot tables to refer to the table instead of to a fixed range,
  - Chris525
    Tin Contributor
    Apr 01, 2024
    HansVogelaar
    
    Thank you!!
    
    Sorry one more question how did you set the pivot tables to refer to the table instead of to a fixed range?
    
    Can you kindly suggest me any tutorials I can refer regarding this subject?
    
    Thanks