"FormatPercent" in Access Query Is Not Recognized by Excel

[lemo]

Hi.

I just finished improving my beloved access query, yet again, only to see the following message appear when I try to refresh data in an Excel pivot table that uses it -
"Undefined Function 'FormatPercent' In Expression."

Any ideas? Workaround?

I'd love it to work, somehow, because otherwise it will turn into a long story - I'll have to ask the Information to change the field format, they'll have to discuss it, etc.

Thanks,
L
p.s. It's all Office 2007.

 

[lemo]

ok, i figured the workaround - just multiply the number by 100, round, and concatenate with "%" sign.

still curious why 'FormatPercent' doesn't work though. not like Excel doesn't have the function..

l