sanantonio
Board Regular
- Joined
- Oct 26, 2021
- Messages
- 124
- Office Version
- 365
- Platform
- Windows
Hi All,
Never encountered this before. I often "Dynamically" reference a pivot table using a GETPIVOT, changing the metrics to reference cells. I've done this for years and years without ever an issue.
In my latest creation, however, even before I've changed the direct referencing to Dynamic it's already giving me a #REF ! I've literally typed the equals ("=") sign and clicked into the pivot.
Anyone ever countered this error before? And have a possible solution?
Never encountered this before. I often "Dynamically" reference a pivot table using a GETPIVOT, changing the metrics to reference cells. I've done this for years and years without ever an issue.
In my latest creation, however, even before I've changed the direct referencing to Dynamic it's already giving me a #REF ! I've literally typed the equals ("=") sign and clicked into the pivot.
Anyone ever countered this error before? And have a possible solution?