Export Access Report (2007) to Excel spreadsheet

Topic

New Reply

Godd morning all,

A client of mine recently upgraded from Access 2003 to Access 2007. In 2003 she was able to export a report to excel from print preview. In 2007, the export to Excel option is grayed out. Is there a setting that needs attention? TIA.

Reply | Quote

Replies

The export to Excel was broken in Office 2007, but SP2 of Office 2007 fixes it, and also adds PDF export capability. Note that some issues with SP2 have been identified, but in general I find it is an improvement.

Reply | Quote

Thanks Wendell, I’ll look into this.

Reply | Quote

Thanks Wendell, I’ll look into this.

SP2 works a treat in restoring the export report to Excel option.

Reply | Quote