Excel 2000 macros to Excel 97

[Tim_Field]

Hi All

I've written a load of macros with pivot tables in Excel 2000 and need to run the same thing in Excel 97 (for backward compatability). Is there any way to convert my 2000 ones to 97?

Many Thanks, Tim

 

[PaddyD]

Not generically - depends on what features on available in 2000 you've actually used - so more details please.

(p.s. as ytou've probably noticed, always advisable to code for lowest likely version trhat's going to be used )

 

[Tim_Field]

I've used the Pivot Table report macro. This is what I need to convert.

 

[PaddyD]

what's the code? what about it isn't qworking in 97 versions?