MS Access - How to allow a report to be exported to excel

[Tennotrumps]

I have a report in MS Access which I want to export to excel. However the option is greyed out.

I can export the query which teh report is based on, but not the report. However, when I open teh same database on another pc I DO have the option. What am I missing?

Tennotrumps