Skip to main content
D
dkessler417
January 13, 2025
Question

spreadsheet sync unprotect sheet password

  • January 13, 2025
  • 1 reply
  • 0 views

I am having an issue with spreadsheet sync and being able to sort a column a-z when editing records for the chart of accounts. 

1. I am signed in to the spread sheet with my QBO account and have synced the data.

2. I am able to change the information in the cells and sync it back to QBO. This is for editing chart of accounts.

 

What I am needing to do is sort the chart of accounts by account number as I have several that need to be made into sub accounts and some modifications to account type. When I click the little gray triangle to bring up the dropbox and tell it to sort A-->Z I get a message stating "The cell or chart you're trying to change is on a protected sheet. To make a change, unprotect the sheet. You might be requested to enter a password."

 

I have followed instructions on other forums by going to Review--> Unprotect sheet and it has a password box pop up. However, my QBO password will not unlock the sheet. I have tried my computer password, office 365 password, computer pin, and every possible password combination I would have ever used and it keeps stating the password is incorrect.

 

Is there a different password that is used to unlock that sheet? I absolutely cannot figure out what it would be unless it is some other kind of generic password. If not, is there a way to somehow sort these by account number? Doing it in QBO itself will work if I want to change them one at a time, but even then any time you make a change to something it takes you to the top of the list after each individual edit which is super annoying. Any advice would be very helpful.

1 reply

EduardA
EduardA
January 13, 2025

We appreciate you performing some steps to unlock the cell or chart on your spreadsheet, dkessler417. This isn't the experience we want you to have when managing your chart of accounts.

 

Let me share with you a way to modify your chart of accounts using the Batch edit feature so you can manage multiple accounts smoothly and efficiently.

 

Here's how to do it:

 

1. Click the pencil icon on your Chart of accounts tab.

 

 

2. Edit the NUMBER or NAME of the accounts, then hit the Save button.

 

 

On the other hand, please be aware that only an Admin can access the spreadsheet sync. Kindly ensure you have Admin login credentials to use it. If you're not an Admin, reach out our Spreadsheet Sync team for assistance. 

 

Our committed Spreadsheet Sync team is available to help you from Monday to Friday, from 6 am to 6 pm Pacific Time. 

To contact our Spreadsheet Sync team: 

 

1. Kindly sign into Spreadsheet Sync.

2. Select Help, then choose Contact Us.

 

You can also visit this article if you encounter more issues with Spreadsheet Sync: Frequently Asked Questions about Spreadsheet Sync in QuickBooks Online Advanced or Accountant.

 

If you have any additional questions about accessing Spreadsheet Sync, please feel free to leave a comment below.

Terms & ConditionsAccessibility statement