If you only use Excel to occasionally tote up the family budget, you probably don't appreciate how slowly it can run when dealing with massively large spreadsheets. The official Excel Blog looks at a common scenario — making a series of calculations on a very large number of rows — and examines which kind of macro will produce the quickest results. Turns out the obvious approach (moving through the data using an offset) is a lot less efficient than writing some slightly smarter code. Hit the post for the full details.
Make Excel Work Better With Large Data Ranges
Trending Stories Right Now
Speculative fiction is the literature of change and discovery. But every now and then, a book comes along that changes the rules of science fiction for everybody.
I drive a lot of different vehicles when I need to get around, but I'm always a little worried when it's time to fill them up. Will something happen if I use 91 instead of 95, or vice versa? This thread at StackExchange answers the question.