In Access 2007 for query exports to Excel 2007 – How do you turn off Automatic backups
How can Access 2007 be set so that when it exports queries to Excel 2007, backups are NOT created in Excel each time the Excel file is saved? How can Access 2007 be set so as not to cause EXCEL 2007 to backup exported query files?
Software/Hardware used:
Windows XP Pro, Access 2007, Excel 2007
Software/Hardware used:
Windows XP Pro, Access 2007, Excel 2007
ASKED:
December 20, 2010 12:00 PM
UPDATED:
March 11, 2011 2:54 PM
RELATED QUESTIONS
- How to export a shared mailbox in Outlook 2007
- Export Crystal Reports to Microsoft Excel format
- Mac Office 2011 - Export Calendar items in Outlook to Excel
- How can I export from Notes to MS Access and have links function within Access taking you back to a Notes data page?
- Data transfer from Access 2007 to Excel 2007 stops at 65,xxx rows
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
That is an Excel problem, not access.
You need to go into Excel tools options and unset the box telling Excel to make backups. Be aware that this will also stop backups being made of all workbooks saved.