Refresh Many Excel Reports Automatically
Today I’d like to share a little homemade tool I whipped up to save me the tedious yet trivial recurring chore of opening several Excel workbooks and clicking the Refresh button inside each one.
Today I’d like to share a little homemade tool I whipped up to save me the tedious yet trivial recurring chore of opening several Excel workbooks and clicking the Refresh button inside each one.
Although it seems like every Excel workbook that you open is a standalone instance, Excel is basically still the MDU application it’s always been. The Office team deploys some clever tricks to hide it, but in some situations it becomes apparent. Let’s explore.
Pinning submenu commands to the toolbar not only provides more direct access, but also serves as a status indicator to a state that may otherwise be hidden. For example, now I can tell at a glance the status of my Excel workbook calculations, and change it if necessary before I make an edit that would trigger a lengthy calculation.