getpivotdata excel97 compatability with later versions

M

mrsckum

I've got extensive pivot tables and a wide variety of other worksheet
that look up data in those pivot tables. It all works great on m
machine, BUT I have excel 2002 and the client has excel 97.

Unfortunately the format for getpivotdata has changed in the year
between excel97 and excel2002 and when I bring my work to the olde
machines, it produces a lot of #VALUE! results.

Is there a tool for converting backwards for compatiblity, or am
going to be spending a few hours rebuilding my formulae?

Thanks,

Andr
 

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