Why does Access to Excel export create backup copies of Excel?

  • Thread starter Thread starter Erica
  • Start date Start date
E

Erica

It's very annoying. . . how do I turn it off?

When I export a query to Excel, Access exports it to Excel but it
automatically generates a backup copy of every Excel workbook.

In Excel, auto-backups are turned off and this doesn't happen if I'm working
in Excel from the start. So I'm assuming it something in the exporting
feature of Access.
 
In excel check the auto recovery settings under options. Turn it off and
try it again. See if backup goes away as excel when opened will make a
recovery file, this may be what is happening. I could not duplicate it so
if it works please post back. Pete D.
 
Thanks Pete, but the auto recovery box isn't turning off the auto backup
(.xlk) files it creates. Since I've posted, another person in my
organization has also reported the same issue between Access exports and
Excel.

It only occurs when I'm using the export "wizard" feature in Access 2007
(although the database is still in Access 2002 format, I believe. We have
not converted it to 2007 since others without Office 2007 are not yet on the
same system.

Here are the steps I've taken:

1) Opened a query.
2) Went to "External Data" tab and clicked "Excel" on the Export section.
3) Chose to export in .xlsx format. Chose to preserve formatting and choose
to open the destination file. Did not choose to save the export steps.

Ironically, it I just highlight the query or table and copy it into Excel,
not backup file is created. All the more reason to believe it has something
to do with the built-in export wizard?
 
Back
Top