If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access 2007 - Export a Report
I have been exporting a report to Excel for several months but, upon bring
given a new computer, the Export to Excel icon in the External Data ribbon is suddenly grayed out (allowing Word export only). Since I've been doing the process in Access 2007 on my old computer, I'm assuming that there is a default setting that I need to change, but cannot find anything. I'm now receiving requests from others in our department with the same issue, so any help you can lend would be appreciated. -- DT |
#2
|
|||
|
|||
Access 2007 - Export a Report
When Access 2007 first came out, a host of my applications' users clamored
for the "Export-to-Excel" to get turned back on. It seems Microsoft turned it off as, purportedly, part of a settlement. While it is possible (and was necessary) to come up with a work-around, it wasn't pretty and wasn't easy. I seem to recall that the most recent updates to Access included a fix ... is your version updated? Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "DT" wrote in message ... I have been exporting a report to Excel for several months but, upon bring given a new computer, the Export to Excel icon in the External Data ribbon is suddenly grayed out (allowing Word export only). Since I've been doing the process in Access 2007 on my old computer, I'm assuming that there is a default setting that I need to change, but cannot find anything. I'm now receiving requests from others in our department with the same issue, so any help you can lend would be appreciated. -- DT |
Thread Tools | |
Display Modes | |
|
|