A spreadsheet application by Microsoft. Use this tag along with [vba] if your question involves programming Excel in VBA, and with [worksheet-function] if it involves an Excel formula or worksheet function.

learn more… | top users | synonyms (2)

1
vote
0answers
77 views

Sort list into tuples in Excel

Is there any way to sort a list into tuples as defined by a priority list in Excel? For example I would do a draw to get priorities: Banana -> 1 Apple -> 2 Tomato -> 3 And I have sheet of ...
1
vote
0answers
41 views

Excel - Can I create a list of values with criteria and have excel make a list with parameters?

In Excel, I am trying to see how many combinations I can make with the allotted criteria and such. So lets say I want to know how many combinations of groceries I want to buy for a certain budget. ...
1
vote
0answers
35 views

grouping rows with similar words

i have multiple docs having huge amount of textual data which i wanted to group by clustering . grouping lines having multiple duplicates like line 23 have two words car and truck and line 197 having ...
1
vote
0answers
2k views

How can I create sub-sheets in Microsoft Excel?

I have a workbook in excel that displays information from multiple processes and each of these processes has multiple sub-processes. I can display information for each process easily using one sheet ...
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
45 views

Color/Opacity Loss when converting XLSX to PDF using Acrobat IX

It's all in the title. I've got an excel file I need converted to PDF for printing, and exporting it using either the Save As... function or the 'Create PDF' option in the Acrobat Ribbon both result ...
1
vote
0answers
23 views

How to add data from multiple rows based on a column with specific identifiers

I have student data and I need to calculate the total number of minutes each student is receiving but there are multiple rows for each student. The data looks like this: Student Service ...
1
vote
0answers
18 views

I am trying to turn named ranges into named tables while keeping Auto populating headers

I have a spreadsheet with 32 individual named ranges and the Section Title (B338 for example) is linked to the equivalent value in the Table of Contents (B70 for example). What I would like to do is ...
1
vote
0answers
59 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
63 views

Sum data from muliple cells, multiply by other cell range, reference on other sheet

Ive had a couple issues with this workbook recently this seems like the biggest. As you can see in the pics, this a time sheet that needs F15 multiplied by Q15, then added to F20 which was multiplied ...
1
vote
0answers
40 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
29 views

Identifying who has locked a shared Excel sheet

We have an Excel file in Windows 7 which is shared by six users to update data in that file. we are encountering a problem when someone opens the Excel file and forgets to close it. I would like to ...
1
vote
0answers
172 views

How to paste from Excel with VBA macros (xlsm) to PowerPoint (pptx) without warning

I teach using a combination of Excel and PowerPoint. I use an Excel workbook with a helper macro that makes it easy to display a cell's formula adjacent to that cell. I don't think it's directly ...
1
vote
0answers
36 views

Excel Updating with lookup

I would like to ask a question related to tweaking Excel using something like v-Lookup. However, I need to be able to upload the spreadsheet to explain the question. Is it possible to upload files ...
1
vote
0answers
102 views

Frequency function in excel 2016

I'm attempting to array data using the frequency function in excel. When I select my data and bin, hit control enter, I get only the answer of the first cell. When I attempt to drag the t cursor down ...
1
vote
0answers
415 views

How to create a 100% stacked column chart if I have total

I'm trying to create a 100% stacked column chart using Excel 2013 Pivot Table to show what % of Column A is of a Total Column B. However the 100% stack column chart doesn't seem to work if I have a ...
1
vote
0answers
73 views

Excel converting data entered to 10% of correct value

I am having a problem with all of my ExcelWorksheets. Any number that I Type into a cell is converted to 10% of the value I typed. For instance, if I type in 100 into a cell, the data displayed is 10....
1
vote
0answers
271 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
115 views

If Data Allready Exists In A Cell Overwrite It With New Data

I have an excel sheet with IDs beside cases. When I work the case and get a reply I want the excel spreadsheet to work out its the same case and update the original without adding a new case onto the ...
1
vote
0answers
411 views

“Microsoft Excel is waiting for another application to complete an OLE action” interrupting VBA code

I've got an Excel workbook that is running some VBA code, which I use every day. During execution, it keeps hanging on a dialog box saying "Microsoft Excel is waiting for another application to ...
1
vote
0answers
322 views

Excel workbooks pinned to taskbar on Win 10 disappeared

My question is two fold: Can I change the order of Excel workbooks pinned to the taskbar on Win 10? In Win 8.1 I could just drag them in whichever order I wanted. I saw the similar question ...
1
vote
0answers
71 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
34 views

Combining distinct patient ID with patient characteristics

I'm trying to use Excel to analyse a large set of patient data (>16,000 entries). Each patient is identified by a numeric patient identifier and is recorded each visit. This means some patients are ...
1
vote
0answers
25 views

Track workflow precendents using only Excel Formulas

what I'm trying to achieve is the following. I have a production chain, say for example: A and B are used to make C C and D are used to make E and E is used to make F And I wanna know the direct ...
1
vote
0answers
158 views

EXCEL 2011 - Inventory with Matrix and Vlookup

I am creating an inventory matrix, which has on the first column a list of all the items in the inventory, and on the first row a list of the dates for when the inventory gets renewed. Basically, not ...
1
vote
0answers
55 views

Search in text for column of words and return the word that matches

I have two columns of data, the first (Column A) contains a whole load of text, the second (Column C) contains the "key" data. I want to see if the text in Column A is matched by any of the entries ...
1
vote
0answers
130 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
118 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
61 views

LibreOffice Calc equivalent to Excel “Custom Views” feature

Custom Views are an Excel feature that comes very handy when, for example, you want to save a filtered version of a worksheet and then pass to another vision of the same worksheet with different set ...
1
vote
0answers
103 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)...
1
vote
0answers
41 views

Opening a file with a # in its path using the default application from Excel 2007

I have a pdf file which is located at "D:\some\#folder\filename.pdf". And want to open it from an Excel worksheet by clicking on a hyperlink (or something similar). Just creating a hyperlink does not ...
1
vote
0answers
335 views

Dependent Drop Down lists and Data Validation; Multiple Lists

Right now, I have My goal: Add a Data Validation List into another sheet such that when I select an item from Column B, everything from Column K appears that is linked through into Column B (...
1
vote
0answers
119 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
19 views

Having problems linking table at a specific webpage in Excel

I am trying to pull live data from http://www.wdol.gov/sca.aspx into an Excel spreadsheet. Specifically the SCA Wage Determined Rates. I want to be able to pull in the table that is generated from ...
1
vote
0answers
229 views

Excel - disallow formatting locked cells, allow formatting unlocked cells

When i lock cells in excel How can i prevent users from editing the background color, text color, bold text etc in cells that are locked. But allow them to change background color etc in cells that ...
1
vote
0answers
282 views

Excel 2013 Workbook Size Optimizer not working

I have a large PowerPivot/PowerView workbook that needs to be cleaned up. Microsoft offers a free tool called the Workbook Size Optimizer for situations like this, but I have not been successful in ...
1
vote
0answers
162 views

How do I combine data in two tables in LibreOffice?

I have a spreadsheet with two sheets. SheetA has Customer number and location, and SheetB has Order number, Customer number. How do I combine the data so that one sheet has Order number and location? ...
1
vote
0answers
192 views

excel formulas not working in structured table protected cells

Structured Table1= A B C QTY Price QTY*Price 1 3 3 =A*B 2 3 Column QTY & Price are not locked while Column QTY*Price is locked & hidden as it has a ...
1
vote
0answers
23 views

which function would add a row to another set of rows, so it behaves as if they were below each other?

Example: having data in A1:E4 and another data in G1:K1 and i need to use them to look like A1:E5 so that G1:K1 was added below A1:E4. The reason behind this is that excel is asking to give set ...
1
vote
0answers
58 views

Printing a group of .tiff files referenced by name in an Excel spreadsheet

I have a folder with over 100,000 tiff files, each files with specific number: 1001 1002 1003 1004 1005 1006 1007...etc I have a spreadsheet with a list of specific .tiff files I ...
1
vote
0answers
198 views

Using Microsoft Query in an Excel sheet with dynamic file location

I have two tables in the same Excel 2013 workbook and I want to create a new table within the same workbook that performs left outer join between these two tables using Microsoft Query. I was able to ...
1
vote
0answers
664 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
58 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
33 views

Dynamic choice dataset Microsoft Excel

I'm currently setting up a database for my thesis, but the way I am working is not efficient enough. I have got two datafiles that I currently need to link manually, but that takes too much time. I ...
1
vote
0answers
162 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
414 views

Office 2013 on Windows 8.1 gives out of memory error when opening files

We have the same error that has been posted here: Problems opening Excel attachments from Outlook Namely, when a user opens a file from the internet, the internal network or an outlook attachment ...
1
vote
0answers
139 views

Excel 2007 =Hyperlink issue. Calling an EXE with a / switch. The “/” turns into a “\”

I'm trying to run a program from a spreadsheet using the =HYPERLINK function. The formula looks like this (I'm using DIR just as an example so people can recreate the issue if they want): =HYPERLINK(...
1
vote
0answers
679 views

How to calculate average daily sales for each month in a pivot table

I need to calculate the averages I have in a month. What I'm expecting is to calculate 936, 184, 943, and 230 and get an average of 573. However, when Excel calculates these values in a pivot ...
1
vote
0answers
24 views

Refresh data in depth trough multiple closed workbooks

Situation I have 3 Workbooks in the format .xlsx, Source, Manipulation and Result. Result has a link to a cell in Manipulation wich again, has a link to a cell in Source. As the data is manipulated ...
1
vote
0answers
55 views

Remove Rows Not Part of Filter

I am filtering a large Excel spreadsheet. I want to remove all rows on the sheet that are not a part of the filter. I know I can copy the rows and paste them into another spreadsheet. But I would ...