Never worked with datasets that large. At most a couple of thousands rows spread over half a dozen tabs. Lots of embedded charting.
I saved it in native ODS and told them not to be confused that it wasn't an XLS. Excel had no problems that I ever knew about.
I did NOT try to produce an XLS for them nor use that XML-wrappered proprietary-blob shit Microsoft was peddling as their "open" format.
Maybe i just hit the sweet spot in use cases but I did not exceed it's abilities or have exchange problems.
Edit: I do not recall the versions involved on either side but this was the 2008 to 2012 time frame.
Im thinking of having 2 computers with a shared volume
Problem with that is you're chasing the lowest common denominator. Windows will at some point bite you.
I ditched OS/2 Warp for Linux in 1997 (had my fill with WfW and saw the coming new wave for the shite that it was). Only Windows I kept around was in a VM to run Quicken, and that I kicked to the curb when they switched to a subscription model.
If you HAVE to have MS Orifice a VM sharing a folder in your home dir is workable. But I strongly suggest testing Libre Office to see just how much you can live with it. Leaving Windows feels really good.
Right now Libre Calc is not workable for what I do. I suspect its a new bug because I don't remember having this much difficulty with it 8 years ago.
I'm happy not letting the windows machine on the internet.
(post is archived)