schielrn
Well-known Member
- Joined
- Apr 4, 2007
- Messages
- 6,941
I have just upgraded to 2007 at work and I have many pivot tables that use dynamic named ranges and not all the references are saying they are not valid? I can hardcode a named range and it works fine. I also click on the named range and it highlights the correct area, but the pivot tbale will not accept this.
Do I have to accept the fact that this is no longer do-able in 2007 via a dynamic range formula using offset or indirect?
Thanks,
Rob
Do I have to accept the fact that this is no longer do-able in 2007 via a dynamic range formula using offset or indirect?
Thanks,
Rob