QuickBooks Statement Writer

Hi there, PJMC.

Protected sheets and cells may prompt to enter a password if you try to edit them.

If you want to work on the report without the protection on the worksheet, I suggest to export the sheet to Excel, where it will not be protected. 

1. From QuickBooks Statement Writer, choose Report.
2. Select Save as and click Excel.
3. Enter a file name and save the file in your desired location.
4. Exit the QuickBooks Statement Writer and browse to and open the file you saved.

Once done, your report will open in Microsoft Excel and will be fully editable.

Please check this article on how to fix issues when using QuickBooks Statement Writer: Fix problems with Statement Writer.

Please know that you're always welcome to post if you have any other concerns. Wishing you and your business continued success.

If I save the file as an Excel worksheet, and fix my formatting issues,  will I be able to pull it up from Quickbooks Statement Writer again?  This is a report I will be running on a monthly basis.

Hello there, PJMC,

You'll want to work on the changes in the Statement Writer window. You're unable to pull up the changes if you do it on the Excel worksheet.

I recommend contacting our QuickBooks support to help you unprotect the worksheet. Here's how:

1. Click Help on the menu.
2. Select QuickBooks Desktop Help or press F1 on your keyboard.
3. A pop-up window will appear, click Contact us.

Let me know if there's anything else I can be of help. 

I appreciate the suggestion, but Quickbooks support was of NO help.  I tried them first.

I appreciate the suggestion.  I tried Quickbooks support first.  They were of NO assistance.  Tried again today, NO assistance.

Thanks for getting back, PJMC.

The password is designed to protect the formula in the document. I understand that you've contacted them our Customer Support Team. Though, I'll still suggest the same thing. They are the best to help you with resetting the password on protected sheets.

Let's follow the same steps shared by MaryLurleenM above.

You can also read this guide about how to use and navigate QuickBooks Statement Writer (QSW).

Comment again if you need anything else.