I can't help you really but decide where the master data lives - in the spreadsheet or in the DB? Try and move it into the DB, so it needn't touch the spreadshe

I can't help you really but decide where the master data lives - in the spreadsheet or in the DB? Try and move it into the DB, so it needn't touch the spreadsheet unless you want to only look at it in the spreadsheet, never alter it there. DBs handle and manipulate data better far better than excel. Excel does data presentation better. A decent DB, well looked after and backed up, is the safest place for any quantity of data. Spreadsheets are not - excel is not reliable once you start filling it up and doing complex updates. So that's my advice. Of course your needs and workflow may not fit that at all well, so YMMV! Thanks for the opinion on mssql vs postgres.