BlueRhinos
Board Regular
- Joined
- Aug 31, 2007
- Messages
- 83
Because my pivot table is used by several users the data source changes often. In response, I created and applied a dynamic range using the offset formula. While the pivot talbe grabs the correct # of records, it inserts a blank column and row. There are NOT any blank cells in the data source range, as reflected by pivot table counts for the Blank column and Row. Any idea why Blank is showing up in my pivot table and how I can correct while maintaining the dynamic range?
Thanks!
BlueRhinos
Thanks!
BlueRhinos