Search Results

Search found 4866 results on 195 pages for 'excel ranges'.

Page 23/195 | < Previous Page | 19 20 21 22 23 24 25 26 27 28 29 30  | Next Page >

• 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

• 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 Explorer\IEXPLORE.EXE" -Embedding 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

• 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, PageBreaks:=False, SummaryBelowData:=True Any help would be appreciated.

  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 refreshed until I hit enter. Is there a way in excel where it will automatically detect and apply a hyperlink.

  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 columns making them useless I've looked in the 'grid output' query options but can't see anything which may be causing the issue (not sure if this should be on superuser?)

  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 adding this functionality for Excel 2007...I can do it with Word 2007 so it doesn't appear to be Office itself. The machine is a Dell Latitude D820 with the Nvidia Quadro NVS 110M video card...running the latest video drivers...

  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 different lines, ie what would happen if I were to press Alt+Enter in a cell in excel. How would I go about this?

  Read the article

• Amortization Schedule in Excel - Know how much interest will be saved by large payment

  - by hubbas

  I have a really nice Amortization Schedule built in Excel using the steps from this page: http://www.wikihow.com/Prepare-Amortization-Schedule-in-Excel It works really nicely, but I am planning to make some large payments and I would love to calculate how much interest I will save, over the life of the loan, for making these larger payment. E.g., if I pay $10k for one payment I will save $4000 in interest over the life of the loan, etc. Is there a way to calculate this?

  Read the article

• Excel file always opens in Read-Only mode over WebDAV

  - by Robert Koritnik

  I mapped a WebDAV drive in my Windows Explorer. I can access files and browse etc. But. When I try to open my Excel file it always opens in Read-only mode. How do I open a file so it opens with write permissions? I'm sure no-one else is working on the same file. I'm using: Windows Server 2008 Office Excel 2007

  Read the article

• Show only row that follow criteria in Excel

  - by user10826

  Hi, in Excel, how can one filter and just show on the WORKSHEET rows that follow some criteria, for instance, rows that have the value "1" in the second column? In case it can be done, can I add this action somehow to a button on the toolbar? I use Excel for Mac 2008 Thanks

  Read the article

• Excel 2007 import RSS feed

  - by dneeck

  Is there a way to import an RSS feed into Excel. I have a SharePoint site that has a list that I would like to get into Excel for status reporting.

  Read the article

• How can I find out if a cell in Excel contains a number/text or a formula?

  - by Karsten W.

  What I like to do is conditionally format cells depending on whether the cell contains a formula (something starting with "=") or not. Is this feasible in Excel 2007?

  Read the article

• Excel password removal

  - by nkcooke

  We receive Excel workbook files every day which are password protected with the same password. We know this password. Is there a utility or method to remove password protection on these workbook files without invoking Excel.exe or the Excel object. Our goal is to take Excel out of the process and utilize SpreadsheetGear in VB.net. However, SpreadsheetGear can only unprotect worksheets not workbooks. Thanks

  Read the article

• VSTO Excel 2007: Include or embed a Workbook/Worksheet in an Add-in

  - by Sven Sönnichsen

  I want to include/embed an Excel worksheet with a predefined layout in an Excel Add-in, but I cannot add a project item "Workbook" to my VSTO project nor can I add a reference to a "Excel Workbook" project. So how can I do this? My aim is to build an Excel Add-in which adds a new worksheet to an existing workbook (which is a download from SAP) to aggregate data. Sven

  Read the article

• How do I use an ADO.NET managed provider in Excel?

  - by Eli

  I have an ADO.NET Managed Data Provider that is registered in machine.config in DbProviderFactory - It is available for use from, say, Analysis Services, so I know it is correctly registered. However, I need to be able to query the managed provider from Excel, but the managed provider doesn't appear as a choice from Data Link Properties | All Ole Db Providers. How do I get an ADO.NET Managed Data Provider to appear there, or is there another technique I need to use? Thanks in advance, Eli.

  Read the article

• Dataset to excel

  - by Ruben Monteiro

  Hi. I'm developing an application that as to export a dataset to excel, this dataset have 3 tables and the relation between them, I would like to export this to a single excel sheet where for each parent table there is a '+' sign that when expanded shows the child values related to it. To export a single table to excel I know how to do it, but to create this type of relation I have no idea how to do it, do I have to create a macro on the excel file?

  Read the article

• generate excel in java

  - by chetan

  I want to generate excel with enabling auto-filter option.For that I have create one template excel file by enabling auto-filter option but when I write something into that template excel file auto-filter option disabled again. Is there any solution to create excel file by enabling auto-filter option.

  Read the article

• Using excel as UI without VB

  - by 01

  I think every business person would like to have excel UI, however they are forced into using web applications that sometimes look like really bad excel. Are there any frameworks that help build excel ui without VB? I dont mean framework like POI or JExcel that allows you to generate excel reports.

  Read the article

• How to read Excel file using vb.net

  - by Mark

  How to read excel file using vb.net.. I have a code to read the excel file but suddenly it crashes the output when I deleted some rows in excel file.. The deleted rows was also outputted in my coded program. Can anyone help me on how to read excel file and ignore those deleted rows to avoid unexpected null output..

  Read the article

• How to export data to an excel file w/chart on iPhone?

  - by Toby

  Hi, I have some data in a sqlite database in my app, and my client wants an option that allows you to email it as an excel file which includes a chart of the data. Is this possible on an iPhone? Have a good one, Toby

  Read the article

• Error while generating a PDF file with Excel in ASP.NET

  - by l2mt

  I have to generate an excel file and a PDF file from an asp.net application. I'm using the Interop assemblies and I can generate the excel file without any problem. But when I'm generating an pdf file with the add-in SaveAsPDFandXPS.exe I'm getting the next error: Exception HRESULT: 0x800A03EC with a debug I see the error is in the next method which is used to export de PDF file: _objWB.ExportAsFixedFormat(Excel.XlFixedFormatType.xlTypePDF, _nombreArchivo, Excel.XlFixedFormatQuality.xlQualityStandard, false, false, Type.Missing, Type.Missing, false, Type.Missing);

  Read the article

• How to test to see if a computer has Excel installed (any version)?

  - by JPJedi

  I have a windows form application that when it starts needs to see if the user has Excel installed on the computer and if not display a message informing user that part of functionality will be disabled. Is their an easy way to perform this check? Working in Visual Studio 2008 with VB.Net

  Read the article

• How to read excel file in vb.net 2003

  - by Mark

  Can anyone help me on how can I read the excel file using vb.net 2003? The first thing to do is to browse the excel file in my vb.net program then read the content of excel file and display the value of excel content in listview.

  Read the article

< Previous Page | 19 20 21 22 23 24 25 26 27 28 29 30  | Next Page >