Search Results

Search found 61743 results on 2470 pages for 'excel web query'.

Page 9/2470 | < Previous Page | 5 6 7 8 9 10 11 12 13 14 15 16  | Next Page >

• How do I get excel to close completely after creating a macro in a personal workbook?

  - by Greg B

  I am using Microsoft Excel 2007 and have several macros in my personal.xlsb workbook, which I use often, so it is very convenient that Excel opens them automatically when it starts. What I don't like is when I click on the "X" in the upper right corner of the window Excel does not exit when I close the last visible workbook. I think that this is…

  Read the article

• Step by Step:How to use Web Services in ASP.NET AJAX

  - by Yousef_Jadallah

  In my Article Preventing Duplicate Date With ASP.NET AJAX I’ve used ASP.NET AJAX With Web Service Technology, Therefore I add this topic as an introduction how to access Web services from client script in AJAX-enabled ASP.NET Web pages. As well I write this topic to answer the common questions which most of the developers face while working with…

  Read the article

• Excel macro to change external data query connections - e.g. point from one database to another

  - by Rory

  I'm looking for a macro/vbs to update all the external data query connections to point at a different server or database. This is a pain to do manually and in versions of Excel before 2007 it sometimes seems impossible to do manually. Anyone have a sample? I see there are different types of connections 'OLEDB' and 'ODBC', so I guess I need to…

  Read the article

• Excel macro to change location of .cub files used by pivot tables? (to allow .xls files that depend

  - by Rory

  I often use Excel with pivot tables based on .cub files for OLAP-type analysis. This is great except when you want to move the xls and you realise internally it's got a non-relative reference to the location of the .cub file. How can we cope with this - ie make it convenient to move around xls files that depend on .cub files? The best answer…

  Read the article

• SQL server recursive query error.The maximum recursion 100 has been exhausted before statement completion

  - by ienax_ridens

  I have a recursive query that returns an error when I run it; in other databases (with more data) I have not the problem. In my case this query returns 2 colums (ID_PARENT and ID_CHILD) doing a recursion because my tree can have more than one level, bit I wanna have only "direct" parent. NOTE: I tried to put OPTION (MAXRECURSION 0) at the end…

  Read the article

• Excel trend line intercept

  - by Brian M.

  I have an Excel graph with a linear trend line to keep track of users who are updated with a newer version of software: I have 660 users, and the trend line predicts where the number updated reaches 660 to indicate updates complete. Is there a way for it to either give me an actual value for that intercept, or, more conveniently, draw a…

  Read the article

• Extend the number of rows in Excel 2003 beyond the allowable 65k

  - by dassouki

  I'm stuck with excel 2003 at the office, I was wondering if there is a way to extend the number of rows to at least a million or two.

  Read the article

• Inserting (jpg) pic inside MS Excel 2007 cell

  - by robihot

  Is it possible to insert a jpg image INSIDE a cell .... or do cell ONLY excel alphaNum char (or ref) ?

  Read the article

• Conditional formatting using cell styles in Excel 2007?

  - by romkyns

  Excel 2007 has added support for cell styles, which I find very useful. I love it when I can change formatting in one place and the change propagates throughout the spreadsheet. I also love conditional formatting. Can the two be combined? Can I conditionally apply a cell style?

  Read the article

• Excel aggregate functions to summarise figures against grouped column

  - by Don Vince

  I have a spreadsheet much like the on on this page: Painless Software Schedules I wish to create a summary sheet with the Feature against the totals for that feature of "Orig Est", "Curr Est", "Elapsed" and "Remain". Is there an appropriate Excel feature to generate this summary? Preferably one that will automatically update?

  Read the article

• Excel aggregate functions to summarise figures against distinct figures

  - by Don Vince

  I have a spreadsheet much like the on on this page: Painless Software Schedules I wish to create a summary sheet with the Feature against the totals for that feature of "Orig Est", "Curr Est", "Elapsed" and "Remain". Is there an appropriate Excel feature to generate this summary? Preferably one that will automatically update?

  Read the article

• Excel: automatically update cell

  - by MickTaiwan

  Hello, I'd like to automatically update a Excel cell with the current date and time when another cell is changed (like a update timestamp). Do you have any pointer on how to do that ? Thanks, Mickael.

  Read the article

• Excel showing hidden data?

  - by annakata

  -- Excel 2003 SP3 -- I have a spreadsheet which I know for certain has a large amount of hidden rows which are correctly hiding on my colleagues machines, and were correctly hiding on mine two days ago, but this morning I find the hidden flag is being ignored and all that hidden data is rendered. Is there some checkbox, configuration…

  Read the article

• Use a Trendline Formula to Get Values for Any Given X with Excel

  - by kirkouimet

  Is there an easy way to apply the trend line formula from a chart to any given X value in Excel? For example, I want to get the Y value for a given X = $2,006.00. I've already taken the formula and retyped it out be: =-0.000000000008*X^3 - 0.00000001*X^2 + 0.0003*X - 0.0029 I am continually making adjustments to the trend line by…

  Read the article

• Moved files only opening as 'read-only' in Excel

  - by Lance Roberts

  I moved a large directory of Excel files to another machine. When I sign in as myself (administrator signing into domain) then the files open just fine, but when I sign in as a Power User directly onto the machine, the files open as 'Read-Only'. I've reset all the attributes through both Windows and DOS, but to no avail. Also I…

  Read the article

• How to show a Particular Cell while scrolling in excel

  - by joe

  Here things i want to do .. I am having Colum A...Z I am having data in Row 1..10 A - is Title From B ..Z . I am having differnet values . When i scroll into Z colum is hided . I want to show my A ( title ) all times even if i scrolled . How to acheive this in Excel 2007

  Read the article

• how to add a average line to the graph in excel 2007

  - by pukipuki

  In openoffice I'm getting trend-line and average-line properties by rightclick. But in excel2007 I see only trend-line. How to make a average-line in Excel?

  Read the article

• Excel changing decimal places on number cells when I edit the cell's formula

  - by IanC

  I have a worksheet with thousands of number cells, all formatted "Number, 3 decimal places, use 1000 Separator ()". Starting a few days ago, if I edit a formula in any of these cells to reference another cell, Excel will change the decimal places to 14. For example, "=C$53^$B$4" = "=C$53^$B$10" will cause this. I am not aware…

  Read the article

• Excel 2007 transpose/combine multiple rows into one.

  - by jzd

  I have data like so: 1001NCCN 3618127 1001NCCN 208478 1001NCCN 207316 1001TEMN 409889 1001TEMN 801651 1001TEMN 273134 1001TEMN 208478 1001TEMN 207316 I need to transpose/combine the rows that have matching values in the first column with a final result like so: 1001NCCN 3618127 208478 207316 …

  Read the article

• Automatically update cell in Excel with current timestamp when another cell is changed

  - by MickTaiwan

  In an Excel spreadsheet, I'd like to automatically update a cell with the current date and time when another cell is changed (like an update timestamp). Do you have any pointers on how to do that?

  Read the article

• ASP.NET, Web API and ASP.NET Web Pages Open Sourced

  - by The Official Microsoft IIS Site

  More Open Source goodness from Microsoft today, with the announcement that we are open sourcing ASP.NET MVC 4, ASP.NET Web API, ASP.NET Web Pages v2 (Razor) - all with contributions - under the Apache 2.0 license. You can find the source on CodePlex , and all the details on Scott Guthrie's blog . “We will also for the first time…

  Read the article

• How important is responsive web design?

  - by Daniel

  I've heard many different opinions regarding the pros and cons of responsive web design recently and was wondering whether it was necessary for small businesses that target small geographical areas to implement it? Some sub-questions I have relating to this include: Is it better to use responsive web design as opposed to…

  Read the article

• How to call Office365 web service in a Console application using WCF

  - by ybbest

  In my previous post, I showed you how to call the SharePoint web service using a console application. In this post, I’d like to show you how to call the same web service in the cloud, aka Office365.In office365, it uses claims authentication as opposed to windows authentication for normal in-house SharePoint Deployment. For…

  Read the article

• How to call Office365 web service in a Console application using WCF

  - by ybbest

  In my previous post, I showed you how to call the SharePoint web service using a console application. In this post, I’d like to show you how to call the same web service in the cloud, aka Office365.In office365, it uses claims authentication as opposed to windows authentication for normal in-house SharePoint Deployment. For…

  Read the article

• Ur/Web new purely functional language for web programming?

  - by Phuc Nguyen

  I came across the Ur/Web project during my search for web frameworks for Haskell-like languages. It looks like a very interesting project done by one person. Basically, it is a domain-specific purely functional language for web programming, taking the best of ML and Haskell. The syntax is ML, but there are type classes and…

  Read the article

< Previous Page | 5 6 7 8 9 10 11 12 13 14 15 16  | Next Page >