Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

4
votes
0answers
61 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
0answers
265 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
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 ...
3
votes
0answers
358 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
0answers
99 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
0answers
281 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
86 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
49 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
156 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
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
0answers
554 views

How to setup a CSV web datasource

In Excel, I can import a CSV from the web as text by simply pasting in the URL as a file name, but when I ask Excel to update, it has stripped the URL and tries to find a file on the local hard drive ...
3
votes
0answers
775 views

File in use when it's really not

I am running Windows 7 Professional 32 bit on a Server 2008 network. I am getting a weird issue with an excel document where I open it up one morning, update it, save and close, the next morning I ...
3
votes
0answers
7k views

Excel: #NAME? appearing when linking/referencing other spreadsheets/workbook cells

I'm updating a spreadsheet that refers to data in another worksheet =NameofWorksheet for some reason I get #NAME? in some of the cells, even when the actual path is correct. The only way to overcome ...
2
votes
0answers
20 views

Excel for Mac conditional formatting not working (at all)

My Conditional Formatting button stopped working (MacBook Air, MacOS Mojave 10.14.2, Excel 2016). This is true for existing files with the formatting done previously, and new files. None of them are ...
2
votes
0answers
50 views

How to fix error in VBA code

I am trying to email the sheet within workbook, sometimes the code works but sometimes returns an errors. This line kicks error is,: If Dir(FileCell.Value) <> "" Then Error says: Run-time ...
2
votes
0answers
82 views

Excel 3D Flat Map

I am trying to display some data on the flat version of the 3D map. But unfortunately the map cuts off down the middle of the pacific ocean so half my data is on one end of the map and the rest on the ...
2
votes
0answers
19 views

Prevent MS Word Linked Tables from using Sharepoint Link

When I shift+F9 on a table in a word document I've linked to a local excel document, it seems to prefer to use the sharepoint web address rather a local or relative address. How do I force MS word to ...
2
votes
0answers
47 views

Excel prepends extra line (but not carriage return) in mult-line cells

Sometimes I use ALT + ENTER to make multi-line cells. However, Excel often appears to prepend an extra line for some reason, even though it's not an actual carriage return. Usually, you can adjust ...
2
votes
0answers
137 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 ...
2
votes
0answers
34 views

Excel displaying duplicate decimal places on any cell formatted as currency

I am an Office 365 subscriber and Excel runs nearly perfectly for me. Every issue I had with the software, I was able to solve by googling around, except this hair pulling glitch I am having (for a ...
2
votes
0answers
26 views

Excel - updating linked cells from the clone

I work with a pricing spreadsheet, which has hundreds of inputs, but in reality I only tend to work with 5 or 6. I want to create a summary worksheet where I only have the inputs I want to ...
2
votes
0answers
82 views

Automating creation of this chart in Excel 2016

I am trying to figure out a way to create this graph automatically on Excel and link it to PowerPoint so that when the data in Excel gets refreshed, the PowerPoint chart gets updated as well. ...
2
votes
0answers
29 views

MDS Excel add-in multiple entities in one xls file

We have a couple of issues that might be bugs. At least we cannot find any fixes or help on the web. We have an Excel sheet with a sheet per Entity. All data comes from the same MDS. First problem ...
2
votes
0answers
556 views

Compare 2 text cells and show or count difference

Let's say we have: cell A1 = blabla aaa cell B1 = blabla bbb What kind of formulas are to be used in order to get the number of differences between the two texts? (It should return 3, here, or ...
2
votes
0answers
78 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 ...
2
votes
0answers
937 views

Unable to change Minimum & Maximum on Excel chart axis

Sometimes when I'm making a graph in Excel, the program won't let me change the minimum or maximum on the axis. If I try to change the number, then the entire number disappears and I can't input a ...
2
votes
0answers
49 views

Dropdown Lists in both Excel and Open Office

I have an Excel workbook which works as a time sheet. Users select the project they worked on and how many hours they spent on it that week. The project can be selected from a dropdown list showing ...
2
votes
0answers
167 views

Newly opened Excel not counted on Workbooks.Count

I have a VBA macro that waits for another application to generate a new Workbook, however, as I run Workbooks.Count it doesn't count the newly generated file. It seems that the new Workbook opens on ...
2
votes
0answers
613 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 ...
2
votes
0answers
463 views

How to get index to look over multiple ranges?

So I'd like, for various reasons (mostly to get equations further down the line to work) to call multiple ranges the same thing. Ok, doable in name manager. Lists is now defined as A1:A10,C1:C10. ...
2
votes
0answers
1k 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 ...
2
votes
0answers
1k views

Automatic update of powerpoint graphs from a linked excel

So I've been having a bit of a problem recently, I somewhat solved it, but I'd love to see if anyone has a better suggestion. I have created a powerpoint file with a bunch of graphs using the simple ...
2
votes
0answers
148 views

Excel file Powerview worksheet not displaying in Application on VMware

Excel file PowerView worksheet not displaying in Application on VMware, Citrix (Not FAT-PC)  Only worksheet with PowerView Sheet not display in Excel file Brief Info: When imported in to specific ...
2
votes
0answers
1k views

excel lock data validation

I have an Excel spreadsheet which serves as a data dump/transfer facility from an in-house application. The spreadsheet also acts as a crude data-entry facility, as a modified spreadsheet can be ...
2
votes
0answers
810 views

Microsoft Office Document Version Control

I'm used to storing all of my documentation in TeX documents that live happily in Git and can be updated and committed at the same cadence as the code changes being documented. Sadly, I work in an ...
2
votes
0answers
73 views

Excel table only partly pasting into powerpoiint

I'm trying to paste a table into powerpoint and for some reason only part of the table is showing. I need to use copy/paste link as this powerpoint is often updated by different people every month. ...
2
votes
0answers
490 views

Return a max date from a range of dates but only if all cells contain a date

I am trying to get a formula that will give me a max date only if all cells have a date in them. If one cell contains a blank value or N/C I do not want the formula to populate a date in column R. I ...
2
votes
0answers
26 views

Excel no longer allows assignment of certain shortcut key combinations

When I switched to Office 365 from Office 2003 in 2013, three shortcut key combinations I had assigned to macros no longer worked: C+S+s, C+S+w, and C+S+x. Would anyone be able to tell me why?
2
votes
0answers
13 views

Mac OSX Excel 2016

I have a list of invoice lines. Each invoice line has a supply number and this can be repeated as many times as there are invoices. Each line has a from and end date for the supply and a consumption ...
2
votes
0answers
170 views

Excel timeline Conditional formating

I am trying to create a timeline that is followed by a conditional formatting in the columns. The time in the top left is the actual time as it is now, however it has been rounded to the lower 10 min. ...
2
votes
0answers
306 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)? ...
2
votes
0answers
391 views

How to force Excel to use English formats on non-English locale?

I'm using English Windows, English Office but my system locale is Czech. This unfortunately leaks into Excel: How do I get rid of this? I want my worksheet to be pure English (US) – all amounts in ...
2
votes
0answers
286 views

Expanding specific sections of a pivot table in Excel

I have a pivot table segmented by years, quarters and months. If I try to expand a quarter for 2015, however, the corresponding quarter in all other years are shown as well. How can I expand only one ...
2
votes
0answers
340 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 ...
2
votes
0answers
480 views

Printing multiple Excel tabs as a PDF document

I am trying to get multiple tabs of an Excel document to print as a multi-page PDF document. I activate the tabs that I want to print, and the print preview is exactly as I want it. Currently, it ...
2
votes
0answers
72 views

Data Validation - List - with the source of the list is in the raw data (has multiple copy of value)

I want to make a data validation in a list format in excel spreadsheet But I don't want to make a new sheet or any new table to put the list source first... I want to take a list source from one ...
2
votes
0answers
67 views

Cell auto adjust height when pulling data from other cells?

I've built a spreadsheet with a summary report that auto formats fine, except in situations where the text in one cell and is too long to fit into a cell. The report pulls info from cells under ...
2
votes
0answers
86 views

Legend-placement in two different charts is different with same settings

I have two charts, and in both of them I want I want to place the legend in the upper right corner of the chart-area like so: However when attempting to add a legend to the second chart, it is placed ...
2
votes
0answers
76 views

Copy hyperlinks from original list to search index list

I've created a search index (using formulas) from a list of products that have hyperlinks attached (created with Insert Hyperlink). The search index is created without the hyperlinks however. Both ...
2
votes
0answers
916 views

Excel does not update formulas values after filling source cells with values

I do 3 steps: Based on a template, I create a new Excel file through code (it works fine): Shared Sub FillExcel() Dim extension As String = ".xlsx" Dim sourcePath As String = "c:\Temp\libro" & ...