unable to set the Orientation property of the PivatField class

D

Dan

I am getting an "unable to set the Orientation property of the PivatField
class" error when adding a field to my pivot table (.Orientation =
xlDataField).

#the strange thing is I get the error when I use some data but not when I
use other - and I don't think there is any difference of setting on the data.

Do you know how UI can prevent this error.
Many thanks,
Dan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top