Recent Discussions
Microsoft 365 network connectivity test for Microsoft 365 Copilot Generally Available
I am thrilled to announce that the Microsoft 365 network connectivity test for Microsoft 365 Copilot is now generally available worldwide. Now all the customers can run the most comprehensive connectivity test of the history from https://connectivity.m365.cloud.microsoft . ✌️😁❤️ This release also includes two improvements from the user experience perspective: Enhancing the sign-in experience for smoother user interactions (like SSO) and providing more user-friendly guidance for saving report data. As a result, we can also measure tenant information with sign-in users, giving us better insights into the business impact of the tool. We also fixed a bug in the rich client that previously blocked the test process due to firewall warnings, increasing the completion rate and performance of the tests.
Hyperlink doesn't stay in the same row as the data in my Table
I made a worksheet with Dynamic search box using FILTER function and made another worksheet that has the Masterlist, i need to hyperlink Certificate records of the hospital staff the Table but when i put it on the row of someone specific the data becomes a plain text on my search box. i tried also hyperlinking the file on the searchbox as well but the hyperlink stays on the same cell and doesn't follow the row it should be in.
Find Which Emp Number is Associated with Which Person in a Data Set
Good Day! I'm unsure which formula to use, I have a data set that shows First Name, Last Name, Emp Number, and Dates Attended that is auto generated by who shows up in any particular day. (See attached Pic#1) I would like a formula that breaks down which names are associated to each number. So, for example if I type in '6167' into a cell it will show 'Tom Rock' is associated with that number. (See attached Pic #2)
xlookup not finding number/letter mix
I have a column consisting of part numbers: a mix of numbers and digit/letter combos, e.g 2, 3, 3a, 4, 5, 6, 6a, 6b, 6c, 7, 8 ...... I have formatted both the source column and the lookup column as text. But xlookup() only finds the cells which have both digits and letters (i.e. 3a, 6a, 6b, 6c...)
Populating Schedule based on two Criteria
Hi There - I am working on a master schedule for a camp that will populate two sheets, one that has a full weekly schedule for all groups (this part I've figure out), and the second sheet (or multiple sheets) that will populate the activity schedule. Essentially, I have a master schedule and want to be able to pull two smaller data subsets from it, one by group, and the other by activity. I'm open to any and all changes to make this accessible, thank you! Below is the master schedule with data My group schedule (I can drag and it will fill in columns, so easy there), Any adjustments to master will repopulate Art Schedule, for example, that I want to set up to auto fill in, so any adjustment I make in the master schedule will reflect here. Thanks in advance for any help!Power Query by Default Excludes First Blank Column
I have researched this down the rabbit hole long enough without any answers. In Excel I created a Power Query Get Data from Sharepoint Folders using the Contents method. There are about 10 files where the data is in the same format, columns match sheets are all the same name, etc.... FYI, None of them are setup as Tables for reasons I won't go into. They just can't. When I import the files 5 of the files have data in column A while 5 do not. When I import the data the files that do not have data in column A Power Query is automatically removing those columns from those sheets. Which then screws up the column order when the data is appended and loaded to the table. How can I force Power Query to bring in Column A even if some files column A are blank?Need help with a simple formula
Need help with what would be a simple formula for cell B11, B12, and B13. Cell B11 should be $150 (via the formula) Cell B12 should be $500 (via the formula) Cell B13 should be $15 (via the formula) Can someone help me figure out the formula for this? (note, there will be more than just 6 rows of data, this is just an example.... Thank you!!VBA to convert MMM DD YYYY to date
Hi All, I am looking for an Excel VBA code that would e.g. check in Col D if the date is already in date format and if not convert it from text to date format and repeat this for all populated cells in Col D. e.g. Col D Date Date 23/03/2025 23/03/2025 MAR 23 2025 MAR 23 2025 MAR 23 2025 MAR 23 2025 MAR 23 2025 MAR 23 2025 MAR 23 2025 Any help would be greatly appreciated, Thx so much
OneNote Section renaming issues - VERY annoying
While renaming a Section, OneNote seems to have some sort of short timeout timer where if you don't start typing quickly enough, or don't hit enter soon enough after finishing, it completely bails on the renaming operation and reverts back to the previous name. The timer seems to be shorter when creating a new section. Hitting the "+" pops up a new section with the section label in edit mode. If you don't type something quickly enough (< 3 seconds) - it exits edit mode and leaves the label as "Section X". For section renaming, if you double-click on the section tab label, the label switches to "edit" mode and the full label is highlighted. If you wait too long to start typing, it either exits edit mode by itself or waits until you type something (anything) and exits edit mode completely ignoring what you typed. If you do type something but don't finish immediately by hitting enter, the timer expires and any keyboard input after the timer expires causes edit mode to exit and the new label you typed to be ignored. It seems this might be intentional (Ill-conceived) behavior - attempting to prevent inadvertent renaming of sections if someone accidentally presses keyboard keys or puts something on their keyboard that causes inadvertent keyboard presses. If that's the case it's an exceeding clumsy attempt and needs to be rethought. The current behavior in this regard is very annoying. If the desire is to ignore inadvertent section renaming, a study needs to be done to understand the characteristics of accidental keypresses. I'd be willing to bet that rapid same-character sequences that result from the same key being pressed and held are much more indicative of inadvertent input than the total time taken to start or finish a renaming operation after edit mode is entered. You could also create an additional hurdle to enter edit mode e.g. eliminating the doubleclick option and only allow right-click followed by drop drown menu selection. Has anyone else experienced this? Has Microsoft ever commented on this issue.
what happened to "value from cells"?
In a chart: Data labels, more options, format data labels, label options, label contains value from cells Usually it the option is there, today, sometimes/mostly, it is not. These are x-y scatter graphs. Once I thought it came back after pressing 'f' which is the shortcut key, but if it worked, it only worked once.Word doc compare refresh
Hello, Have not been able to find anything on this. Is there a way to refresh your MS Word compare documents within the compare feature if you notice changes you want to make outside of what is shown in the compare results without needing to redo the compare? Similar to having a refresh key in excel to update a pivot table when you change information in the source document.need help
I want to create a excel table for my workers, special for working ours where they can put our of work in table I create, but,i want to protect information after they put that ,is there a way I can make auto lock or something on cels after they put info how much they works they can't change later..
Events
You’re passionate about what you do, and we’re passionate about empowering your potential. The Microsoft 365 Community Conference is your chance to keep up with AI, build game-changing skills, and ta...
In-Person
Recent Blogs
- Version 2501 (Build 18429.20132) Bug Name Issue Fixed Ctrl+W doesn’t close the query window when using Monaco SQL Editor Several keyboard shortcuts that were not...Mar 21, 2025
- Boost your productivity with Microsoft 365 Copilot! Discover how to crush your daily tasks and save time.Mar 14, 2025
