Questions tagged [microsoft-excel]

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.

7,411 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
7
votes
1answer
29k views

Intermittantly can't edit Excel cell

I use Microsoft Office 365 ProPlus running over Windows7 64 Enterprise. While I work on an Excel spreadsheet, it will often refuse to let me edit a cell. I click in the formula bar but the editing ...
5
votes
1answer
112 views

Why is the implicit intersection operator changing the behavior of my formula?

Since an update I have from Excel, which induces the automatic insertion of the implicit intersection operator @, my formulas have changed behavior in Excel workbooks. I noticed the problem appeared ...
5
votes
1answer
226 views

Delete or create Excel cell cell style group

In Excel, the built-in cell styles are grouped. There is "Good, Bad and Neutral", "Data and Model", "Themed Cell Styles", etc: Is there a way to interact with these groups? Like, can I delete an ...
5
votes
1answer
211 views

MS Excel: Displaying custom lower error bars

I have an odd issue with custom error bars in MS Excel 2016 (from MS Office 365). The upper error bars are showing but not the lower ones. At least not all the time... only once in a while... See the ...
5
votes
1answer
619 views

Excel- How do I find common text values from multiple (>2) rows?

This is essentially a variant of the question asked here: Excel- How do I find common text values from multiple (>2) columns? In this case, however, instead of multiple columns of data I need to ...
5
votes
0answers
3k views

Key command for move cursor to next different value in column in Excel

Some Excel jockey told me how to do this once, but I've forgotten. Basically I have a huge list sorted by a STATUS column. I'd like to press the down key and go to the next changed value in the ...
4
votes
2answers
2k views

Determine order of 'refreshes' when using Refresh All

Is there a particular order in which tables and connections are refreshed in Excel when using the Refresh All on the data tab? For example, suppose I have a table that is sourced via an ODBC or SQL ...
4
votes
1answer
110 views

Excel 2013/2016 not updating values while workbook is minimized

I have the following setup: 1 Workbook named Workbook1 with the value 123 in A1 1 Workbook named Workbook2 with value =[Workbook1.xlsx]Sheet1!$A$1 in A1 Now, when I go and change the value of ...
4
votes
1answer
710 views

Respond to SharePoint Survey through VBA

How can I respond to SharePoint surveys through VBA? I am trying to track a workbook's usage through a macro but I can't seem to figure it out or even the proper search terms to to search. Any ...
4
votes
1answer
1k views

How do I stop my account name appearing in Office application title bars?

I have an Office 365 Subscription with Office 2016 installed. All of my Office Apps including Word, Excel, Access and PowerPoint include my name in the application title bar, near the top right corner,...
4
votes
1answer
2k views

Function names in international versions of Excel

I'm writing a documentation how to use some Excel functions in a rather company specific context for novice users. I noticed that the functions seem to have completely different names in non-English ...
4
votes
0answers
742 views

Optimize row height/column width in Excel = minimize white space

I often create tables in Excel where some cells contain a lot of text while others just contain a single digit or some other short value. With wrap text in cells enabled and then a combination of ...
4
votes
0answers
54k views

How do I create a table with multiple header rows

How can I create a table in Excel that has two or more headers rows. I want to keep the range as a table so I can use the built in tools such as re-sizing, totaling, formatting, etc... I saw a ...
4
votes
1answer
2k views

Excel VBA : SQL query handles error

I have SQL that I can use in Excel 2013 to get the info from the Access database and it works using the SQL directly in a connection, but now I want to run it from VBA instead so I can use some ...
4
votes
1answer
2k views

How to default into edit mode instead of insert mode when entering content into a cell?

When I directly start to type content into a cell, Excel is in Input Mode, which means I could easily reference cells in formulas. Unfortunately most of the time I do not enter formulas, but simple ...
4
votes
2answers
4k views

Excel and tab delimited files, using Carriage return and Line Field

How do you introduce a CR and LF into a cell so when it is saved as a Tab delimited text file, the importing program will recognize the CR and LF?
4
votes
1answer
8k views

How to change Excel Pivot table “Report Filter”s values cell formatting

My Excel is in Finnish, but don't let that bother you... First Report Filter "Kupi" has only number values in my source table, for example 643203, 3533, 253244, etc. How ever in Pivot's "Report ...
4
votes
0answers
4k 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 ...
4
votes
1answer
2k views

Excel 2007 - cannot open the clipboard

Every now and then within Excel when I do Ctrl-x (cut) or Ctrl-c (copy) I get the pop-up message 'Cannot open the Clipboard'. I can't see any particular pattern to it but it's very annoying when it ...
3
votes
0answers
80 views

How to calculate average number of days, hours and minutes in excel

Can anyone help me please to calculate the average number of days, hours and minutes in excel? It is to calculate the average time taken to complete maintenance jobs. To start I merged the date and ...
3
votes
1answer
27 views

Efficient way to find last vector element that is a member of a set

I have a spreadsheet where column A lists the days of a month (1-Jan, 2-Jan, ...), column B lists the corresponding days of the week (Fr, Sa, Su, Mo, ...), and column C contains various notes that can ...
3
votes
2answers
45 views

Assigning different value to a specfic number for caculation

First, I'm new here and I'm would be so genuinely grateful to any guidance or help with, what might be, a simple question. I'd like to assign the value 1069 to 30. And then divide the number displayed ...
3
votes
1answer
89 views

Excel VBA: Application.Tranpose on an array gives Run-time error 438

I have a VBA code that gets data from a column of a structured table and puts it in a column of another structured table like this: Dim TopNTickers As Variant Dim NoOfTickers As Integer Dim ...
3
votes
0answers
33 views

Changes to User Defined Functions in Office 365 Subscription based

I've seen issues a couple of times when using User Defined Functions with Excel from subscription-based Office 365. When a workbook is opened with these formulas, they are automatically updated. ...
3
votes
0answers
41 views

Searching for possible solutions/workarounds to creating a Master Excel workbook

I'm trying to find solutions for creating a master template in Excel. We have almost 100 Excel workbooks where data in them varies but the formatting and cell and row layout including header names ...
3
votes
1answer
705 views

How to turn on or off editing invisible cells when filtering?

When I filter out a row in excel, if I edit the entire range (including the cell that is filtered out), only visible cells get edited. When my boss does this on his computer, the entire range gets ...
3
votes
1answer
3k views

Import Vcard (.vcf file) to Nokia 3310 3G phone

I want to import a .vcf file (with many contacts exported from an iphone) into a Nokia 3310 3G cell phone. I'm doing a test file first. The procedure is: load the file on a PC change the format of ...
3
votes
0answers
17 views

Excel csv-import into table referenced by name

I have a worksheet called raw_data where I import some data via the Data-Import Wizard. This created a new name-referenced range called abc.csv. However if I try to create a table on another ...
3
votes
1answer
106 views

How do i paste data (which has no hidden cells) into a worksheet which has hidden columns

Is it possible to prevent data being pasted into the hidden columns in one copy/paste movement rather than having to copy/paste multiple times?
3
votes
1answer
706 views

Why does Windows Defender slow my Excel file saving, even if the xlsm file type is excluded?

I'm experiencing a strange issue with Microsoft Excel (Office 365 MSO 16.0.11126.20234 32B) and Windows Defender running on Window 10 Pro (1809 Build 17763.253 64B) . When I save a macro-enabled Excel ...
3
votes
0answers
2k views

Updating List in Sharepoint Online (o365) via Excel/VBA

I am currently using VBA to update/create new sharepoint list items via SOAP. My IT dept has advised that they are migrating to SharePoint Online and the same code no longer works, I believe due to ...
3
votes
0answers
1k views

How do I get a cross-join with power query to “remember” values associated with it?

Let's say you have a basic Excel cross-query. You have two lists: A B C and X Y You cross join them (Cartesian join them), and get the following table: A - X A - Y B - X B - Y C - X C - Y Now, ...
3
votes
2answers
3k views

Copy many formulas from one workbook to another without pasting in reference workbook

I have a sheet like below. I want to copy all formulas from workbook B into A but without the reference to workbook B. when I do it now I currently get a link in all my formulas to workbook B. But I ...
3
votes
1answer
800 views

What is the “next cell character” when coping and pasting from a table?

You know when you copy a row from a table and paste it into another one it is in the correct place. So what is the character that is between cell values when this operation is performed. Eg. I have ...
3
votes
1answer
52 views

How do I know if Excel has recovered all data with problematic content?

I downloaded an Excel created by DataTables but when I open it I'm greeted with this ambiguous error: I select Yes and the Excel opens with seemingly all of the data, but it's such a big spreadsheet ...
3
votes
1answer
1k views

TEXTJOIN() on an array incorrectly returns a blank

TL;DR: TEXTJOIN() on an array returns a blank - can't use VBA to solve the issue in an alternative way. I've created several sheets with heavy dependence on Array functions due to limitations ...
3
votes
2answers
5k views

Missing Paste (P) option in Excel 2016

I'm copying some data from a webpage which is tabulated. When I click Ctrl+C in Excel 2010 and Ctrl+V to paste, it pastes correctly. However, in Excel 2016, the Paste (P) option is not there. Only - ...
3
votes
0answers
135 views

Excel formula to work out time elapsed between dates based on very specific criteria

I have a dataset with approx. 29,000 entries related to approx. 3000 unique individuals’ admission and departure dates to and from a service over a period of time. I’m trying to collapse each ...
3
votes
0answers
1k views

Dynamic Horizontal Axis Crossing Excel Bubble Chart

I'm attempting to make a 4 quadrant bubble chart in Excel to compare some competitor companies. I've input all my data from a pivot table, with 4 slicers to filter what the bubble chart is showing you....
3
votes
0answers
204 views

Formulas Changed to Reference Last Row When I Close and Open Excel File

I have no idea what is causing this issue, but when I reopen an Excel file, formulas that reference cells will change the reference cells at the very end of the sheet. Example: Super simple spread ...
3
votes
1answer
2k views

Writing Numeric Values from Excel Cells to Text File without Scientific Notation in VBA

I'm having some trouble with a VBA module in Excel. I have a script that references cells in my spreadsheet and writes the values in comma separated lines to a text file. The way I do it boils down ...
3
votes
0answers
78 views

Excel (Mac) updates, disable banner

Is there a way to disable for ever and ever and ever this annoying banner? I tried to remove the update service, I tried to set the updates to manual, I had it check for updates so that it could ...
3
votes
1answer
515 views

Define Name for Worksheet Scope in Microsoft Excel for Mac V15.38

I am trying to create named references that have a Worksheet scope in Microsoft Excel for Mac V15.38. I want to set up a template sheet that gets duplicated multiple times (example: a template sheet ...
3
votes
1answer
344 views

How to use Excel to get a Function Equation from a trendline?

I am struggling with Excel right now. What I have is a graph which can be approximated by a polynominal formula. I have values for X and Y Axis and want to get the equation of the trendline. To stay ...
3
votes
0answers
220 views

Weird watermark when pasting Excel graph as picture with gridlines

When I paste an Excel 2016 graph as an image in Word (also 2016), if the graph has gridlines, the image displays some kind of watermark in the center, like this: . I know the problem are the ...
3
votes
0answers
922 views

What are the security risks to enabling editing in Excel and Word, if macros are disabled?

I'm using Office Professional Plus 2016. I often receive Excel spreadsheets and Word docs from clients and need to make small changes before sending them back. Assuming that my macro settings are set ...
3
votes
1answer
1k views

Keeping locked cells when copying a worksheet

How do I copy an Excel worksheet, with protected cells, onto a new sheet and retain the locked cells? I have tried the normal protection sequences but every time I copy the sheet, the new sheet has ...
3
votes
1answer
2k views

Can I automatically sort a grouped and stacked pivot chart by a sum of values without showing this on the chart?

I am working with data in groups in Excel. I currently have a pivot table and chart set up with: Rows: symptom name grouped into one of four international severity grades Columns: four datasets - ...
3
votes
0answers
2k views

Prevent Excel's clipboard from “taking over”?

I'm an encountering a weird problem with Excel, and it's especially annoying because it wasn't happening yesterday, and hasn't happened ever before. Here's an explanation of what I'm doing: I copy a ...
3
votes
3answers
133 views

Excel data in rows and columns to be reformatted

I have data in Excel in a staggered format. There is a customer ID in the left-most column and the details of that customer are in different rows within different columns. I need to rearrange the ...

1
2 3 4 5
149