Intuit Statement Writer - cell protection in Excel
US QuickBooks Enterprise Solutions : 12.0: Standard
How can I unprotect cells in a worksheet when using Intuit Statement writer. Does anyone know the password to unprotect the sheet?
1
325
d_55Von-Gr4yUOacwZ5xHE
01/05/12 2:02pm PST
Viewed by asker 01/13/12 4:35am PST
Viewed by asker 01/13/12 4:35am PST
7 Replies
ISW_User
Questions asked: 0
Questions answered: 431
Points earned: 824
Questions answered: 431
Points earned: 824
Intuit Superstar
Employee who makes outstanding contributions to the community
Intuit Moderator
Mod/Co-mod
01/09/12 1:43pm PST
The sheets are protected to maintain the link between Statement Writer and QuickBooks so you get live data. Statement Writer may have a solution for what you are needing to do that does not require removing cell protection. What is it that you are wanting to do? Move rows? Change an account balance?
01/09/12 3:05pm PST
I resolved it by adding another worksheet that was not part of statement writer but that I could still input percentages using statement writer. I wanted to be able to delete columns.
01/10/12 7:40am PST
Statement Writer has the ability to delete columns. You can find it in the Column Properties section of the Statement Writer pane. There's also the ability to add columns and change the column properties as well.
01/10/12 8:27am PST
I had duplicated the statement writer sheet on another tab and the statement writer functions do not work when you do that so I could not use the delete or add function. I inserted a new sheet instead of copying the statement writer sheet and that resolved the issue.
01/10/12 8:44am PST
The solution
Statement Writer functions only work for statements that are within Statement Writer. You do have the ability to create new Excel tabs within Excel, but that's purely Excel and not Statement Writer which explains why you couldn't use Statement Writer functionality.
In any Statement Writer statement you have the ability to delete/modify/create columns & rows using the pane on the right side. So in your original statement, not the copied one, you can delete rows, modify them as well as insert new ones. I recommend becoming familiar with the Statement Writer pane, and if you always get stuck you can also contact technical support.
03/09/12 6:14am PST
I watched the video course about ISW that Michelle Long did for Intuit but I cannot get the Primary Header to change using the Document Action Toolbar. I want the header at the top of the page to show the period that it is for (under the Co. name and the name of the report). Right now it shows these words "Month and 2 months ended Feb. 29, 2012". I want it to show "Feb 2012 and YTD 2012." How can I change it? Everytime I try to change it using the Document Action toolbar it just remains the same without changing anything. I don't want to have to start for scratch creating the Stmt. again. HELP!!
03/09/12 10:56am PST
Latest post
I'm not familiar with Michelle's video, so I can address it specifically. Are you wanting to change Columns headers or the actual report header? If you want to change the report header itself, you'll want to use the Edit Header/Footer feature. If you're in QuickBooks Statement Writer 2012, you have more capability for modifying what you see.
