If you want to keep a pivottable, then you can't.

But if you copy to another location (paste special|values) (or even the same
location), you can use techniques at Debra Dalgleish's site:

http://www.contextures.com/xlDataEntry02.html

But this copy won't be a pivottable.

Lisan wrote:

--

Dave Peterson