Hi,
I work in a company where they have the majority of users on excel 2003 but some on 2007. I know, its annoying. Anyway, I am on 2003 and distribute reports created in 2003 which initially used a GETPIVOTDATA formula to populate the fancy looking front page. However, the 2007 users get errors when they open the report. I tried to change the formulat to a VLOOKUP & MATCH but the same error occurs.
Any ideas on whats going on or what I can do to stop this?
Cheers
GS
I work in a company where they have the majority of users on excel 2003 but some on 2007. I know, its annoying. Anyway, I am on 2003 and distribute reports created in 2003 which initially used a GETPIVOTDATA formula to populate the fancy looking front page. However, the 2007 users get errors when they open the report. I tried to change the formulat to a VLOOKUP & MATCH but the same error occurs.
Any ideas on whats going on or what I can do to stop this?
Cheers
GS