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

Blogs

Blogs

View more

Tag Cloud

View more
Sort By: Most Recent | Most Viewed | Most Commented

  • Excel Links

    First, from the double trademark infringement department, there’s Excel®RainMain®, who says: Whether it’s your homework, day job, or just a new idea, let the Excel Rain Man make your life easier! Submit a Request, inquiries are free! (see How it Works for further details) Pay for homework service? For a fee, I’ll read your lit homework [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Jul 2 2008
    Filed under:

  • To Disable or Not To Disable, That Is the Question

    Joel Spolsky says don’t: Instead, leave the menu item enabled. If there’s some reason you can’t complete the action, the menu item can display a message telling the user why. I thought it was pretty common knowledge that users don’t read message boxes. Anyway, I’m squarely in the disable-menu-items-that-aren’t-applicable camp, and I never hide items. Take the [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Jul 2 2008
    Filed under:

  • Building an Asset Tracking Application in Excel Services – Part 3b of 5

    Today's author, Dan Parish, continues his discussion on building an Excel Services solution. In Part 3a I walked through how to create the SharePoint List that stores the data users enter. In this post, I will walk through how to create the Excel Services User Defined Function (UDF) that will pull this information from the SharePoint List into Excel Services. Overview Out of the box, Excel Services does not support pulling in data stored in SharePoint Lists. However, you can add this functionality...
    Posted to The Excel Team Blog by Microsoft Excel on Tue, Jul 1 2008
    Filed under: ,

  • COUNTIF SUMIF Limitations

    I'm sure many of you knew this but it was new to me and I came across it today, so in an effort to get it out there a bit more, i document it here. It concerns the fact that COUNTIF and SUMIF (and their 2007 plural counterparts SUMIFS and COUNTIFS) carry forward the limitation that Excel has of 15 significant digits. (As does 1-2-3 and OpenOffice) http://support.microsoft.com/kb/269370 I knew this limitation, but didn't realise the two functions concerned followed this limit' I had to...
    Posted to Nick Hodge's Excel Blog by Nick Hodge on Fri, Jun 27 2008

  • Identify Empty Cells in VBA

    Whenever I need to determine if a cell is blank, I call the IsEmpty function on the Value property. If IsEmpty(ActiveCell.Value) Then This anonymous blogger uses vbNullString. If ActiveCell.Value = vbNullString In other news: In Firefox, Cntl+Click on a hyperlink and it will open that link in a new tab. Except for the aforementioned blog's heading. [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Jun 26 2008
    Filed under:

  • Some links to useful sources

    A new and time consuming project keeps me busy so at present I don’t have the time to post here on a regular basis. Anyway, the following links points to several recently published articles by MSFT. Finally, the version 1.0 of Open XML Format SDK is released. It provides us with new tools to interact with the XML [...] Read More...
    Posted to XL-Dennis's Blog by VSTO & .NET & Excel on Wed, Jun 25 2008

  • Community Clips

    The folks over in Office Labs are testing out a new idea called Community Clips and I, personally, think it's a fantastic idea. It's a community site where anyone, not just Microsoft employees, can upload "how to" videos that take you step-by-step through accomplishing a particular task. Think of it as YouTube meets Office Online . If, like me, you're a visual learner, this is a great way to learn new tips and tricks on how to do any number of things with Microsoft products...
    Posted to The Excel Team Blog by Microsoft Excel on Wed, Jun 25 2008
    Filed under:

  • Create a QueryTable from an Excel Source in VBA

    Elton is trying to create a QueryTable based on a named range in a closed Excel file. When the code tries to refresh the QueryTable object, he gets an SQL Syntax Error message. Although he's sure his SQL syntax is correct, it's almost certainly not. The syntax you get from the macro [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Tue, Jun 24 2008
    Filed under: ,

  • Using an Analysis Template — Updating the data source

    The motivation for this quick and incomplete draft was Dick Kusleika’s post on distributing/communicating a PivotTable template (http://www.dailydoseofexcel.com/archives/2008/05/21/pivottable-markup-language/). In the approach I’ve adopted for the past few years, the basic idea is to separate the data from the analysis and presentation. Then, a simple piece of code lets one update the data connections in [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Sat, Jun 21 2008
    Filed under:
  • Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Jun 20 2008

  • Excel Blog Happenings

    The Contextures Blog has moved off of the wordpress.com domain and onto the contextures.com domain. Check it out if you haven’t, update your feeds if you have. PTS Blog is holding a contest for physics and engineering spreadsheet models. Since I’ve mentioned it on my blog, I get to submit six entries. I’m [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Jun 18 2008
    Filed under:

  • On-the-fly data entry form

    Hi all, So after Dicks (nice to read) rambling on golf, let’s do some Excel/VBA stuff again. I intend to get a bit of discussion on this one, so bear with me. I’m currently developing an Excel workbook for a customer. One of the interesting things with this project is that it consists of multiple data tables, each [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Jun 18 2008

  • Alive and Well

    Howdy. It’s been quiet at the ol’ DDoE lately, but I thought I would check in and let you know I’m still around. I generally slow down a little in the Summer, but this Summer has been surprisingly busy. I have some nice Excel posts in the queue. In the mean [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Jun 18 2008
    Filed under:

  • Building an Asset Tracking Application in Excel Services – Part 3a of 5

    Today's author, Dan Parish, continues his discussion on building an Excel Services solution. Part 3 turned out to be a bit longer than we had anticipated so we've split it up into two parts: 3a and 3b. Thus far in this series, I have given an overview of the solution , and detailed how to build the Excel workbook that is the core of how it works. In today's post, I will walk through building the SharePoint List that users will input their machine information into. Overview In order to...
    Posted to The Excel Team Blog by Microsoft Excel on Tue, Jun 17 2008
    Filed under: ,

  • Settling Debts

    You owe me $325.00 as of 1-June. Instead of paying me, you note that I will owe you $778.00 on 12-July and that we should just settle up then. I, being an accountant, suggest instead that we settle up on 10-Aug. Here’s one way to find that date: Start by setting up a [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Jun 6 2008
1 2 3 4 5 Next > ... Last »
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.