Create Before/After Query Update Events Returning a web query can be very handy. Unfortunately if you want to run any code when this refreshes, there's no native way to do this. We can, however, create an event for this with a few short steps. This will all be done inside the Visual Basic [...]
Delete Duplicate Emails via MS Excel VBA Need: Do you have the need to delete duplicate emails from Microsoft Outlook? Perhaps you have accidentally created hundreds of duplicates, and your pst file is so vast you do not have the time nor the energy to remove each of them manually. In this case it [...]
Data Explorer for Microsoft Excel 2010 There's a new add-in for Excel called Data Explorer. Currently it's in preview (beta), so use at your own discretion and risk. What is it? Well the name really does say it all – it lets you explore data. Think of the current mechanisms we have in [...]
MS Excel Pivot Table Deleted Items Remain - Fix Microsoft Pivot Tables & Pivot Charts should be in every data visualization toolbox as they are one of the most powerful reporting and analysis features in Microsoft Excel today. New to Pivot Tables, Pivot Charts, & Slicers, we can help 877-392-3539. The Problem: [...]
Microsoft Excel 2013 Templates TEMPLATES Have you seen them? Well, if you have Excel 2013 there's no doubt you have, because it's the opening screen when you open Excel now. Microsoft took a new direction in their featured templates, and has developed hundreds of them which are useful and time-saving. When Excel is opened [...]
