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

October 2007 - The Excel Team Blog

Sort by: Most Recent | Most Viewed | Most Commented

  • Excel Services: Combining the EWA and API using AJAX

    Today’s author: Dan Parish, a program manager on the Excel Services team. Dan is going to walk through how to enable cell editing in Excel Services using a little code. The post assumes some base knowledge of Excel Services. Today I'm going to show how, through a combination of the EWA and API, you can enable editing of any cell in Excel Web Access (EWA) via JavaScript. Before we start, I'd like to recap a few things about the EWA: The EWA is the web part component of Excel Services that...
    Filed under:

  • Excel 2007 Web Data Add-In

    Some folks at Microsoft Research have developed an add in that makes it easy to use a Web page as a data source in Excel. Here is a brief description: The Excel 2007 Web Data Add-In provides an intuitive user interface for importing textual data from any given webpage via a user’s selections of interest, such as stock quotes, weather temperature, ect, into a spreadsheet and keeping that data “up-to-date”. That is, if the webpage data changes, the spreadsheet can be updated by a click of the data...
    Filed under: , ,

  • Calculation Issue Update (Fix Available)

    Two weeks ago, we posted about an issue involving the calculation of numbers around 65,535 and 65,536. As of today, fixes for this issue in Excel 2007 and Excel Services 2007 are available for download from the following locations: Excel 2007: http://download.microsoft.com/download/6/1/3/61343075-aa12-4152-a761-fccc16d6cef4/office-kb943075-fullfile-x86-glb.exe 64-bit Excel Services 2007: http://download.microsoft.com/download/c/d/c/cdcccd84-86cd-4199-b01c-1df2dac66534/office-kb943076-fullfile-x64...

  • Data Bars – Feedback Please

    Today’s author: Scott Ruble, the program manager who leads the charting and visualization efforts in Excel. Scott is looking for some feedback on potential changes to data bar behaviour. Excel 2007 has a conditional formatting feature that graphically displays bars in a cell to represent the value of the cell. This feature is called Data Bars. You can see an example of this by using the following steps: In Excel 2007, enter 1, 2, 3 in cells A1, A2, and A3 respectively. Select cells A1:A3. From the...
Copyright Excel User Group and the relevant contributors, 2009. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.