The 2010 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

4
votes
0answers
32 views

Use functions like Countif, Countblank etc. to refer to discontiguous ranges.

Is there a way to use array formulas or some other feature to essentially have an excel function that means. =Countblank({A1,A4:A6,A112:127,B29:B38}) etc. Essentially, I want to refer to multiple ...
4
votes
0answers
1k 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
12 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
12 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
139 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
25 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
62 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
396 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
46 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
179 views

Excel 2010 not inheriting regional settings from Windows 8.1

In regional settings of Windows 8.1, I have negative numbers set to display in accounting mode. e.g. (1.0) instead of -1.0. Excel should be getting this setting as a default now, as it did in Windows ...
2
votes
0answers
10k views

How to add custom columns to Pivot Table (similar to Grand Total)?

I have data which I pivot as Row Labels and Column Labels which gives me something like this: And what I would like to do is add columns like Grand Total (i.e. which applies to all columns as a ...
2
votes
0answers
45 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
405 views

Add-Ins not loaded in Excel, when started via opening a file

I'm using Excel 2010 with TFS 2010. When I start Excel directly, "Team" and "Load Test" are loaded. But, if I double click on an Excel file, then Excel started without loading "Team" and "Load ...
2
votes
0answers
135 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
378 views

excel sql server error: Invalid object name

I access a stored procedure on a Microsoft SQL Server 2005 database within excel using Select * from [dbo].[fn_ph_by15minbyQueue] ('2013-09-01','2013-09-30','LocationCode') in the data ...
2
votes
0answers
116 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
641 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
884 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
364 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
24 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
38 views

Insert Hyperlink in word to an excel file that will open read-only when clicked?

To manually open an excel file as read-only I usually use excel /r "filename" on the command line, or just click file, open, open as read only from excel. If I insert a hyperlink to an excel file in ...
1
vote
0answers
22 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
18 views

Is there a way to use cell references instead of structured table references?

I have a table, on the outside of which is a column of formulas referencing cells within the table. When creating the formula, clicking on the table cells or using the arrow keys to move to the ...
1
vote
0answers
17 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
31 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
33 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
31 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
21 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
67 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
33 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
39 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
28 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
58 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
114 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
82 views

How to change Control-Y behavior in Excel-VBA's IDE

Excel VBA's IDE register's a Control-y as "cut this line of code". By contrast, redo-ing is accomplished by Alt-e, R. Is there any way to change this behavior and make Control-y be the much more ...
1
vote
0answers
37 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
107 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
54 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
185 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 ...
1
vote
0answers
45 views

How to find and replace lines in one file that match the pattern of lines in another file

I have a scenario with two documents. The first doc has lines of text, and the second doc also has same text with different text before and after this text. They need to be replaced. Doc 1 ...
1
vote
0answers
12 views

Windows Xperia excel 2010

I have 50 work books each work book is for 1 subcontract operative. Also each operatives work book has 52 sheets one for each week. I need to extract the same cell (£ payment total) to list the weekly ...
1
vote
0answers
760 views

Excel error message “An invalid value was used while saving to WK1 format”

I have a cell that evaluates just fine, but it comes with the warning that "An invalid value was used while saving to WK1 format". When I google this, I get basically no results. I find this very ...
1
vote
0answers
193 views

How do I change the function field in excel to show Bengali Characters?

I received an excel file that has columns translated from english to Bengali. I have a Bengali font installed and it shows up in the main body of the spreadsheet but the characters are not showing up ...
1
vote
0answers
29 views

How do I create formula to change cell colour if text is found in range

I have a number of lists (on separate tabs) which I am trying to put into a formula. When an address is filled in on my spreadsheet I want it to check which of the background tabs the street name ...
1
vote
0answers
29 views

How to force the content of row+1 cell with jet Essentials addin?

I'm using Jet essentiels excel add'in to build reports with data coming from a database. This is the final result I want to get : if resource id of line 2 is = to resource id of line 3, then 0, ...
1
vote
0answers
95 views

Align column of numbers, negative numbers, decimals and percentages in Excel

My list of numbers contains the following: 48.8 4.19 (0.36) 4.52% and I want them all to align by decimal. As far as I can tell it is not possible in a single step and the best I can do is paste ...
1
vote
0answers
54 views

Formatting of entire column based on the grand total using color scale?

This might be answered somewhere else, but I haven't been able to find a solution to this. The question is how to use color scale for entire column just based on grand total. I have attached the ...
1
vote
0answers
122 views

Weird Excel 2010 VBA Window Behaviour

If I open Excel and then open the VBA window then close it, every time I RDP to my computer, the VBA window is open again, even if I closed it before disconnecting. The next time I am sat locally to ...
1
vote
0answers
31 views

Excel Need to Check one Sheet for Data if True take data and paste in field

I am doing inventory for my company but need to use last years inventory prices in this years quarterly spreadsheet. There are only 3 Information fields. SKU, Qty, and Cost. In the master it has SKUS ...
1
vote
0answers
36 views

Excel 2010 SUMPRODUCT with multiple conditions

I have three columns A=Date, B=Region, C=Qty. I need to identify the Qty in the GR region between two dates. I have tried this formula with no success: $B$3=Beginning date, $C$3=Ending date ...