I hate windows. But I have to use it for work. The worse it gets, the more I want to break free completely, minimise my exposure to this OS. The only part I truly cannot do without I think is Microsoft Excel.

Replacing with Excel 2016 or only using webversion or so is insufficient for sure, for work it needs the SharePoint/auto save etc etc stuff. Also power query getting data from SharePoint online.

Replacing with Libreoffice or so seems completely impossible, there’s too many ‘special’ files in organisation, with .xlsm macro mess, I don’t control all that, I can’t fully steer away from such mess but need full functional access.

Other than Excel, I think I could do all my work from a Linux desktop.

Is it possible by now, reliably working in an up to date excel from a base system Linux? What is the way? Have people done this? How? Do I need to run a virtual machine with win11? How do I do that? Does anyone here have experience with it? I have high degree of control over work devices and boss couldn’t care less, as long as I can get my work done.

Thanks and sorry if this is the wrong community for this question (where would it belong better?)

  • BananaTrifleViolin@piefed.worldEnglish
    11·
    1 day ago

    So on my linux PC, I have made a KVM (Kernal Virtual Machine) using QEMU and made a Windows 11 machine inside it (and I bought a digital license for it), which I have work office and email set up. I personally only need to use it occasionally. If you give it enough resources it works decently & runs all windows software; although as it doesn’t have a dedicated graphics card it won’t look as slick as native windows 11 machine and run GPU intense software well (you can get it it’s own dedicated video card and pass it through but really isn’t worth it for just using Excel). It means I can main linux but use Windows occasionally if I really have to. It means you can have a full Windows machine with work Microsoft account set up for Office, One Drive etc - depending on your employers policies of course. You can cut down the resources you allocate it if you want to be switching between the Windows machine and other software in Linux, but Windows can be laggy without enough resources as it’s so poorly optimised.

    There are sites that guide on setting up a windows 11 machine in linux, but essentially you need to install KVM modules and Virtual Machine manager in linux (available on all distros). You do need to access your PCs bios to ensure the settings that allow virtual machines to access the CPU are on (slightly different name between AMD and Intel CPUs).

    Then you create a machine in Virtual machine manager, give it plenty of resources (especially if the idea being when you use it if it’s the only think you’ll be doing, give it access to most of your CPU cores and the majority of your RAM), and create a decent size virtual hard drive file (I’d say minimum 128gb or more as Windows is bloaty - you can set the virtual drive file size to be flexible so it has a max size but the actual file size is only what is used by the guest system but some file systems still use the whole space unfortunately; not sure how Windows behaves). Download the Windows 11 installer ISO, and then add that file as a virtual CD drive for your guest machine, boot the guest machine, and you should get the Win 11 installer. The VM can only see the virtual hard drive file, so you can install Win 11 safely onto the drives it sees with no risk to your PC. Then reboot and you should have a new Windows install; test it - if it works, buy a digital license (if you want…) and install Office using your 365 account OR if you have old CDs then pass those through to the virtual machine and install as on any Windows PC.