6 ms·

If the code was stored in source control with a separation between dev and production the intern might be able to raise such a Pull Request but it would never g

If the code was stored in source control with a separation between dev and production the intern might be able to raise such a Pull Request but it would never get approved without oversight from someone more senior. This Code Review process is almost completely impossible in Excel.

pjmlp 6y ago
That is a big if. Office has source control management via SharePoint integration.
- zentiggr 6y ago
  ... and then you have two problems. I have never seen an environment converted to SharePoint that didn't suffer badly from the conversion. And the Excel vs <other language> source control issue isn't history, it's "go ahead and try to diff between two versions of an Excel sheet" vs "diff two versions of that source file". Unless I've never heard of the tool that can digest two Excel sheets and tell you what formulas differ, or cells. Please correct me, anyone who knows of one.
  - pjmlp 6y ago
    https://support.microsoft.com/en-us/office/overview-of-spreadsheet-compare-13fafa61-62aa-451b-8674-242ce5f2c986?ocmsassetid=ha103516135&assetid=ha103516135&correlationid=b05c49f6-658b-43d0-ac33-4e38230c83b5&ui=en-us&rs=en-us&ad=us https://support.microsoft.com/en-us/office/overview-of-sprea...
    - zentiggr 6y ago
      Late response over the holidays, but honestly thank you. In years of Excel usage, I've never stumbled on that or had anyone mention it. I will look into that as Excel 2016 is one of my current required work apps.
- etothepii 6y ago
  An excel tool that showed you formula differences sounds like a cracking idea for a startup.