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.
Sort files in bulk with PowerShell
I want to find more time to learn PowerShell from the ground up. So far I’ve been scripting with it and learning chunks and cmdlets at a time as I need them. For example:
Set Microsoft Office Name for Friendlier File in Use Messages
Has this ever happened to you? At best an annoyance, this can be a real productivity killer as you hunt around to find the user that has the file locked. You could save a copy of the file and try to clean up or reconcile later, and while collaboration solutions like SharePoint limit these cases, most businesses still rely heavily on network storage that…