Pivot Table Summaries Getting #REF Error?
I have a few pivot tables set to update weekly, and seem to be refreshing the actual numbers just fine. However, I have some summary functions set up that have totally stopped working, instead giving a #REF Error:
I'm a little surprised, as it worked perfectly (with real cell references, not #REFs) when I originally set it up, and the pivot itself has no trouble populating updated data. It seems that when the pivot refreshed, though, my summary functions lost all valid references. Is there a way to keep this from happening? I would like to keep the pivots current, and the calculations based on it also current. Thanks for any advice!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives