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.

Feb 10 '10 #1

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)

Feb 10 '10 #2

Tennotrumps

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

Feb 10 '10 #3

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)

Feb 10 '10 #4

Tennotrumps

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

Thanks anyway.

Feb 25 '10 #5