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. Also add the the specific version tag (e.g. [microsoft-excel-2019] or [microsoft-excel-365]) as features and functions may vary between them.
8,610
questions with no upvoted or accepted answers
8
votes
3
answers
6k
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 ...
- 7,397
6
votes
2
answers
944
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 ...
- 217
5
votes
1
answer
905
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 ...
- 380
5
votes
1
answer
309
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 ...
- 283
5
votes
1
answer
2k
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,...
- 1,075
5
votes
1
answer
1k
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 ...
- 51
5
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 ...
- 153
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 ...
- 431
4
votes
1
answer
205
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 ...
- 133
4
votes
1
answer
3k
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. ...
- 343
4
votes
1
answer
781
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 ...
- 13.3k
4
votes
0
answers
57k
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 ...
- 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 ...
- 41
4
votes
4
answers
6k
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?
- 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 ...
- 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 ...
- 149
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 ...
- 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 ...
- 783
4
votes
1
answer
12k
views
Single-Window Mode for multiple worksheets
Is it possible in Microsoft Excel 2013+ (the plus currently means 2016 too) to open multiple sheets in the very same work space? Basically View=>Split but for different worksheets.
The reason I ask ...
- 884
3
votes
0
answers
518
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 ...
- 983
3
votes
2
answers
59
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 ...
- 31
3
votes
0
answers
513
views
Microsoft Excel: how to disable the "two click" requirement when Excel window doesn't have focus?
In Microsoft Excel, all versions as far as I can tell (office 2007 to 2019), implement window focus differently than any other Windows apps:
When Excel does not have focus (i.e. you're using another ...
- 854
3
votes
3
answers
3k
views
Open desktop shortcut to SharePoint directly in Excel
I have a desktop shortcut to a shared Excel spreadsheet that I use daily. It lives in a Microsoft Teams folder, i.e. on SharePoint. This shortcut opens a browser window asking me if I want to open the ...
- 111
3
votes
0
answers
458
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 ...
- 149
3
votes
1
answer
42
views
How can I use Excel to calculate the number of recent, consecutive fiscal years someone has made a gift to my company?
I am working at a nonprofit and we are trying to get a project off the ground where we send people postcards celebrating how many years they have been giving to us.
I am working with Excel in Office ...
- 39
3
votes
1
answer
39
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 ...
- 31
3
votes
0
answers
629
views
When importing CSVs, does Excel have a limit of 32,767 characters or 32,758 characters?
According to the documentation, Excel has a limit of 32,767 characters per cell.
However, when I save a CSV file that looks like this:
"Cell with exactly 32,767 characters........","...
- 715
3
votes
2
answers
52
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 ...
- 31
3
votes
1
answer
232
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 ...
- 55
3
votes
2
answers
483
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 ...
- 31
3
votes
0
answers
48
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
0
answers
61
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 ...
- 31
3
votes
2
answers
955
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 ...
- 31
3
votes
3
answers
6k
views
When a Google Sheet is exported to Excel the line heights of wrapped text are not maintained - any way to change this?
Ive got an issue when exporting an Excel file form a Google Drive Sheet.
If i have a large amount of text / data in a cell in Google Sheets i use the wrap text feature so that all the text is ...
- 3,983
3
votes
0
answers
89
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
1
answer
8k
views
Excel Formula to Translate Text into Target Language
I'm looking for a built-in Excel Formula Function to translate text into a target language. I see Google has made a function "GoogleTranslate()" available and was wondering if something equivalent ...
- 153
3
votes
1
answer
426
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?
- 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 ...
- 131
3
votes
0
answers
3k
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 ...
- 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, ...
- 461
3
votes
2
answers
4k
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 ...
- 391
3
votes
1
answer
2k
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 ...
- 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 ...
- 151
3
votes
2
answers
2k
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 ...
- 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 - ...
- 131
3
votes
0
answers
160
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 ...
- 41
3
votes
0
answers
3k
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....
- 31
3
votes
0
answers
309
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 ...
- 31
3
votes
0
answers
99
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 ...
- 174
3
votes
1
answer
744
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 ...
- 580