View Full Version : Report wont expot to excel


chefdaveross
09-11-2007, 05:03 PM
I have a report that would export to excel in 2000 version.
Now that I have updated, I can no longer export to excel. The option is not highlighted and is not available.
Any reason why?

The_Doc_Man
09-11-2007, 06:53 PM
Since you updated, you probably broke the reference to the Excel object library. See if you are missing any references.

Search this forum for ways to re-assert broken references. Topic is "references" and "missing references"

chefdaveross
10-10-2007, 11:31 PM
After searching the forums,
I have tried checking and unchecking many different references.
None are labeled missing.

Visual basic for app
microsoft access 12.0 object library
ole automation
microsoft office 12.0 access database engine object

is there any Im missing?

My excel export option is greyed out on my ribbon and is not available

chefdaveross
10-10-2007, 11:49 PM
After searching this issue for hours i have found some evidence that you cannot export reports to the Excel format in Access 2007. Microsoft has disabled this functionality.

here is the link:
http://support.microsoft.com/kb/934833

boblarson
10-10-2007, 11:50 PM
You can still do it if you use the Excel COM Object model though.