Export to Excel Error "Cannot expad named range.

K

Kay

While running a Access 2007 saved export to an .xlsx file I received the
error "Cannot expand named range." This is a saved export and existing .xlsx
file that has previously worked fine. The named range is the same name as
the Access query that is exporting so is the tab created in the .xlsx. I
have never seen Excel created a named range during an export. The only way I
can get the export to complete is to delete the .xlsx file. This happens
periodically and without consistancy. Any ideas what causes this? Is it
exclusive to Access 2007?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Working outlook via vba code with xlsx - error 0
Export BPMN Visio Chart to Excel 0
Autonumber field in Excel that behaves the same as Access 0
Save workbook without shapes 0
Apply Excel Macros to another open file 1
Cannot expand named range. 1
XLSX Transferspreadsheet 2
Help with copying a sheet from One workbook to another workbook 1

Top