Excell expert required

Excel expert required to refine and maintain a complex workbook. The spreadsheet contains pre-populated, locked formulas that automatically populate other tabs. Required: advanced Excel skills, experience with protected sheets, formula auditing, error-tracing, named ranges, and data validation. Tasks include troubleshooting formula conflicts, optimizing performance, documenting logic, and implementing secure, user-friendly adjustments without altering locked formulas. Deliver clean, reliable workbook updates and clear notes on changes made.

The first tab needs to be read carefully so you understand how the spreadsheet is structured. Read it before sending a proposal or proposal will be rejected

issue encountered earlier today:

A.4 SME owners and natural person beneficiaries" is not generating value and returning "#N/A" on some of the BE sheets. There's no way to override this cell as it's password protected causing the other sum formula not to work.

Probably worth noting that you'll need a unit of 1 in cell B139 when it's working if you want that figure pulled through on the instructions.

https://docs.google.com/spreadsheets/d/1hKJZy6109TunFJcgyYAkM1u-YFmkHlae/edit?usp=sharing&ouid=103049385258346436119&rtpof=true&sd=true

or orginal file : https://docs.google.com/spreadsheets/d/1S_lcV291XSQEL93LDM6X6jUsRglga9Bk/edit?usp=sharing&ouid=103049385258346436119&rtpof=true&sd=true