471,881 Members | 1,547 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,881 software developers and data experts.

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

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
4 4895
3,080 Expert 2GB
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.

Feb 10 '10 #2
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
3,080 Expert 2GB
You could try to create a new empty database and import all objects (using "get external data") into there and try again.

Feb 10 '10 #4
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.

Similar topics

1 post views Thread by Steven Stewart | last post: by
2 posts views Thread by PerryC | last post: by
1 post views Thread by arnabit | last post: by
reply views Thread by zermasroor | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.