Why is the export to excel not avaialble for a report? Access 2007

[Tennotrumps]

I am trying to export a report to excel but the "excel" option is greyed out. I can export the query the report is based on, but not the report.

However, if I open the database on another PC I CAN export to excel.

I've tried reinstalling Access, but it doesn't make any difference.

I've also installed the compatability file (as the version of excel is 2003), but to no avail.

What am I missing?

Many thanks for any help I can get - I'm pretty new to Access.

[nico5038]

Looks to be a common A2007 problem. When using A2003 all should work.
An alternative might be to export just the query the report is based on.
(My favorite way, as the MS Word and MS Excel export do "criple" the data anyway.

Nic;o)

[Tennotrumps]

thanks - but why does the other PC allow it? it appears to be exactly the same configuration? Unfortinately I cannot use A2003.

[nico5038]

You could try to create a new empty database and import all objects (using "get external data") into there and try again.

Nic;o)

[Tennotrumps]

Now, for no apparent reason and after no further changes to anything, it has decided to allow teh esport to Excel!!!

Thanks anyway.