The 2010 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

4
votes
0answers
2k views

Excel 2010 crashes: Excel.exe 0xc0000005 when trying to highlight from pivot table

One of our users uses pivot tables a lot. She often called me about Excel crashing from time to time without being able to reproduce the problem. Today we have found a way to reproduce the crash every ...
2
votes
0answers
22 views

Can I anchor a checkbox to a specific location on the spreadsheet?

I am using excel 2007 at home to develop a sheet for work that has data input using multiple checkboxes. Each checkbox is in an empty cell. When I open it at work with excel 2010 all the ...
2
votes
0answers
33 views

Can a drop down in Excel show long descriptions when clicked, but only a short code once selected?

I have created a drop down menu in Excel, but the options are long sentences. After someone selected one of the options I want a letter to appear instead of the entire option. How would that be ...
2
votes
0answers
17 views

Hyperlinks on Excel 2010 - copying from orignal list to search index list

I've created a search index (using forumlas) from a list of products that have hyperlinks attached (created with Insert Hyperlink). The search index is created without the hyperlinks however. Both ...
2
votes
0answers
20 views

Excel Conditional Formatting when adding extra columns

I've created a worksheet and added conditional formatting to it. Unfortunately whenever I need to add extra columns to this sheet, my conditional formatting messes up. Not only the range when this ...
2
votes
0answers
259 views

Mapping Excel sheet to XML Schema - using a column for multiple attributes

I have data like this in Excel: I want to export XML using XML Maps feature like this instance, based on a schema that cannot be modified: <someRootElement> <Foo Key1="A" ...
2
votes
0answers
36 views

What function (or functions) can I use to pass worksheet title to a reference?

I have a number of cells on a worksheet that reference another worksheet. Pretty straight forward except I have to type the name of each worksheet in each formula which is becoming monotonous. What I ...
2
votes
0answers
104 views

Date types management mismatch (2-digits year) - on copy/paste user action

I find a strange inconsistency when copying-pasting dates on MS Excel, when they have a 2 digits year. I work on a machine Windows 7 Enterprise 64 bit and my Excel is a 2010 version. PROBLEM ...
2
votes
0answers
643 views

Can you preview Office 2010 files in Outlook 2013?

Issue: One of our users is using Outlook 2013 and Excel 2010 on a Windows 7 machine. When she receives an email with an Excel file attached, she is unable to preview the Excel file. She gets this ...
2
votes
0answers
51 views

Newlines in description of imported csv in Outlook Calander

I have exported a list of birthdays from excel to csv. Now I want to import them in Outlook as calander items. Everything works fine exept I can't do newlines in the desciption. I've already tried to ...
2
votes
0answers
56 views

Excel 2010 clips top edge of content

In Excel 2010 on 2 different computers, the same file opens differently as follows: Correct: Incorrect: The correct one is displayed first. This is a file exported from a SQL Server Report; when ...
2
votes
0answers
155 views

Excel 2010 - Voice command to select cell?

I am using Windows 8, but I would like to know if the solutions provided are also applicable in Windows 7. I use Excel 2010. What I want is a way to select a cell in an open excel worksheet, using ...
2
votes
0answers
205 views

How to stop IE opening Excel spreadsheets in embedded mode?

When we open an Excel workbook with Internet Explorer (D:\Book1.xlsx in address bar) - IE opens the Excel workbook in embedded mode. It triggers Excel with the following option C:\Program Files ...
2
votes
0answers
147 views

Excel 2010 / Outlook 2010 - Changing the size(with precise numbers) of a chart exported from Excel to Outlook?

If I export(copy&paste) charts from Excel 2010 to Outlook 2010, I'm not presented with a "size proprieties" option when trying to resize them. Since I have multiple chart to resize for each ...
2
votes
0answers
708 views

error while Generating “xlsx” file using carlosag.excelxmlwriter dll

I am using carlosag.excelxmlwriter dll to build Excel files. When trying to build xlsx files, the following error pops up: Excel can not open the file "test.xlsx" because the file format or file ...
2
votes
0answers
955 views

Excel 2010 claims files are corrupted when I open them twice from links

I have several large Excel (2003) workbooks, which are linked. I open A.xls in Excel 2010, then open B.xls from Edit->Links. This works fine, and I can use B.xls. If I then close B.xls, and try to ...
2
votes
0answers
425 views

Multilingual spreadsheet

I need to make a spreadsheet template that needs to be support both English and Spanish. I know Office 2010 has an option to translate content into desired language but its a manual process. Is there ...
1
vote
0answers
27 views

Calculating partial values for use in a weighted average

I have a spreadsheet with the following information: Column A contains a list of courses (eg Course 1, Course 2, etc) Column B contains the number of credits available to each course Column C ...
1
vote
0answers
22 views

Excel VBA Run-time error '1004': Applicated defined or object-defined error - Need code assistance

This is the code that I am having an error on in Excel: Sub Start_EndDelayInMonth() With Sheets("Analysis Worksheet") Dim i As Long Dim LastRow As Long LastRow = Range("N" & ...
1
vote
0answers
29 views

Shortcut for Direction Keys — To keep hands on QWERTY end of the keyboard

I use a lot of Excel and finally got myself used to the ThinkPad pointer whereby I no longer need to take my hands off the keyboard for scrolling. But now I need to take my right hand off the ...
1
vote
0answers
37 views

Excel - How to link Index/Matching formula with Indirect formula for dynamic column reference

I have a worksheet in which I am looking to utilize the Index/Matching formula to pull in exact values for the unique intersection of Department & Account values on a separate data sheet. However ...
1
vote
0answers
10 views

Link with UNC path is broken after copying cells from Excel 2010 to Word 2010

I am trying to copy an Excel table to Word in Office 2010. Basically, if the hyperlinks are pointing to my local hard drive, there are no problem at all. However, if the hyperlink is pointing to a UNC ...
1
vote
0answers
43 views

Excel 2010 Password Protected Book Accepts More Than One Password

I use Excel 2010 64 bit (14.0.6023.1000) A workbook that is being protected by password "flu" and be unprotected by password "flu" OR " ab". Why is that? First of all, I thought beginning with Excel ...
1
vote
0answers
45 views

How to show collapse/expand button beside a sub-group in Excel that is the last child of it's parent?

I am experiencing this strange behaviour in Excel and am looking for either an explanation or a solution. I am using Excel's grouping feature to create some parent-child nodes within my spreadsheet. ...
1
vote
0answers
70 views

Programmatically rotate a pie chart to fix the labels

Part 1 I'm looking at a way to automatically rotate (with VBA) a pie chart depending on the data. The data is changed dynamically depending on the month selected. Here is an example of the kind of ...
1
vote
0answers
43 views

Can't calculate % of row in Excel Pivot Table

Product types A, B, C, D Each type has numerous products, say type A has 100 products, type B 50 etc.. product# product type buyer 01 A john 02 A ...
1
vote
0answers
36 views

Excel 2010 R1C1 reference style inexplicably became selected

This really isn't a problem, it's just weird. I opened Excel 2010 at work a few days ago, and noticed that my columns were numbered instead of lettered. A quick Google search found the fix, which ...
1
vote
0answers
35 views

VBA is disabled in Excel Home and Student 2010 (on XP SP3)

Everything seems to be working fine with Office, except that in Excel the VBA/Macro functionality is disabled. I cannot launch the editor, all macro-enabled files are interpreted as corrupt and the ...
1
vote
0answers
19 views

How to make groups/hidden rows behave like filtered lists so changes only affect visible cells, to prevent accidental data loss?

When rows/columns are hidden in a group or by manually hiding rows/columns, and cells are highlighted like so If formatting is applied, or something is deleted, it applies to the hidden sections ...
1
vote
0answers
53 views

How can I ensure that a formula that I have written to calculate the difference between time values applies only to the filtered values?

I have two columns of data: Member Time A 09/24/2015 09:48:36 A 09/24/2015 09:47:40 A 09/24/2015 10:11:06 A 09/24/2015 10:08:47 B 09/24/2015 10:28:45 B ...
1
vote
0answers
65 views

How can I make an excel user defined function (UDF) work in an array function (CSE)?

I am using Excel 2010. I wrote a UDF to create a unique number for each month: yearmonth = 12*Year(date) + Month(date) Now I want to use it in a CSE: ...
1
vote
0answers
38 views

Excel Formula to autopopulate a cell and mark as Assigned

I am attempting to auto populate a excel cell with an account number with the following formula. =INDEX(C2:C20001,MATCH(FALSE,B2:B20001,0)) Column B contains True/False and Column C contains the ...
1
vote
0answers
17 views

Excel WEEKDAY formula doesn't recognise English Dates since I upgraded to Windows 10

I have an exisitng spreadsheet which was working fine, but after the upgrade all the dates in the sheet were converted to US form 6/27/2015. I was able to change them back to UK format but now this ...
1
vote
0answers
88 views

Hiding pivot table field using a button

I have a pivot table in Microsoft Excel 2010 with several row and column labels. For the sake of user friendliness I would like to have several movable, clickable buttons which each hides/shows one of ...
1
vote
0answers
77 views

Excel lookup value not on same row

What i`m looking for is that the data will be filled automatically from data table by lookup value in not same row. See the picture or xls example https://dropmefiles.com/BDlHe 1st table lookup ...
1
vote
0answers
68 views

How to prevent enabling editing in Protected View in Excel 2013 from altering chart formatting of Excel 2000-2003 and 2007-2010 workbooks

In Excel 2013, when opening and enabling editing from Protected View a macro-enabled Excel workbook downloaded from the internet, with two versions in .xls (Excel 2000-2003) and .xlsm (Excel ...
1
vote
0answers
244 views

Linear date axis in pivot tables

How do I format a PivotChart so that the horizontal axis is displayed in linear time? See the PivotTable below as well as the source data (both excerpts). If it is in fact not possible to ...
1
vote
0answers
91 views

Excel (2010) Save and Save As operations cease working

Twice in the past week a colleague has encountered an issue with Excel 2010 where the application suddenly ceases to perform its Save and Save As functions on all open workbooks, with no error ...
1
vote
0answers
34 views

Matching a column range based on a column label

I have written a spreadsheet for Excel 10 and am struggling with the last bit of formula. I wrote this: =SUMPRODUCT(--(ISNUMBER(FIND(B7,'PO SHEET'!$K$7:$K$74))),('PO SHEET'!$W$7:$W$74)) However, ...
1
vote
0answers
49 views

Automatically Printscreen from result of formula

I have a procedure in VBA to call a PrintScreen: Sub PrintScreen() keybd_event VK_SNAPSHOT, 1, 0, 0 End Sub I want to call it every ten seconds, when the result of this cell ...
1
vote
0answers
394 views

Excel Charting - How to edit the X axes for positive value on both sides?

I have a stacked chart, with the X axes at bottom. So there are two bars protruding along the y axes from each category. to get an idea of the X axes, it's something like this How to plot positive ...
1
vote
0answers
52 views

One dynamic named range not staying dynamic while another in the workbook is

I am attempting to use dynamic named ranges to make it so I can pre-set the column portion of the print ranges in a workbook without assuming a number of rows. So I opened the name manager and ...
1
vote
0answers
115 views

Deleted record keeps reappearing in data file using MS Word 10 merge/Excel 10 spreadsheet

I am unable to remove one particular record from my data file. I remove it from the excel spreadsheet, but when I try to merge it is back--even after I have changed the file name after removing the ...
1
vote
0answers
47 views

How do I incorporate IFERROR into this formula?

I need to know how to include an IFERROR statement in this formula in Excel 2007. =VLOOKUP($E3,HSA!$E$3:$G$20,2,FALSE)*$D3 I want the formula to return a 0 instead of an #N/A.
1
vote
0answers
131 views

How to extract contour lines from a surface plot in Excel

I have several surface plots. I would like to combine one contour line from each plot into a single plot. Is there a way to extract the contour line that excel generates?
1
vote
0answers
204 views

Excel 2010 - Merge multiple connections into single worksheet

I have an Excel workbook containing several worksheets. Each worksheet has an external connection to a unique .csv file that is updated several times a day from different PCs. This is done so that ...
1
vote
0answers
45 views

Show webpage in excel

I have an excel file with a lot of urls, which I have to look through and mark. My idea is now, to preview the urls in a tiny box when I hover over the url. However, I cannot find such functionality ...
1
vote
0answers
228 views

In Excel 2010 - Trying to get the cell address from where a formula got its answer

I have a complex spreadsheet with a named range (Vault) that covers chunks of data from many parts of the sheet: "Vault" represents a defined name and refers to the following areas on page 1 (you ...
1
vote
0answers
100 views

Creating a list from another list's value

How can I populate a cell with a list as a result of a condition from another dropdown list? I have a dropdown list, when I select a value from it I will need to populate the cell beside it with ...
1
vote
0answers
275 views

Text to copy cells with formatting into Excel

I am looking for a way to copy-paste text into Excel, which Excel will recognize as formatted (ie, styled or colored, etc) cells. On the one hand, Excel recognizes tab-delimited text pasted from the ...