Very impressive. I’m curious if there’s any formula optimization that could be done to speed up the processing, but as someone who’s dealt with such nightmare sheets I expect not. Excel can just...
Very impressive. I’m curious if there’s any formula optimization that could be done to speed up the processing, but as someone who’s dealt with such nightmare sheets I expect not. Excel can just take forever when you’ve got references on references on references.
I did cringe when he implied he blew up his main sheet more than once as I know that lesson sucks to learn the hard way. And I feel like there might have been a better solution for writing to memory if you wanted to avoid python but probably would’ve made the whole thing unbearably slow
Its on the online/one drive version and you can turn it on for the desktop version (which then uploads it up), but like many things with excel, most people don't know about it or have various...
Its on the online/one drive version and you can turn it on for the desktop version (which then uploads it up), but like many things with excel, most people don't know about it or have various reasons for not using it.
Very impressive. I’m curious if there’s any formula optimization that could be done to speed up the processing, but as someone who’s dealt with such nightmare sheets I expect not. Excel can just take forever when you’ve got references on references on references.
I did cringe when he implied he blew up his main sheet more than once as I know that lesson sucks to learn the hard way. And I feel like there might have been a better solution for writing to memory if you wanted to avoid python but probably would’ve made the whole thing unbearably slow
I'm surprised Microsoft hasn't added versioning with rollbacks to Excel.
Its on the online/one drive version and you can turn it on for the desktop version (which then uploads it up), but like many things with excel, most people don't know about it or have various reasons for not using it.
I'd use a local versioning system.
Cloud-based.. I won't