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.

8,013 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
6 votes
3 answers
4k 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 ...
user avatar
  • 7,196
5 votes
2 answers
565 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 ...
user avatar
5 votes
1 answer
620 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 ...
user avatar
  • 305
5 votes
1 answer
242 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 ...
user avatar
  • 283
5 votes
1 answer
912 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 ...
user avatar
  • 51
5 votes
1 answer
3k 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 ...
user avatar
5 votes
1 answer
15k views

Setting upper and lower limit for an Excel histogram

I am using the built-in data analysis tool to create a histogram for a column of numerical data in Excel. I'm doing the same thing for many different files, and they all need to have the same scale on ...
user avatar
5 votes
0 answers
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 ...
user avatar
  • 431
4 votes
1 answer
169 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 ...
user avatar
4 votes
1 answer
758 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 ...
user avatar
  • 13.1k
4 votes
1 answer
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,...
user avatar
  • 1,045
4 votes
1 answer
977 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 ...
user avatar
  • 552
4 votes
0 answers
55k 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 ...
user avatar
  • 149
4 votes
1 answer
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 ...
user avatar
  • 41
4 votes
1 answer
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 ...
user avatar
  • 141
4 votes
3 answers
4k views

Excel and tab delimited files, using Carriage Return and Line Feed

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?
user avatar
  • 41
4 votes
1 answer
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 ...
user avatar
  • 103
4 votes
0 answers
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 ...
user avatar
4 votes
1 answer
3k views

Automatic LaTex document generation from Excel spreadsheet

I have some data in an Excel file from which I have to generate a report. I repeat this task fairly regularly and am looking to automate it. I have a LaTeX project into which I usually just copy data ...
user avatar
  • 141
4 votes
1 answer
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 ...
user avatar
  • 763
3 votes
0 answers
131 views

Why does Excel display incorrect modified times when listing recent files?

When I try to open a file in the recent files list in Excel I'll often find that a workbook I worked on yesterday or the day before is not in the list. When I expand the list to include older ...
user avatar
3 votes
2 answers
40 views

Inserting the hyperlink value if there is one but do not enter anything (leave blank) if there is no value

Currently I am using this on a new added column to extract the hyperlink. How do I add code that will not enter any value (leaving it just blank) if there is no URL. Actually what I needed was when ...
user avatar
3 votes
0 answers
288 views

Unicode ☑︎ becomes 🤵🏻 emoji in Excel on macOS Catalina (10.15.7)

I am using Excel 16.46 on macOS Catalina 10.15.7 and here is what I am experiencing. Using macOS's character viewer — command+control+space — I've entered the “ballot box with check” Unicode ...
user avatar
  • 139
3 votes
1 answer
31 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 ...
user avatar
3 votes
2 answers
47 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 ...
user avatar
  • 31
3 votes
1 answer
167 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 ...
user avatar
  • 55
3 votes
2 answers
372 views

MS Excel 365 Not Sorting

I have recently started experiencing a weird bug with excel, for some reason it has stopped sorting columns. It does not matter the way I try to sort, it just does not do it, however, filtering does ...
user avatar
  • 31
3 votes
0 answers
41 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. ...
user avatar
3 votes
0 answers
59 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 ...
user avatar
3 votes
2 answers
641 views

Keyboard Shortcut - Highlight to bottom of range based on data one column over

I work with similar data pulls frequently and am trying to be more efficient in how I transform them. Typically, I will autofill a field down to the end of the range one column over by using the ...
user avatar
3 votes
1 answer
1k 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 ...
user avatar
3 votes
0 answers
29 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 ...
user avatar
3 votes
1 answer
227 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?
user avatar
  • 31
3 votes
1 answer
1k 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 ...
user avatar
  • 131
3 votes
0 answers
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 ...
user avatar
  • 31
3 votes
0 answers
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, ...
user avatar
  • 459
3 votes
2 answers
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 ...
user avatar
  • 351
3 votes
1 answer
2k views

How to split comma-separated values for Pivot Table?

I have data which has the following format: Electricity Electricity, Cooling Electricity, Heat Electricity, Heat, Cooling I want to use this data in a Pivot Table so I can count the number of items. ...
user avatar
  • 333
3 votes
1 answer
1k 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 ...
user avatar
  • 140
3 votes
1 answer
55 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 ...
user avatar
  • 151
3 votes
2 answers
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 ...
user avatar
  • 31
3 votes
2 answers
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 - ...
user avatar
  • 131
3 votes
0 answers
147 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 ...
user avatar
  • 41
3 votes
0 answers
2k 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....
user avatar
3 votes
0 answers
267 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 ...
user avatar
3 votes
0 answers
84 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 ...
user avatar
  • 174
3 votes
1 answer
720 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 ...
user avatar
  • 560
3 votes
1 answer
387 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 ...
user avatar
3 votes
0 answers
246 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 ...
user avatar
3 votes
0 answers
992 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 ...
user avatar
  • 131

1
2 3 4 5
161