Search Results

Search found 4983 results on 200 pages for 'excel formula'.

Page 26/200 | < Previous Page | 22 23 24 25 26 27 28 29 30 31 32 33  | Next Page >

• Webbrowser locks first Excel Instance

  - by figus

  VB.NET 2008 - WinForms Hi Everyone! I've been looking for an answer to my problem but I only find more questions related to my problem... The thing is that I'm using a AxWebBrowser control in VB.NET 2008 to open a excel file in a WindowsForm, it opens succesfully and everything... but the problem is this: If I had a Excel File Open before…

  Read the article

• Import data from multiple CSV files to an Excel sheet

  - by Chetan

  I need to import data from 50 similar csv files to a single excel sheet. Is there any way to get only selected columns from each file and put them together in one sheet. Structure of my csv files: A few columns exactly same in all the files. (I want them to be in excel) then one column with same column name but different data which I want to…

  Read the article

• Excel Conditional Formatting With Question Mark

  - by kzh

  I would like to use a conditional formatting rule in an excel file that would color any box with a question mark in it red. It seems that Excel is using a question mark as a wild card and will turn all cells with at least one character in them red. How can i escape the question mark? These don't seem to work: "?" \? '?' ??

  Read the article

• Excel Conditional Formatting Escaping a Question Mark

  - by kzh

  I would like to use a conditional formatting rule in an excel file that would color any box with a question mark in it red. It seems that Excel is using a question mark as a wild card and will turn all cells with at least one character in them red. How can i escape the question mark? These don't seem to work: "?" \? '?' ??

  Read the article

• Excel: Edit the XML inside an XLSX file

  - by Andomar

  An Excel XLSX file is a zip archive containing several XML files. I tried to extract all the XML files, and edit xl\connections.xml using an XML editor. That's because I have to change 20+ connections to point to a different server. When I open the edited archive in Excel, it refuses the changes and repairs the file. Is there a way to edit…

  Read the article

• Protecting Excel cell contents.

  - by Avinash

  How to protect Excel cells contents in Excel worksheet and also in its xml file format? I want cells to be read only.

  Read the article

• Automate Excel Text Import Wizard?

  - by Dave Mackey

  I receive files on occasion in a fixed width format. I need to import them into Excel but Excel doesn't perfectly pick up the columns. I can do it manually each time with the Text Import Wizard, but I'm wondering if there is a way to create a "text import template" or something similar - since these files are always the same format.

  Read the article

• Apply or include Excel sheet template in Access MDB

  - by dassouki

  A colleague of mine organizes her data using MSAccess. she outputs the table and pastes it into an excel file (same headings/ columns,,,,). The excel sheet then does some calcs and outputs a summary sheet. Is there a way to automate this process?

  Read the article

• Saving filtered results from an Excel workbook to a CSV file

  - by Niklas Winde

  I have an Excel workbook with a lot of rows in it. I filter it using the values of one column and then I want to save the filtered results to a CSV file. When I do "Save as..." I get all the rows. I can copy paste the filtered results to another sheet and save from there but I'd rather not. It's Excel 2003 primarily.

  Read the article

• Weird Excel bar diagram behaviour

  - by Simon

  Hi I have a very simple question. I wanna have a diagram with the following table Apple 30 40 50 Pears 200 300 400 Bananas 10 20 30 The weird thing, when I try to draw a bar diagram the order of the bars change. So Excel draws me first the Bananas, the the pears and finally the apple bar... Is there anyway to tell Excel 2003 that…

  Read the article

• Weird Excel bar diagram behaviour

  - by Simon

  I have a very simple question. I want to have a diagram with the following table: Apple 30 40 50 Pears 200 300 400 Bananas 10 20 30 The weird thing is, when I try to draw a bar diagram the order of the bars changes. So Excel first draws the bananas, then the pears, and finally the apple bar... Is there anyway to tell Excel 2003 to…

  Read the article

• Excel 2007 Macro Changes?

  - by Guy Thomas

  My excel macros are no longer working as designed. Last week they worked as expected, this week a different result. I even tried a two year old version, it did not work the way it used to. Guy's conclusion an Office / Excel update changed the macro behaviour. Am I alone in this conclusion? If so I'll take a different troubleshooting…

  Read the article

• WebDav Excel 2010 on WinXP

  - by IMHO

  I'm experiencing a problem accessing WebDav directory with Excel 2010 - all files open in read-only mode. I have no problems doing the same with Excel 2003. Any ideas?

  Read the article

• Excel Free Text Survey Question Analysis

  - by joec

  I have to analyse a survey. The survey consists of some yes/no questions, some numeric questions and some questions like the following (free text where respondents have entered multiple answers). Do you have any social networking accounts (Facebook, Twitter, Myspace etc) Y N If yes, which ones _____________________________ Respondents…

  Read the article

• Weird Excel bar disgram behaviour

  - by Simon

  Hi I have a very simple question. I wanna have a diagram with the following table Apple 30 40 50 Pears 200 300 400 Bananas 10 20 30 The weird thing, when I try to draw a bar diagram the order of the bars change. So Excel draws me first the Bananas, the the pears and finally the apple bar... Is there anyway to tell Excel 2003…

  Read the article

• Tracking history in excel.

  - by Vojtech R.

  Hi, there is any possibility to track changes in Excel XP? With time, content and name of editor? Excel is running under just one windows account so system of revisions cant handle name of editors. Thanks

  Read the article

• Excel VBA (2007) Subtotal method of Range class failed

  - by robihot

  I'm getting a Subtotal method of Range class failed Error when I try to run a macro in Excel 2007. Code works GREAT (no errors) when I run it using Excel 2003. Here's a snippet... 'SubTotal Sheet Range("A1").Select Selection.Subtotal GroupBy:=1, Function:=xlSum, TotalList:=Array(3, 4, 5, 6, 7, _ 8, 9), Replace:=True,…

  Read the article

• Make Excel 2007 open hyperlinks in Firefox

  - by skypecakes

  In Excel 2007, when I click a hyperlink, it opens in IE. I'm running XP Professional SP3. Firefox is set as my default browser. Links in Word and Outlook open in Firefox. But Excel opens them in IE. Anyone know how to fix it? Edit: Process Explorer shows the command line for IE to be "C:\Program Files\Internet…

  Read the article

• Embedding an excel sheet in an email

  - by jakecar

  Hello, I'm trying to embed part of an excel sheet into an email. I tried saving the excel file as a .html and then emailing that, but the .html doesn't preserve text colors! Anyone have any ideas? Thanks.

  Read the article

• Recovering password of an Excel spreadsheet file

  - by Roland

  I have a serious bad situation: I have an Excel file that is password protected and I need to access the information asap for a deadline for a project. Are there any good Excel password recovery tools available for Ubuntu that I could use to achieve this task?

  Read the article

• Calculate the sum of numbers in column G of MS Excel sheet

  - by rohit

  When I calculate the sum of numbers in the column G of a Microsoft Excel spreadsheet by using the formula =SUM(G1,G31) ,column G32 prints the date (0-Jan-00). Is there any way in which the sum of numbers in the column G can be calculated? I am using MS excel 2003 SP3.

  Read the article

• Results copied from SSMS splitting across columns when pasted into Excel

  - by adolf garlic

  SSMS 2008 - Excel 2003 This isn't happening all the time, but sometimes when I 'copy with headers' from sql server management studio, the results in Excel look as though I've used the 'text to columns' wizard with 'spaces' and 'brackets' as delimiters, meaning that the results become raggedly distributed across…

  Read the article

• Automatic hyperlink in Excel

  - by developer

  Hi All, Is it possible to hyperlink a url in excel automatically. I mean when the cell starts with something like http or www can I hyperlink that. Currently, I have to hit enter in the cell value in the formula bar to make the link as clickable. Also if I change the value in the cell, the link doesnt get…

  Read the article

• Why can't I "tear" a maximized Excel 2007 window in Windows 7

  - by w4ik

  In Windows 7, in most applications, when an application is maximized...I can "tear" the window (grab the title bar and drag) from it's maximized size and off the top of the screen and then I can drag it to wherever...but when Excel is maximized I do not have that functionality...Is there some trick to…

  Read the article

• Pasting to Excel from Word - stop a Word new line being converted into a new cell

  - by Sean McRaghty

  So I have a table in MS Word which has two columns. In the second column the text is spread on multiple lines, ie I have pressed 'Enter' to achieve this. When I paste into Excel, it converts these separate lines into separate cells. What I want it to do is to keep the lines in the same cell, just on…

  Read the article

< Previous Page | 22 23 24 25 26 27 28 29 30 31 32 33  | Next Page >