Can I use an Excel xlam add-in if I switch to Linux?

If this is for healthcare work, first check whether your employer can provide a Windows device with Excel and the add-in already supported. Then you can use Linux on your personal computer without making the work setup your responsibility.

Also check the rules before moving any work files or data to a personal machine. Patient information may be subject to privacy requirements and your employer's security policies.

You could run Windows in a virtual machine on Linux and install desktop Excel and the add-in there. That avoids rebooting every time you need the spreadsheet, though you'll need a Windows installation and any required licenses. Check that your employer permits this setup and test the actual workbook and add-in before relying on it for work.

Dual boot is another option if a virtual machine doesn't work well enough. The tradeoff is that you have to restart to switch between Linux and Windows.

Don't assume the browser version of Excel will run the add-in. An xlam file is an Excel add-in, and a workflow that depends on its desktop features may not work in the browser or another spreadsheet application. Check the add-in's documentation and test its actual functions before making the switch.

For the statistics themselves, R or Python might be an option on Linux. That's not a drop-in replacement for the xlam file, though. Someone would need to recreate and verify the calculations, and any work requirements around the results would still apply.