-
Excel 2010 - Set Default Template
You'd think that saving a workbook as a template and have that template load automatically when you start Excel shouldn't be that hard, right? You'll ... -
Hide #DIV/0! From Excel Pivot Table
Conditional formatting #DIV/0! within Excel is easy enough, but that doesn't work in Pivot Tables. Luckily, there's an option within Pivot Table options that allows ... -
Excel Lookup - Maintain Date Format
Consider the following spreadsheet in Excel: I wish to perform a lookup on these fields to build a dirty INSERT into SQL list, however when ... -
Delete rows in Excel from a list
I had the need recently where I was provided an Excel XML file containing a large list of SKU's. From this list I queried a ...
