I can't export to excel - it keeps on giving me an error message that the workbook is password prot

Di_8082088
Di_8082088 Member Posts: 4
edited February 2020 in Accounts Hosted
I'm trying to export multiple reports to excel.  In order to save time I create the first workbook and then add the reports to the existing workbook.  For the last year I keep on getting the error "the workbook is password protected.

Can someone please help me solve this?  It's driving me nuts.  I've already moved some of my clients over to Xero

Comments

  • Debbie_9161664
    Debbie_9161664 Member Posts: 57
    edited February 2020
    Save it as a comma delineated and it will work once you download it you can save as a workbook etc, it did the same to me with the P&L

    That should work for you 
  • Debbie_9161664
    Debbie_9161664 Member Posts: 57
    edited February 2020

  • Debbie_9161664
    Debbie_9161664 Member Posts: 57
    edited February 2020
    And its called comma separated values in Reckon hosted ... my eyes are rolling lol 
  • Bethtx
    Bethtx Member Posts: 2
    edited September 2019
    SOLUTION FOUND!!  Your Excel worksheet must be in the Normal view.  If your Excel sheet is in the Page Layout view, QuickBooks for some reason recognizes that as Protected.