Mention the INDIRECT function in an Excel forum and you'll start a fight. It's volatile, meaning it's always awake and recalculating, which can turn a fast spreadsheet into a sluggish mess. But used ...
Hosted on MSN
These 5 Excel functions are silently slowing down your spreadsheets — use these instead
Excel is pretty smart about how it handles updates. It builds a dependency tree, essentially a map of which cells rely on others, and uses it to recalculate only the cells that need updating. When you ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results