Hello there, MaggieWimberly.
I'm here to help you answer your questions about exporting your file.
Create a backup worksheet during an update means that while QuickBooks is updating your existing file, Excel is creating another file as a backup copy as well.
It's important that you create backups of your QuickBooks data so that you'll always have access to your business's most current, usable, error-free financial files and information.
If you will turn it off, it won't still affect your book numbers since it will t will only update the existing file.
You can check out this article for more information about the compatibility of QuickBooks Desktop: QuickBooks Desktop crashes when exporting a report to Excel worksheet.
For your future reference, we have some articles that can help you organize your QuickBooks account: Help articles. You can click on each topic to view them.
Please touch base with us if you need further assistance exporting your file . I'll always be right here to help you anytime.