By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,117 Members | 2,142 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,117 IT Pros & Developers. It's quick & easy.

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

P: 11
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
Share this Question
Share on Google+
4 Replies


nico5038
Expert 2.5K+
P: 3,072
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

P: 11
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
Expert 2.5K+
P: 3,072
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

P: 11
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

Post your reply

Sign in to post your reply or Sign up for a free account.