Recent Discussions
Sumif inside Xlookup
Can someone tell me how to sum within Xlookup please? Correct answer above would have been 65+5=70. I am looking for total qty, if part is "F" and Location is "OM". Main Table has two matches. My current Xlookup formula only selects one record. This Xlookup formulas only works for one unique record. Thank you in advance.
mac Excel: can't select form Group Box
Hi, I'm using Excel 16.107 on a Mac. I have Developer mode enabled and placed form elements, including group boxes. What I've found is if I delete the text label for a group box, the group box then becomes impossible to select -- there's nothing to click on with my pointer. See attached. Any attempt merely selects the cell, not the group box. How can I select group boxes like this, so that I can delete it or edit its properties?
Calculating and adding time
I am trying to figure out how to automatically calculate time differences for a delayed racing start time. I have: a rating which provides a handicap correction factor: PHRF Tod A Sec/ Mile correction number A Total correction in Seconds (based on a distance) This I figured out. I have a set start time for the first entry at 11:00:00 I need to figure out the Start time for the delayed boats as shown in the diagram, but I don't know what formulas will do this. This diagram is taken from a pdf document.
Correlation Study with Filters
Dear Experts , I have a data like below( Attached worksheet) And want study the correlation between SNR[0~3], there will be 6 combinations as below:- I want make like this but with Filters/Slices for the "File.Name" & "SSB or TRS" & "Carrier Index", different colors for different Carrier Index(0 &1) Thanks & Regards Anupam Shrivastava
Why is my create file from OneDrive for Business node isn't working?
I have a power automate cloud flow that, in some point, gets a word .docx from my sharepoint site, then it creates the same document in onedrive so that I can convert it to PDF then returns it to sharepoint. This idea came from the necessity of converting a .docx to .pdf without the need of premium conectors. I have 2 scenarios: 1° Scenario: Flow: I get the data from the word that I need > I create the same file on OneDrive > I convert the file to .pdf > then I create the file on Sharepoint. Problem: When I run my flow, it gets a 404 error: "message": "File Not Found\r\nclientRequestId: y-f695-48b1-9556-xc\r\nserviceRequestId: x-e051-b000-efc3-y" Error image: 2° Scenario: Flow: The same as the above, the only thing I did after research, is that the node that I get content from file from my sharepoint site also returns the "$content-type", so I specified that for the create file from OneDrive I'll only want the "$content" attribute. In resume, it creates the file in onedrive but I can't open it, it appears to be corrupted, at first I thought my sharepoint file was also broken, but then I could open it with no errors as on OneDrive. Problem: When I run my flow, it gets the error that it can't convert that kind of file (as I wrote above, the file creates corrupted), the main problem is understanding why it gets corrupted, it even returs the content-type that I'm not passing anymore. Error image: Message: "message": "Error from microservice: {\"status\":406,\"message\":\"Não há suporte para a conversão desse arquivo para PDF. (cannotOpenFile / Error from Office Service. Url=https://wordcs.officeapps.live.com/document/export/pdf HttpCode=BadRequest)\",\"source\":\"api.connectorp.svc.ms\"}\r\nclientRequestId: y-13f3-4e1a-a77a-x\r\nserviceRequestId: y-a09f-b000-f272-x" NB: This flow actually worked for more than 1 year with no problems like that, the last time it ran without errors was last week (6-7 days from today).MS Word is throwing up 'Error 4608' I haven't a clue what to do.
Hello, I wonder if anyone can help me here, because I am at a TOTAL los... I have a Word document that I have been updating for a few years, which is a sort of log. It has worked well up until today. Now, whenever I try to save the updated document, a very old fashioned (looks like Windows 3.1!), error message window appears which is headed 'Visual Basic for Applications' and in the window it says: Run-time error: '4608': Undefined dialogue record field There are then four buttons at the bottom labelled Help, Continue (which is greyed out), End and Debug. I have no idea what this error message means. Clicking on End gets rid of the error message, but prevents me from saving my updated document, and the next time I try to save it the error message just reappears. Clicking on Help takes me to a website with the title 'No F1 help match was found', followed by a load of technical computer-geek stuff I don't understand. Clicking on Debug seems to open a new window, but I do not know what it is... Here is a screen-shot of it: The highlighted text seems to refer to Bookmarks, which is throws me because I only associate Bookmarks with my web browser, not MS Word. I'm sure I haven't added any bookmarks to my document in any case. Can anyone enlighten me as to what is going on here please? Thanks
Events
REGISTER HERE
As content continues to grow, organizations need better ways to manage inactive data without sacrificing security, compliance, or discoverability.
Join us for an overview of how M...
Online
You’re passionate about what you do, and we’re passionate about empowering your potential. Microsoft 365 Community Conference - is your chance to keep up with AI, build game-changing skills, and take...
In-Person
Recent Blogs
- 3 MIN READAs SharePoint turns 25, we’re taking a moment to look back at how far it’s come.Mar 27, 2026
- Change is the only constant, but adapting to change isn't always easy. If we consider the celestial speed at which technology is evolving, keeping up with every trending tool can be daunting. An ecos...Mar 26, 2026
