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
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.
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!
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?
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.
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?)
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.
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.
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...
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?
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?
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
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
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?
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
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
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.
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?
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.
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..
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.
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
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);
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