Hope you are well!
Please let me know if we have work around to deal with this issue. I am looking forward to see the concrete solution in your upcoming book. Best of luck for it
Jeff- did you ever wrap this up so that it writes back to update the source data, and allows duplicate entries? I'd VERY much like to see this! (**read I'd PAY to see this**)
Hi TyWils. No, I haven't (yet) progressed this, because I've been working on some other PivotTable-based addins that I want to get out the door first. But this is on my radar, and I would be interested in talking further about what it is you are trying to achieve, because there's nothing like a real-world example. Flick me an email at weir.jeff@gmail.com if you like, explaining further about what you are trying to do. Feel free to include a sample file.