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.0Views0likes0CommentsDelimiter to be used
Dear Experts, I have a data like below:- So, each sub Packets[x], if has data will have Common and Chain as below, I want to bring Chains in the same level as the common, like this:- What delimiter shall , I use, to achieve this. Thanks in Advance, Br, Anupam95Views0likes2CommentsHyperlink 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.79Views0likes1CommentFind 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)50Views0likes1CommentHaving an issue with creating a navigation panel
I'm having an issue when I try to create a navigation panel, as you can see its greyed out and I'm able to click on it. I have tried googling and I cannot seem to find an answer as to why this is happening. Any help is appreciated.30Views0likes1CommentRuntime error 1004: Unable to get the Xlookup property of the worksheetfunction class
I have the current MS Office 365, and am using Excel. I created a button on Sheet1 to click [Change Member Details] On click, the fields on the form are initialized, with only those to use for the search being made visible on the "UpdateMemberForm". The user form prompts for required search input (member number, or a phone number, or a combination of name and street address). I entered the member number, and clicked the [Find Member] button on the "UpdateMemberForm". The "WorksheetFunction.XLookup(I_Mem_Num, "A:A", "A:V")" was to search Sheet1, column A, and return the string of data to an array "GetMemberData" that I wanted to subsequently display in all the fields on the user form. The data was to be simply read, or allow for record change/correction and written back to sheet1, or deleted if [Delete Member] button was clicked. The member numbers are in Sheet1 Column A. Each record row is contained within columns A through V. As a test, I used a member number that I knew was in Sheet1 column A. This is the code I am using that returns the error: Runtime error 1004: Unable to get the Xlookup property of the worksheetfunction class, highlighting the XLookup code line. ' >>>>> UPDATE MEMBER <<<<< ' Sub RectangleRoundedCorners3_Click() Set Sheet_Name = ThisWorkbook.Sheets("Sheet1") Dim Array_Count As Long Dim SetSwitch As Boolean Dim GetMemberData As Variant ReDim GetMemberData(0 To 22) As Variant Load UpdateMemberForm UpdateMemberForm.Show End Sub __________________________________________________ ' ' >>>>> Begin User Form Data Input <<<<< ' ========================== Private Sub I_Mem_Num_Enter() I_Mem_Num.BackColor = vbYellow I_Suburb.Visible = False I_Postcode.Visible = False I_Birth.Visible = False I_Age.Visible = False I_Comment.Visible = False I_Email.Visible = False I_Mem_Status.Visible = False I_Mem_Receipt.Visible = False I_Mem_Date_Paid.Visible = False I_Joining_Date.Visible = False I_Film_Fee.Visible = False I_Film_Receipt.Visible = False I_Film_Date_Paid.Visible = False Mem_Category.Visible = False Btn_Gender_Male.Visible = False Btn_Gender_Female.Visible = False Btn_Gender_Other.Visible = False Btn_Vote_Yes.Visible = False Btn_Vote_No.Visible = False Btn_Photo_Yes.Visible = False Btn_Photo_No.Visible = False End Sub Private Sub I_Given_Enter() I_Mem_Num.BackColor = vbWhite I_Given.BackColor = vbYellow End Sub Private Sub I_Surname_Enter() I_Given.BackColor = vbWhite I_Surname.BackColor = vbYellow End Sub Private Sub I_Phone_Enter() I_Surname.BackColor = vbWhite I_Phone.BackColor = vbYellow End Sub Private Sub I_Phone_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean) Stop_Switch = "Go" Do Until Stop_Switch = "Stop" If IsNumeric(I_Phone.Text) = False Then I_Phone.Text = InputBox("Please enter 8 or 10 digit phone number ") ElseIf IsNumeric(I_Phone.Text) And Len(I_Phone.Text) = 8 Then I_Phone.Text = Format(I_Phone.Text, "0000-0000") Stop_Switch = "Stop" Exit Do ElseIf IsNumeric(I_Phone.Text) And Len(I_Phone.Text) = 10 Then I_Phone.Text = Format(I_Phone.Text, "0000-000-000") Stop_Switch = "Stop" Exit Do Else Stop_Switch = "Go" End If Loop End Sub Private Sub I_Street_Enter() I_Email.BackColor = vbWhite I_Street.BackColor = vbYellow End Sub Private Sub L_Mem_Num_Click() End Sub __________________________________________________ Private Sub Btn_Find_Member_Click() SetSwitch = True ReDim GetMemberData(0 To 21) As Variant Do Until SetSwitch = False If I_Mem_Num.Value > 0 Then MsgBox I_Mem_Num GetMemberData = WorksheetFunction.XLookup(I_Mem_Num, "A:A", "A:V") MsgBox GetMemberData SetSwitch = False Exit Do As a further test, I created Sheet2 using A1 as the record number input to search, with the Xlookup formula in Sheet2, A3. It read the data on sheet1, and returned the array of values from Sheet1 A to V, and worked perfectly. =XLOOKUP(A1,Sheet1!A:A,Sheet1!A:V) Help with a solution to this problem would be greatly appreciated. Thank you in advance.Solved15KViews0likes4Commentsxlookup 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...)64KViews0likes17CommentsPopulating 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!27Views0likes0CommentsPower 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?107Views0likes4CommentsNeed 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!!19Views0likes1CommentVBA 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 much26Views0likes1CommentOneNote 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.1.6KViews4likes3Commentswhat 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.11KViews0likes16CommentsWord 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.1.3KViews0likes3Commentsneed 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..14Views0likes1Comment
Events
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, 2025226Views2likes1Comment
- Boost your productivity with Microsoft 365 Copilot! Discover how to crush your daily tasks and save time.Mar 14, 20251.3KViews4likes3Comments