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

Blogs

  • Interim Solution: COM Shim Wizard for Excel 2010 64-bit

    For some days ago Misha Sheerson published an article about using the present version of the COM Shim Wizard for the coming Excel 2010 64-bit. This is an iterim solution and we should expect a new updated version of the COM Shim Wizard when Excel 2010 has been launched. I must admit that I have been [...] Read More...
    Posted to XL-Dennis's Blog by VSTO & .NET & Excel on Fri, Feb 26 2010
  • Listing Formulas

    This code will list all the formulas in the selection in the Immediate Window. Sub ListFormulas()         Dim rCell As Range         If TypeName(Selection) = "Range" Then         For Each rCell In Selection.Cells             Debug.Print String(4, " ") & rCell.Address(0, 0), rCell.Formula         Next [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Feb 26 2010
    Filed under:
  • Drawing in Excel

    Brad sent me a link to this cool YouTube video http://www.youtube.com/watch?v=4YG_WWZYqUs Libro1? Is that Italian Excel? Then there’s this: http://www.youtube.com/watch?v=8oR1_PA3yTw And you thought 3D charts were useless. Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Feb 25 2010
    Filed under:
  • Scatter charts with PowerPivot

    Rob over at http://powerpivotpro.com has a interesting post on scatter charts and PowerPivot: At right is a list of all chart types in Excel. But not all of them are supported as PivotCharts. Try to use XY (Scatter), Bubble, or Stock as a PivotChart, and you’ll get an alert saying you cannot create it with pivot data. So, do you give up? Nope. Remember the post where I converted a PivotTable to Cube Formulas using that button on the ribbon? This is a wonderful opportunity to use that feature in an...
    Posted to The Excel Team Blog by Microsoft Excel 2010 on Wed, Feb 24 2010
    Filed under: ,
  • Sheet Tab Colors

    CR rants: One thing about Excel 2007 that really bugs me are the tab colors. Most of the choices look so washed out, rather than a nice solid color. One does not have a choice when Excel makes the tab text white or black. Sometimes, Excel chooses a white font for the text [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Tue, Feb 23 2010
    Filed under:
  • Populate TreeView Control with Tables and Columns from MS Access Database

    Introduction Populating TreeViews controls with some data is a common task in various type of applications. One common task is to let an application scan disks for folders and files and then populate a TreeView control with the data in a hierarchical way. In the following example all the tables and their columns from a MS Access database will be added to a Treeview control. [...] Read More...
    Posted to XL-Dennis's Blog by VSTO & .NET & Excel on Tue, Feb 23 2010
  • Understanding 64-Bit Office

    Microsoft Office 2010 marks the first time Office will be shipping in both 32-bit and 64-bit versions. With Windows 7, you have the option of running 64-bit Windows on your 64-bit PC, and now with Office 2010 you have that same choice. As 64-bit processors and operating systems are becoming the standard for systems ranging from servers to desktop computers, 64-bit Office will be able to take advantage of everything that 64-bit systems have to offer. Some users need greater memory capacity, and those...
    Posted to Office 2010 Team Blog by Microsoft Office 2010 Engineering on Tue, Feb 23 2010
  • Office 2010 and AppV 4.6

    Today, over on the MDOP BLOG , we announced the release of the next version of Microsoft Application Virtualization (4.6) as part of MDOP 2010 (Microsoft Deployment Optimization Pack).  From Takeshi Numoto, Corporate VP in Office: “App-V 4.6 provides Office customers with a robust set of features to tackle core challenges including application upgrade, application coexistence, and user readiness. It’s an exciting, powerful new way for IT to deliver Office 2010 quickly without impacting user...
  • New RDBMail Mail add-in for Excel/Outlook 2007-2010

    Hi all FYI I upload a new add-in named RDBMail for Excel/Outlook 2007-2010 this week http://www.rondebruin.nl/mail/add-in.htm The add-in create a new tab on the Ribbon named RDBMail with a lot of mail options and a option to insert a worksheet template to your workbook so you can send more then one mail with one click because the info for each mail [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Sun, Feb 21 2010
    Filed under:
  • Consolidating Timesheets

    PHD did a post recently about consolidating data. I do this every other week with timesheets, so I thought I’d share my story. I get timesheets as Excel workbooks via email and I save them to a special folder. I open them one-by-one and record the data on a summary sheet. Here’s the main [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Feb 19 2010
    Filed under:
  • Learn about InfoPath 2010 in free web casts with the Microsoft Product team!

    Do you want to learn about InfoPath and SharePoint 2010 in FREE Web casts with the InfoPath product team? Then sign up for the InfoPath 2010 Academy Live Series . There are 3 remaining sessions in the series. The next session “ Building SharePoint Applications with InfoPath 2010 ” will take place on Wednesday, March 10th from 8:30 AM to 10:00 AM (PST). If you missed our 1st session, “An introduction to SharePoint applications using InfoPath 2010”, you can view it on demand here . Just click the Read...
    Posted to Office 2010 Team Blog by Microsoft Office 2010 Engineering on Fri, Feb 19 2010
  • Web Apps

    I came across a couple of interesting web applications recently. The first is AccountingASAP.com. Offering free invoicing is a great way to get their name out there and encourage users to check out their for-pay stuff. It reminds me a little of the free version vs. pro version model, but there are differences. [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Feb 18 2010
    Filed under:
  • Windows Touch & Excel 2010

    Thanks to Robin Wakefield for putting together this post on touch. With the new Windows 7 Touch platform you now have the ability to interact with applications by touching the screen. This paradigm is a huge success in the mobile market and as the hardware evolves, applications utilizing touch input will become more broadly available. We will likely begin to see touch as the primary interaction method for some PCs such as wall mounted displays used as a kiosk as well as to enhance the experience...
    Posted to The Excel Team Blog by Microsoft Excel 2010 on Thu, Feb 18 2010
    Filed under: ,
  • Office 2010 Application Compatibility Sweepstakes

    Since announcing our public Beta , many folks on the Office team have been hard at work engaging with pre-release testers to find and fix any potential deployment issues IT departments may face with existing Office solutions once Office 2010 is released.  In addition to engaging on specific developer features like UI extensibility , we also started the Office 2010 Application Compatibility Program – here are excerpts from this blog post : With the great value Office 2010 brings for end users...
    Posted to Office 2010 Team Blog by Microsoft Office 2010 Engineering on Wed, Feb 17 2010
    Filed under:
  • OLAP Catastrophic Failure

    I’ve never needed to use an OLAP cube before recently. I’ll admit that I didn’t see what all the fuss was about. But I came upon a problem for which an OLAP worked perfectly. Theoretically. In practice (Excel 2003), I experienced error after error. I rebuilt the cube from scratch several times. [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Tue, Feb 16 2010
    Filed under:
« First ... < Previous 63 64 65 66 67 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.