Exporting to Excel Issues
I am exporting reports to Excel. Whenever I create a new workbook, it exports just fine. However, after I have formatted my spreadsheet in Excel and then want to update the export (i.e. Change date ranges) the update export fails. I have found I can only update a current worksheet when I don't have any colors on my spreadsheet, or do not center my text, etc.. Is there a way to update a worksheet with more current data while still formatting that Excel spreadsheet to make it more appealing?
Another issue I have pop up is "Quickbooks cannot export to a protected Excel worksheet..." None of my worksheets are protected so why will it not export? Any help is appreciated.