Connect with Expertise | Find Experts, Get Answers, Share Insights

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

 
Join Date: Feb 2010
Posts: 11
#1: Feb 10 '10
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's Avatar
E
M
C
 
Join Date: Nov 2006
Location: The Netherlands
Posts: 2,655
#2: Feb 10 '10

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


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)
 
Join Date: Feb 2010
Posts: 11
#3: Feb 10 '10

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


thanks - but why does the other PC allow it? it appears to be exactly the same configuration? Unfortinately I cannot use A2003.
nico5038's Avatar
E
M
C
 
Join Date: Nov 2006
Location: The Netherlands
Posts: 2,655
#4: Feb 10 '10

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


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

Nic;o)
 
Join Date: Feb 2010
Posts: 11
#5: Feb 25 '10

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


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

Thanks anyway.
Reply