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


  • Editing in Excel Web App – Part II

    Today I’m going to continue on with our baseball stats tracking workbook example and talk more about the editing capabilities in Excel Web App. If you haven’t read Editing in Excel Web App – Part I though, I suggest you check it out first. Working with your data So now you’ve got a great looking workbook with lots of data and formulas. You send it out to your team and are sure that everyone will love it, and they do…sort of. Your team is picky. They want to “analyze” the data. The want to easily...
    Posted to The Excel Team Blog by Microsoft Excel 2010 on Mon, Jan 18 2010
  • Product Planning in Office 2010

    My name is Scott Gordon – I am the Group Product Planner for the Microsoft Business Division. My team and I work closely with the Office engineers to represent the voice of you, our customers, in the product development cycle. How do interactions with customers represent your voice in our product development efforts? Our approach reminds me of an experience a friend of mine had a while ago as a SCUBA instructor. He was asked by a team of animators how to SCUBA dive. They were preparing to create...
    Posted to Office 2010 Team Blog by Microsoft Office 2010 Engineering on Mon, Jan 18 2010
  • Friday Link Dump

    Cloud Excel Excel Web App 2010 Overview Editing in Excel Web App – Part I I haven’t used the web app yet, so take my comments in that light. Fidelity appears to be the word of the hour. Clearly MS thinks it’s important, but I’m not so sure. I don’t expect my bank’s website [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Jan 15 2010
    Filed under:
  • Editing in Excel Web App – Part I

    Thanks to Dan Parish for putting together this series on editing in Excel Web App. Before I get started, if you haven’t already read our Excel Web App 2010 Overview , you may want to take a minute to get acquainted with what Excel Web App is all about. In the next two posts I’m going to be talking about the editing capabilities of Excel Web App, and I’ll use the example of creating a simple baseball stats tracking workbook throughout so that you can see how all of these capabilities come together...
    Posted to The Excel Team Blog by Microsoft Excel 2010 on Fri, Jan 15 2010
    Filed under: ,
  • Problems related to KB973475 and KB973593

    Hi All, Many users (including customers of mine) have experienced trouble with two recent security updates by Microsoft, see: http://support.microsoft.com/kb/973475 and http://support.microsoft.com/kb/973593 There seem to be two hotfixes to this problem: KB973475 Excel 2003 hotfix package : http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=978908&kbln=en-us KB973593 Excel 2007 hotfix package : http://support.microsoft.com/default.aspx?scid=kb;EN-US;978522 If you experience problems with...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Jan 14 2010
    Filed under: , , ,
  • Capitalizing Web Addresses

    In written correspondence, which is best: dailydoseofexcel.com DailyDoseofExcel.com DailyDoseOfExcel.com www.dailydoseofexcel.com www.DailyDoseofExcel.com www.DailyDoseOfExcel.com http://dailydoseofexcel.com http://DailyDoseofExcel.com http://DailyDoseOfExcel.com http://www.dailydoseofexcel.com http://www.DailyDoseofExcel.com http://www.DailyDoseOfExcel.com I personally prefer #1, all lowercase and no unnecessary prefix. But I think I’m in the minority. One of the capitalized ones is probably...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Jan 14 2010
    Filed under:
  • Opening Files on Startup

    Let’s say that you want to open a specific file when you start Excel. Here are some options: XLSTART If you have Excel installed, you have a folder called XLSTART. Mine’s here C:\Documents and Settings\Dick\Application Data\Microsoft\Excel\XLSTART. On my Windows 7 machine running Office 2010 Beta, it’s here C:\Program Files\Microsoft Office\Office14\XLSTART\. (Are we putting [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Jan 13 2010
    Filed under: ,
  • 2009 in Review

    Top 10 Page Views in 2009 Post Page Views Creating CSV Files 33,947 Sumif Between Two Dates 19,336 Number Stored as Text 15,003 Writing to a Range Using VBA 12,165 Automating Internet Explorer 11,248 Progress Bar 11,212 Testing for Empty Cells 10,581 Pattern Matching 9,665 Calculated Fields in Pivot Tables 9,321 Maxif Minif Functions 8,162 Most Viewed 2009 Posts Post Page Views Vlookup on Two Columns 6773 Vlookup 2695 Get the Path to My Documents in VBA 2258 Excel Sample Data 2230 Reading Xml Files...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Tue, Jan 12 2010
    Filed under:
  • The New Slide Show in PowerPoint 2010

    Lately, the PowerPoint Team has been writing a lot about the new slide show experience. Transitions, animations, and video will look better and run smoother in PowerPoint thanks to the brand new rendering pipeline that ships with PowerPoint 2010. This recent post highlights the differences between this new, hardware-accelerated engine and the old engine that runs in PowerPoint 2007: The purpose of this upgrade is to enable you to create more visually stimulating slides and tell a more compelling...
    Posted to Office 2010 Team Blog by Microsoft Office 2010 Engineering on Tue, Jan 12 2010
  • Excel Web App 2010 Overview

    Thanks to Steve Tullis for putting this together. Way back in November 2009, I wrote a short blog post announcing the two browser-based solutions the Excel team is delivering as part of the Office 2010 wave of products: Excel Services: Version two of our real-time, interactive, Excel-based reporting and dashboard capabilities which ship as part of SharePoint Server 2010. Also included are APIs which enable rich business application development. Excel Web App: The companion to the Excel client which...
    Posted to The Excel Team Blog by Microsoft Excel 2010 on Mon, Jan 11 2010
  • New Year’s Resolution: No More Offset

    On Simon’s blog, sam comments regarding OFFSET vs. INDEX: There is a huge performance hit. … You will notice hardly any difference in the Calculation times But the recalculation times will significantly different in case of OFFSET- to the tune of 25-30 times slower compared Index. I’ve heard this many times before, but I guess I’m just lazy. I’ve [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Jan 7 2010
    Filed under:
  • Office 2010: Accessibility Investments & Document Accessibility

    My name is Larry Waldman -- I am a Program Manager on the Office User Experience team and have been working in this role to make Office more accessible for almost 5 years. When users of Office hear that Microsoft has many people working specifically to make our products more accessible to people with disabilities, many express surprise. With such a broad customer base, we recognize the importance of considering accessibility impact in every feature we build. For example, check out this article I...
  • Report statistics about a Set of Workbooks

    Today’s contributor is Sarah Hothersall, Liaison Director at Lyquidity. She’s providing information about the Workbook Statistics add-in, a free tool for Excel users that was created by Sandy Marshall, a Product Manager at Lyquidity, who is in charge of development of ComplyXL for enterprise spreadsheet management. To download this add-in, visit http://www.lyquidity.com/workbookstatistics . Sometimes it is helpful to report statistics about a set of workbooks contained in a folder. You can use this...
    Posted to The Excel Team Blog by Microsoft Excel 2010 on Thu, Jan 7 2010
    Filed under:
  • Updated Excel Services Web Services API in SharePoint 2010

    Thanks to Christian Stich, the founder of Excel Services Consulting, L.L.C. , for putting together this post on the updated Excel Web Services API. The Excel Web Services API that initially shipped with Excel Services 2007 has been updated and expanded for Excel Services in SharePoint 2010. I will address the additions and changes for the Excel Web Services API for SharePoint 2010 in this post. Additional information about the Web Services API covering the 2007 implementation can be found in the...
  • What the Office team will be talking about at CES

    Heading into the new year, the Microsoft Office team is motivated more than ever by what we’re hearing about customers’ experiences with Office 2010. Many people think Office is just for the workplace, but millions of people are using Office at home, at school and for their small businesses to get things done. For instance: According to the NPD Group, Office Home and Student was the number one selling PC software product -- including games! -- at retail in the U.S. during the week of Black Friday...
    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.