Skip to main content
Portfolio Manager Help Center home page Portfolio Manager Help
Submit a request Sign in
  • Portfolio Manager

The spreadsheets are locked - how do I filter, sort, insert, delete...?

  • October 18, 2024 15:40
The Spreadsheet Upload files are in "protect" mode so that users can't inadvertently delete columns or make other changes that can cause a problem.

If you want to change this setting in Excel to filter, sort, insert, delete, etc: 

  1. Go to the Worksheet that you want to unprotect
  2. Click on the Review tab on the top
  3. Click "Unprotect Sheet"

 

Related articles

  • Is there a limit on rows using the spreadsheet templates?
  • Standard IDs in Portfolio Manager for Canada
  • How do I Copy and Paste Data into my Meter?
  • How Do I Download My Custom Meter Data?
  • I want to upload meter bills for 2 different meters, but I don't have the same number of bills.

Was this article helpful?

Articles in this section

  • How do I use the spreadsheet uploads?
  • Step-by-step instructions: add properties using spreadsheets
  • Once I've downloaded my portfolio and made some changes to it, is there a way to easily upload all of this data again?
  • Update Use Details - Common issues
  • Do you have any troubleshooting tips for upload spreadsheets?
  • "Add Meters to Existing Properties" - different meters for each property
  • Can I reuse a template that I previously generated?
  • Can I reverse a spreadsheet upload once it has posted with a status of "success"?
  • I'm getting an error about numeric values for dates when uploading.
  • The spreadsheets are locked - how do I filter, sort, insert, delete...?

See all 13 articles

Login to Portfolio Manager