Recent Discussions
Populating a Matrix from a Table
I want to populate a matrix of sailing regatta competitors showing how each boat did against each of the other boats based on a list of matches. I have attached a simplified version with only four boats. The list of match results is on the left and the matrix I want to populate is on the right. In the matrix, I show by color which matches are on which day, but I'd prefer that a conditional format do that for me. In the matrix, the rows are the boats in Col. 1 of the table and the columns are boats in Col. 2 of the table. So for instance, for Day 1 / Match 1, Boat 1 (I6) would get aN "L" in K6, to show that Boat 1 lost to Boat 2. And Boat 2 (I7) would get a "W" in J7 to show that Boat 2 beat Boat 1. And those two cells (K6 and J7) would be green, as that is the color corresponding to Day 1 of the regatta. So how can I populate that matrix like that? And how can I conditionally format the color of the cell based on the day of the regatta?
downloaded worksheet file's formatting changes when saved/ copied to a workbook
So, I'm downloading a file which is automatically created from our data online, it downloads as a 'Microsoft excel worksheet' I then have a simple VBS which compiles all the individual worksheets together into one workbook. after this, the formatting changes for some small squares I have in the documents. Before: After: if it means anything, the colours available in the fill change too? I have tried creating a new document and adding the individual files, and it is fine, its just on the merge file it does this Something about the format of the template I have that compiles the individual files changes, and I cant work out why.. any ideas? Is it because it starts as a template, or because its a macro enabled workbook or something else?
SUMIFS with Criteria on Horizontal and Vertical Axis
Hi, Please I need assistance with SUMIFS function to get values between two dates which are on horizontal axis and a third criteria which is on the vertical axis. As shown in the attached image, I want to retrieve the sum of 'Weekly EPOS Units' from the table H2:N14 into column F3:F8 that fall between the dates in columns D and E, and with the Product ID in column C. I get the #VALUE! working with the data in this format. Thanks for your help!
Office 365 for ARM64
I am currently experiencing serious problems with Office 365 on an HP Elitebook ultra G1q notebook, Snapdragon® X Elite X1E-78-100 processor, Windows 11 Pro operating system. Outlook does not refresh, it takes a long time to send or receive emails, Microsoft Teams slows down and the screen freezes at times. I have AI completely disabled, but I am told that I need to get a version of Office 365 for ARM64. The thing is, it is supposed to install automatically when it detects that it is a Snapdragon processor, but when we check the installed version, it does not mention anywhere that it is for ARM64. This is happening with almost all notebooks of the same model in the company. We have other HP notebooks with Intel processors and this does not happen; everything is perfect there. Does anyone know how I can force the installation of Office 365 for ARM64? Thank you. Actualmente tengo serios problemas con el Office 365 desde una Notebook HP Elitebook ultra G1q, Procesador Snapdragon® X Elite X1E-78-100, Sistema operativo Windows 11 Pro. El Outlook no refresca, se demora un buen rato en enviar correos o recibirlos, Microsoft Teams se pone lento y se congela la pantalla por momentos. Tengo la IA totalmente deshabilitada pero me dicen que debo conseguir una versión de Office 365 para ARM64, el tema es que se supone debe instalarse en automático cuando detecte que se trata de un procesador Snapdragon, pero cuando comprobamos la versión instalada no menciona para nada, por ningun lado que es para ARM64. y esto esta sucediendo con casi todas las notebooks del mismo modelo en la compañia. Tenemos otras notebooks HP con Intel y esto no ocurre, alli todo perfecto. Alguein sabe como puedo forzar la instalación de Office 365 para ARM64? gracias
Printing in colour
Since Office updated (automatically) a couple of weeks ago, Word will not print any text in colour. It prints borders and pictures in colour so nothing wrong with the printer but the text all comes out in black. I have spent 1.5 hours with Microsoft on chat but they cannot solve it. They say nobody else has reported this but has anyone else had this problem?Form can not send data to sheet - in company domain
Dear sir, Company domain: catensys.com We use Microsoft enterprise platform, we found one issue today: When we submit form answer, it do not send data to sheet. Form record list 4, but sheet only have 3 rows. And sheet display note: 10% synchronized. This workbook is checking for any changes from Microsoft Forms. Please support us to solve this issue. Thanks!how do I copy text from word to another program without comments.
I open a word document from my onedrive. I switch the word document to read only so I don't accidentally modify it. i turn on review column so I can see the comments. I need to see paragraphs with comments. I need to copy text without comments. I want to select a paragraph that has been commented on and copy the text to a non-microsoft program that I can then work on the text. when I select the paragraph, and copy, then switch app, then paste, the comments and initials of the editors appears in the text. i never, ever, want to copy comments under any circumstances whatsoever. how do I tell word that when copying text, copy just the text. My 'review > display for review' is set to no markup. but the comments still copy. When I copy text and put it into another program, it is FULL of this sort of thing, with a whole bunch of comments at the end of the paragraph. No matter what I do in Review, the comments always come with the text.
Internal links broken when PDF'ing from Word
This issue began for me and several team members recently. (It then resolved itself and now is not working again.) We are using Adobe Acrobat Pro DC through Creative Cloud Online and Microsoft 365. The issue: When creating a PDF from a Microsoft Word document, hyperlinks created in Word should be retained in the PDF'd copy. However, for us, the external links (to webpages) are retained, but the internal links (to places within the document and the Table of Contents links) are not. The way we create PDFs is by using the Acrobat toolbar in MS Word. In the Preferences settings, "Add Links" is checked. To launch the process, we select "Create PDF" which generates the PDF. I have tested the same file outside our work environment - on my personal computer (I also have Adobe Acrobat Pro DC through Creative Cloud online), and all the hyperlinks are retained (both internal and external). So the problem is not the Word file itself. It seems to be environmental. Could this be a problem with the Acrobat toolbar add-in, or maybe a security problem? Any ideas are welcome. Thanks in advance. (We often have multi-hundred documents and manually linking within the Acrobat PDF file is really not a viable option.)
best way of returning data from a table
Hi I have a worksheet showing a materials list column headers include Job Type, Item number, description, purchase cost, quantity, price, vat Would like to be able to have a separate worksheet where you can enter a 'job type' and have all the materials that are related to that job type pulled through and displayed. Some materials are used for multiple job types though. What would be the best way of doing this? Have tried the FILTER function which works to display the correct materials but requires changing the formula and can't work out how to use this from data entered in a cell. Can anyone help please?Excel selects wrong cell
Hello, I am here to report on what seems to be a common issue... After working for a few minutes in excel, when I go to click on a cell, the wrong cell actually gets selected, and it is usually several cells above or below the cell my mouse is hovering over. I sometimes have success in saving, closing and reopening the book, but not always. Excel Office 365 version, updated on schedule, as always.Keyboard Shortcut
Hi All This is a nice simple one! Recently switched from a Win10 desktop to a Win11 very similar machine - yes, I know, antediluvian, but so am I! I transferred a large Excel spreadsheet from the old machine to the new and in so doing lost a small shortcut function that I simply cannot remember how I installed originally. On the old machine on each row I would type "Re" in a cell and press the space bar once, and the word Remittance appeared in the same cell. Sounds trivial, but there are lots of rows! Can someone please remind an old codger how to set this up. Many thanks and best regards. JimboConsolidating nutrition and price data from multiple sources into one Excel dashboard
I maintain a single Excel workbook that tracks breakfast-menu items calories, macros, allergens, and local prices pulled from several public sources like https://mcd-breakfast-menu.com/. Each source formats its table differently: some list energy in kcal and others in kJ; decimal separators flip between commas and periods; prices appear in four currencies. After each monthly update I hand-copy tables into a Raw sheet and try to normalise them with Power Query and a few LET and LAMBDA functions, but one extra column or unit change breaks my mapping. Has anyone built a durable workflow for problems like this? I am looking for ideas on (1) keeping unit conversions transparent so a non-Excel colleague can audit the maths, (2) alerting me when a source table adds or removes a column so the model does not shift silently, and (3) deciding whether to keep all cleanup in Power Query or move some logic into hidden staging sheets. Any real-world templates or processes would be welcome.
Updating excel database with values from another sheet
I have an original database (first image) which is filled with values. I have a second database which has the same schema but only contains the changes that need to be made to the original database (second image). I am wondering in Excel if there is a way I can merge the updates into the original database while keeping the entries that don't need updating the same. I believe a Power Query merge might hold the answers but so far I can only find how to append new rows or add columns, not specifically change existing values. I would do this manually but the actual database I need to update is very large. Feel free to ask if any more details is required. The end result is shown in the image with the red text. Thanks for any help you are able to provide!Welcome to the Excel Community
The Excel Community is a place we've built for all of you. You can learn more about how to do something with Excel, discuss your work, and connect with experts that build and use the product. With over half a billion Excel customers, we want to engage with you in fundamentally different ways and the community is a starting point for that. Our community helps answer your product questions with responses from other knowledgeable community members. We love hearing feedback and feature requests from you which helps us build the best version of Excel ever. If you have found an outage or a bug please post at our Answers forum. We look forward to getting to know you! Sangeeta Mudnal & Olaf Hubel on behalf of the Excel TeamThe 23 questions Form shows only 10 questions when shared for collecting responses
The Form (questionnaire) I created in Microsoft Forms (using an outlook.com Microsoft account) consists of 23 questions. Approx. half of questions is text input, half is multiple choice. All multiple choice options are within the 2-10 limit. It seems to stay within the limitations existing for number of questions, options, characters, etc... Yet, when the Questionnaire (Form) is sent out (shared) to be filled in (to gather the responses, using here the microsoft lingo), only the first 10 questions show up. What can be the issue? Please do not send me to More Settings path, there is nothing there that relates to the number of questions, etc...Microsoft Introduces Copilot Memory
A July 14 post announces Copilot Memory, a method to personalize how Copilot responds to user prompts. Controls are available to disable Copilot memory on a per-user and tenant basis. Manipulation of the tenant controls is done through a Graph resources. This article explains how Copilot memory works and how to update the tenant controls with PowerShell. https://office365itpros.com/2025/08/06/microsoft-introduces-copilot-memory/
Recent Blogs
- Whether you’ve just downloaded the Microsoft 365 Copilot app or are looking to get more out of it, you’ll want to know about these capabilities.Aug 06, 2025
- 1 MIN READThis year marks a major milestone—Microsoft Excel turns 40! In honor of four decades of innovation, we’re kicking off “40 Days of Excel”, a global community celebration spotlighting the features that...Aug 06, 2025
