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?
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 answer: Facebook and Twitter
How do I put these types of answer into Excel to gain some sort of useful analysis?
Thanks.
PS. I know Excel is not great for surveys, but can't spend $1000 on SPSS or similar.
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 it keeps the order?
Thank you very much
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've been doing a lot of reading these last two days on Microsoft Prism, but the thing I'm still not very sure of is what does the future look like for it? I know that version 4.1 was just released a few months ago, but besides Microsoft's own documentation, I haven't found many blog posts written in the last year on the subject, most of what I find is 2009-2010.
It definitely looks interesting but the learning curve seems to be a bit steep and I wouldn't want to embark if it's going to become obsolete in the near future. Anyone has any insight on this?
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.
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?
When I calculate the sum of numbers in the column G of a MicrosoftExcel 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.
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?)
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...
Alot of people say it is very hard to get a job at Google/Microsoft. Due to insufficient number of jobs, there is very tough competition for fresh graduates to get a job at the worthy company.
I have read certain articles which encourage fresh graduates to have good projects (Programming projects), Focus on Accomplishments or have a good reputation on websites like this one.
So my question is what kind of programming projects & accomplishments help in getting job at Google/Microsoft. There are alot of other factors like communication skills & leadership etc but this is not the main concern here.
Regards
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?
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..