You can also focus on accurracy and consistency.
With multiple people having their own spreadsheet, each person has their own version of the truth. Each person is likely to defend their version against what other people say.
Is your MD happy to base his business decisions on assertions that could be wrong? People could be showing him information that product A is profitable when it is not, and that product B is loss-making when it is not. And those people would believe 100% in the accuracy of their information. Of they may just believe 100% that their figures are the right information to present, regardless of accuracy.
An MD who is concerned with the long term future of their organisation will want to see accurate figures, regardless of what they say.
Microsoft has gone down the path of using Excel as the main client for their BI products. When Excel is used to prettify information held centrally, it is a very useful tool. When Excel is used to present information stored only within that spreadsheet, it can be an agent of corporate destruction.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara