Well, to do it, you've got to shut down a lot of automatic facilities and do them on a timer instead.
Make the calculations update manually, lock the worksheet, kill the screen updating, etc.
Once you do that, it's pretty fast. Its automatic the event handling that really slows it down.