Search Results

Search found 7704 results on 309 pages for 'excel 2011'.

Page 53/309 | < Previous Page | 49 50 51 52 53 54 55 56 57 58 59 60  | Next Page >

• 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

• 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…

  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…

  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

• Outlook Anywhere inconsistencies with authentication methods

  - by gravyface

  So I've read this question and attempted just about every other workaround I've found online. Problem seems completely illogical to me, anyways: SBS 2011, vanilla install; haven't touched anything in IIS or Exchange outside of what's been done through the checklist (brand new domain, completely…

  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…

  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…

  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…

  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…

  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…

  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…

  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…

  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: …

  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…

  Read the article

< Previous Page | 49 50 51 52 53 54 55 56 57 58 59 60  | Next Page >