Thanks for this! My colleagues report is using this exact setup but whenever I try to add new data to the source table, it doesn't recognize it as part of the table. When they do it however, it does. What could be the issue here?
The table should expand automatically if you data directly underneath it (the next available row). If you're leaving any kind of gap (i.e. entering on the second blank row versus the first one beneath the data), then it wouldn't detect it. That's the only reason I can think of as to why it may not be working.
Will you be doing a second part to your dynamic calendar video like you mentioned in the original? To cover things like having multiple events on one day, changing the year, and other questions people asked of you in that video....
Thanks for this! My colleagues report is using this exact setup but whenever I try to add new data to the source table, it doesn't recognize it as part of the table. When they do it however, it does. What could be the issue here?
The table should expand automatically if you data directly underneath it (the next available row). If you're leaving any kind of gap (i.e. entering on the second blank row versus the first one beneath the data), then it wouldn't detect it. That's the only reason I can think of as to why it may not be working.
Will you be doing a second part to your dynamic calendar video like you mentioned in the original? To cover things like having multiple events on one day, changing the year, and other questions people asked of you in that video....
Yes I have been working on a template. I am aiming to post it along with a video later this month
is it possible to auto refresh the pivot when source data changes without using VBA?
Unfortunately not. Right-click refresh would be the quickest way.