Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Blogs

  • What’s Up at DDoE

    Something is spiking memory on my server and MySQL is shutting down as a result. It doesn’t seem to matter how much memory I throw at it, it just maxes out and shuts down. This morning I implemented a plan of shutting down plugins until it happens again. I started with a database reset plugin […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Sun, Mar 9 2014
    Filed under:
  • How do you know if a ListObject is filtered?

    If you try to filter a ListObject, and someone has turned the filter off, then you’ll get an error. But how the heck can you easily test if the filter is on or not? If you fire up the macro recorder, and click the Filter icon a few times to toggle it on and off, […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Sun, Mar 2 2014
  • DataPoint Top and Left for 2007 or earlier.

    Over at Datalabel height and width for 2007 or earlier Andy Pope says: Another couple of properties that are not available prior to 2010 are the Left and Top values of the data point. If you want to know the position of the data point you need to get creative. Having determined the width and […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Feb 26 2014
    Filed under:
  • Office 2013 Service Pack 1 now available

    Today we’ve released Service Pack 1 (SP1) for the 2013 set of Office products including Office 2013, SharePoint 2013 and Exchange Server 2013. SP1 delivers greater stability, expanded functionality, security enhancements and improved compatibility with Windows 8.1 and Windows Server 2012 R2. Office 2013 customers will begin to get notifications of SP1 availability through Windows Update within the next 30 days. Exchange Server 2013 and SharePoint 2013 customers can download SP1 at… Read More...
    Posted to The Excel Team Blog by Office Blogs on Tue, Feb 25 2014
  • Datalabel height and width for 2007 or earlier.

    Over at Chart LeaderLines in Excel 2010 or earlier I posted some code that draws leader-lines on charts just like Excel 2013 does. Unfortunately that title was misleading in regards to the or earlier bit: Eric said that the code isn’t working at all in XL07, and Jon Acampora advised that the DataLabel.Height and DataLabel.Width […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Feb 24 2014
    Filed under:
  • Join us for Tuesday’s webinar: Understanding Power Pivot in Excel 2013

    Struggling with Power Pivot for Excel 2013? Want some tips on how to best work with a data model? During Tuesday’s webinar at 9:15 am Pacific time, Owen Duncan, Senior Content Developer for Power Pivot, will show you the ropes. He’ll walk you through some basics and also teach you some best practices. Read More...
    Posted to The Excel Team Blog by Office Blogs on Mon, Feb 24 2014
  • Data Validation doesn’t care about volatility.

    Huh. All these years I’ve been telling people to avoid volatile functions in models – especially in dropdowns because large chains of dependents usually hang off of these – and it turns out that I’m wrong in that specific case, as per Roberto’s comment in this thread. If you use a volatile function to feed […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Sun, Feb 23 2014
    Filed under:
  • Opening the Addin Dialog like a Pro

    Back in the old days when Excel had menus and toolbars, a guy could use Alt+t+i to open the Addins dialog (Tools – Addins). But that would only work if there was an open workbook. No open workbook, no dialog. Now in the days of the Ribbon, the shortcut is Alt+f+t a a Alt+g (File […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Feb 21 2014
    Filed under: ,
  • Creating an Appointment in Outlook 2010 Installation

    Creating an Appointment in Outlook 2010 Creating an Appointment in Outlook 2010 Part II You can download MGoogleCal.zip Here are the steps to install the code. Download the zip file from the link above Unzip the four files and make a note of where they are Open Outlook 2010 Press Alt+F11 to open the VBE […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Feb 20 2014
    Filed under: ,
  • Creating an Appointment in Outlook 2010 Part II

    Yesterday I posted about replicating how you can enter an item on Google’s calendar in Outlook. Today, we’ll look behind the form to see what’s going on. I won’t cover every piece of code, but you can download the code to see all of it. Let’s start with the Initialize event. In the entry point […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Feb 19 2014
    Filed under: ,
  • Creating an Appointment in Outlook 2010

    I got a new job about a year ago and I went from using Google’s calendar to Outlook. I’ve added some code to Outlook to handle emails a little more like GMail does, but one thing I’ve missed is the ability to add something to the calendar easily. According to Google, you can enter multiple […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Tue, Feb 18 2014
    Filed under: ,
  • Join us for Tuesday’s webinar showing how Office works on an 82-inch touch screen

    Like working on your tablet or smartphone? Imagine one bigger than your TV. Perceptive Pixel by Microsoft delivers exceptional, multi-purpose touch devices for brainstorming, collaboration, and interactive presentations. In this week’s webinar, we'll show you how Excel, PowerPoint, and OneNote work on a 82-inch screen. We start our Office 15-Minute Webinar at 9:15 am Pacific Time, with a Q&A to follow. Click the... Read More...
    Posted to The Excel Team Blog by Office Blogs on Mon, Feb 17 2014
  • The Amsterdam Excel Summit

    A Unique Opportunity Dear Excel lovers, Is Excel the first and last application you use every day? Do you want to improve your Excel skills and get first-hand knowledge from the absolute best Excel experts in the world? Then this unique event is for you. The Amsterdam Excel Summit Worldclass Excel Experts An absolute unique […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Feb 17 2014
    Filed under:
  • Applying NumberFormat Version 4

    I’ve been using a macro to apply the comma style for about five years. I’ve even enhanced it. It’s such a simple bit of code that it really never broke – until now. I got a workbook that caused the code to fail because it didn’t have a style named ‘Comma’. I just assumed that […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Feb 17 2014
    Filed under: ,
  • Instant Pivot: Just Add Water

    Ahem. BEHOLD! Sub InstantPivot() '   InstantPivot: Just Add Water '   Assign this to Ctrl + Shift + P or something like that. '   Description:    * Turns selection into Excel ListObject '                   * Makes a Pivottable out of it at the edge of […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Feb 12 2014
    Filed under:
< Previous 1 2 3 4 5 Next > ... Last »
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.