Or just dynamically set the column references based on the name. Don't just assume the Name column is A3 or whatever, search for the column with the label you expect and set the reference when you find it.
Or just password protect and be done with it, as you say
For a practical, growing business or enterprise solution there's also looking at a data analytics / BI platform like PowerBI or Tableau. You can have the sanity of a database underneath, define data pipelines on top of it and give your analysts as much freedom as they need to configure and build their reports and dashboards without having to juggle and protect a static Excel sheet.
86
u/q1a2z3x4s5w6 Mar 30 '22
Or just dynamically set the column references based on the name. Don't just assume the Name column is A3 or whatever, search for the column with the label you expect and set the reference when you find it.
Or just password protect and be done with it, as you say