The 2010 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

5
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 ...
3
votes
0answers
71 views

Checkbox location changes when workbook is opened in Excel 2010

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
91 views

IF AND Statement with multiple condition

Need a formula that can return values MET & NOT MET in Excel 2010 The formula MET or NOT MET at the resolution time. Below is the formula I tried but something is missing, because not sure how ...
2
votes
0answers
28 views

Copy hyperlinks from original list to search index list

I've created a search index (using formulas) 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
26 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
394 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" Key2="Q">...
2
votes
0answers
41 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
151 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
733 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
55 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
65 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
171 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
238 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 (x86)\...
2
votes
0answers
157 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 report,...
2
votes
0answers
762 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
1k 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
474 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
7 views

Creating reports in Excel without PivotTables?

I have a master Excel file which includes sections of data as well as multiple columns, although all data is in one worksheet. I want to be able to pull information from the file to create nearly ...
1
vote
0answers
12 views

Error when connecting an Access query to an excel sheet -expression in query prevents connection being made

SCREENSHOTI have an excel sheet which is linked to a query in my Access database (both 2010 version). It works really well and I decided that I wanted to have the same excel sheet but to only contain ...
1
vote
0answers
27 views

How to Mirror Cells when the source is a data validation list? (Excel 2010)

I have a workbook with two tabs. The first tab is being used as a table for data validation lists I'm creating in the second page. For example, one list is called "Supervisors". This list starts cell ...
1
vote
0answers
14 views

Excel 2010 populate based on another sheet

I need some help with dynamic range and auto populate. I have a sheet with 2 Columns, 1 is the name and the other is the age between 6 and 12. There are 20 rows. http://imgur.com/utTJzF3 In another ...
1
vote
0answers
77 views

Excel VBA: How can I run code when any check box value changes in a Userform?

How can I run code when any check box value changes in a Userform? I am attempting to use a class module but the code is acting in a strange way that I don't understand. The code will only recognize ...
1
vote
0answers
66 views

Excel 2010 - Combine specific sheet in >200 separate files into single worksheet?

I have tried solutions in other posts like this and so far nothing has worked :/ I have >200 separate excel files, and essentially I would like a specific sheet from each of these files combined into ...
1
vote
0answers
9 views

Excel stays visible when changing desktop on windows 10

I am using office 2010 on a windows 10 computer (upgraded from windows 7, office was installed prior to the upgrade) I have a problem that occurs whenever I have two or more excel spreadsheats opened ...
1
vote
0answers
15 views

shift data down in one sheet when a new value is entered in a different sheet

I've reached a point where I'm quite sure I need VBA but I don't know VBA so I need your help. So: I have a worksheet for organizing data on certain ceramic products. In my main sheet (called '...
1
vote
0answers
14 views

Plot a chart directly from a function in Microsoft Excel

I need an help with chart plotting in Excel (I'm using Excel 2016) let's say we have a simple function like: y=1/x Right now, to plot a chart based on this function I use two columns. In the left ...
1
vote
0answers
31 views

Show Excel Cell Only If Another Has Data

I am trying to format the below Excel sheet so that when a date is entered into cell J1, cells G24 - G37 populate with a date a specific to what I need. I currently have the cells formatted as follows:...
1
vote
0answers
26 views

Find and replace multiple values, according to table value - excel formula

I would like a FORMULA that change letters according to table of values that i make. example: êíöä = LOVE (because i made a table that show: ê=L, í=O, ö=V, ä=E). example- Picture: As you can see ...
1
vote
0answers
89 views

Pivot table with dynamic field names in Excel 2010

I am creating a workbook where the user can paste in their dataset in a worksheet. This dynamic range will be used to generate a series of pivot tables on subsequent worksheets. This works well when ...
1
vote
0answers
35 views

Section of VBA code is stuck in a loop

From what I can see this code should work but it ends up stuck in a loop so obviously there is still an issue. The intention is to start at cell E70 and paste a value obtained from cell X38. Move ...
1
vote
0answers
30 views

Ignore empty cells in graph doesn't affect the layout of the graph

I have just got an answer to this question, and now I have a new one. Before I made the changes in the other question I had a graph that visualised the values in column M without going to the value 0 ...
1
vote
0answers
33 views

Excel 2010 - Get CSV wizard to open by default

I'd like to set Excel 2010 to open the import wizard each time I double click on a CSV file rather than have Excel open the file without the wizard. Previous versions of Excel did this but 2010 ...
1
vote
0answers
53 views

Excel external workbook references- dynamic

I'm trying to solve an issue in Excel 2010 where I'm referencing external workbooks that aren't open (so INDIRECT isn't an option) and I'd like the cell reference to be dynamic. The external cell ...
1
vote
0answers
38 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
25 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
44 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
76 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
174 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
45 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
43 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
29 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
60 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 09/...
1
vote
0answers
96 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: {=sum(if(yearmonth('plan'!$j$3:$j$1000)<>...
1
vote
0answers
41 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
277 views

Sort a pivot table according to % of Row Total

My pivot table compute the sum of sales amount of products in different regions (row field) according to product type (column field). The values which we want is the % of Row Total (so that we can ...
1
vote
0answers
27 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
73 views

How to combine multiple worksheets into one, with one key column

I am trying to combine three worksheets into one, with a key column. Each worksheet has the names of people in the first column, followed by columns of data and information related to the person, each ...
1
vote
0answers
137 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
129 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
112 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 2007-2010)...