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.

6,338 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
6
votes
3answers
41k views

Can't exit design mode because Control 'xxxx' can not be created

What is the cause of this error and how do I fix it? This started occurring on a workbook of ours for reasons unexplained. I made a tiny change to the VBA code behind it, just plotting slightly ...
5
votes
2answers
241 views

Microsoft Office Tools- permanently remove author name

I am having some trouble with Microsoft Office tools, I want to permanently remove the author name from all future created documents. Word, Excel, etc, keep pulling my computer login username (Lets ...
5
votes
1answer
569 views

Create PDF from an Excel file without margins in Windows 7

This question is kind of answered, but that solution doesn't work for Windows 7. I've set margins to 0, no scaling and put colored shape all over printable area (few columns and rows from A1), for ...
5
votes
1answer
2k 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 ...
5
votes
2answers
23k views

How can I create a “Cross-Join” in excel?

I have 2 sheets in excel, each with 10 rows. Is there some sort of "cross-join" formula/macro in Excel that allows me to create a 3rd sheet with all rows cross-joined (100 rows in total).
4
votes
1answer
80 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
141 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 ...
4
votes
1answer
537 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
4k views

Excel bug? Inconsistent behavior when Cut/Copy-Pasting across filtered data

Problem I'm seeing the following inconsistent behavior in Excel 2016, when Copying/Cutting/Deleting data across filtered data: Copying Cells: Data gets "copied" from the visible cells only, and not ...
4
votes
0answers
345 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 ...
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
1answer
1k 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
7k 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
3k 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 ...
4
votes
1answer
893 views

Create line graph with embedded horizontal histogram

How do I create these kinds of graphs: with the horizontal histogram counting the number of times the left graphs go through a certain range? I have access to Microsoft Excel and R.
4
votes
2answers
1k views

How do you format an Excel date to represent >31 days with hours, minutes and seconds

Let's say A1 contains a value which is the number of days in duration. Example: 57.121875 That number represents the number of days. I would like to use an excel format which ultimately makes it ...
3
votes
1answer
35 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
0answers
15 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
0answers
272 views

Stop Excel chart from changing series formatting

I have an Excel bar chart that is formatted exactly the way I like it. The bar colors, the label fonts, the grid lines, etc, etc. Here is an example: Notice the awesome formatting of the second ...
3
votes
1answer
53 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
236 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
659 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
3answers
36 views

Add only working days in grid style using Microsoft Excel

I like to have a calendar date view of the five working days in Excel. I manually built a first row with dates from 30th July 2018 to 3rd Aug 2018 (Mon to Fri, which are working days) and a second ...
3
votes
0answers
762 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
1answer
98 views

Copying non-adjacent Excel rows/columns to a text editor?

I would like to manually copy data from non-adjacent Excel rows (or columns) and paste it into a text editor. So far I haven't found a way to do this efficiently. (I'm using Excel Home/Student 2013.) ...
3
votes
1answer
287 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
47 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
491 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
1answer
3k 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. ...
3
votes
0answers
112 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
475 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
102 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
0answers
60 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
0answers
115 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
211 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
174 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
1answer
486 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
995 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
3answers
112 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 ...
3
votes
1answer
40 views

Excel is closed, but using a lot of resources

Versions: Office Home and Business 2016 (last updated 1/?/17) Windows 10 (last updated 4/5/17) Issue: For the past few days... possibly since the last Windows 10 update (two days ago)... my fan ...
3
votes
0answers
527 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,...
3
votes
2answers
906 views

How do I reorder sheets in specific order, then alphabetically?

I need to reorder my sheets in a specific order, then if there are any left, do it alphabetically. I have the macro below to reorder them alphabetically. If i have sheets ""METALS", "SVOC", "GENCHEM"...
3
votes
1answer
851 views

How to change the default 'fill-in' color in Excel for Mac?

When you're in Excel, you can fill a cell with a color (the icon is the paint bucket with yellow paint spilling out). I want to change that so the default color is green, not yellow as it always is. ...
3
votes
1answer
81 views

Timeout error itgenerr024 when trying to import data from Exact Online into Microsoft Excel with Invantive Control

When I execute the query I get the following error after ten minutes: Error processing file 'c:\temp\in\GLTransactions\070-GLTransactions-2016-9-4-102.xml':Invantive.Data.OAuthException: itgenerr024: ...
3
votes
1answer
642 views

Is there a way to automatically download files from Gmail or Google Drive

Disclaimer: Ouside of a little VBA knowledge I am not a programmer. I have several Web-Intelligence reports that are scheduled to automatically run for my company. Ideally, we would have the reports ...
3
votes
0answers
400 views

When customizing the Ribbon in Excel 2016 on Windows, what governs Group layout within a Tab?

Is it possible for the layout and format of Command items in an Excel Ribbon Group to be controlled by the user (i.e. through "normal" use of Excel, without recourse to XML hacking or UI editors)? ...
3
votes
0answers
1k views

Imported XML occupying multiple rows?

I want to import an XML file into an Excel sheet in order to perform operations. When I import the XML file I get the following structure: As you can see, all variables are on different lines. Here ...
3
votes
1answer
904 views

Make dropdown list show hyperlinks

I have a collection of all the different part numbers for different versions of a single part, and each of them is hyperlinked to their specific different drawing in pdf form. I would like to put them ...
3
votes
1answer
3k views

Upgraded to Windows 10 - Macros Broken

Problem: I finally upgraded to Windows 10 and a few macros in Excel 2010 that I use frequently no longer work. They crash instantly when I run them and all I receive is an "automation error". They do ...