Recent Discussions
Agent in SharePoint option is not visible in the M365 admin center
Agent in SharePoint option is not visible in my M365 admin center under pay as you go service and it's only show Syntex services option not the Agent in SharePoint. As before we were able to see both options like Agent in SharePoint and Syntex services but now Agent in SharePoint is not visible. I have also attached the screenshot where both of the options were visible but now the Agents in SharePoint option is not visible, so is there new update in admin portal or is this is some kind of issue?15Views0likes1CommentExternal people can't open files with Sensitivity Label encryption.
Question: What are the best practices for ensuring external users can open files encrypted with Sensitivity Labels? Hi all. I've been investigating proper setup of sensitivity labels in Purview, and the impact on user experience. The prerequisites are simple enough, creating and configuring the labels reasonably straightforward, and publishing them is a breeze. But using them appears to be a different matter! Everything is fine for labels that don't apply encryption (control access) or when used internally. However, the problems come when labels do apply encryption and information is sent externally. The result is that we apply a label to a document, attach that document to an email, and send it externally - and the recipient says they can't open it and they get an error that their email address is not in our directory. This is because due to the encryption, the external user needs to authenticate back to our tenant, and if they're not in our tenant they obviously can't do this so the files won't open. So, back to the question above. What's the easiest / most secure / best way to add any user we might share encrypted content with to our tenant. As I see it we have the following options: Users have to request Admins add the user as a Guest in our tenant before they send the content. Let's face it, they'll not do this and/or get frustrated. Users share encrypted content directly from SharePoint / OneDrive, rather than attaching it to emails (as that would automatically add the external person as a Guest in the tenant). This will be fine in some circumstances, but won't always be appropriate (when you want to send them a point-in-time version of a doc). With good SharePoint setup, site Owners would also have to approve the share before it gets sent which could delay things. Admins add all possible domains that encrypted content might be shared with to Entra B2B Direct Connect (so the external recipient doesn't have to be our tenant). This may not be practical as you often don't know who you'll need to share with and we work with hundreds of organisations. The bigger gotcha is that the external organisation would also have to configure Entra B2B Direct Connect. Admins default Entra B2B Direct Connect to 'Allow All'. This opens up a significant attack surface and also still requires any external organisation to configure Entra B2B Direct Connect as well. I really want to make this work, but it need to be as simple as possible for the end users sharing sensitive or confidential content. And all of the above options seem to have significant down-sides. I'm really hoping someone who uses Sensitivity Labels on a day-to-day basis can provide some help or advice to share their experiences. Thanks, Oz.101Views0likes18CommentsHow to filter visible cells by formula after applying filter to a dataset.
I have a dataset from A1:B11 (in real case many more). I apply a filter on dataset, for example filter data for Retailer1 and Retailer3. I want on a separate sheet to filter these visible cells using formula (not VBA). Preferably using a generic LAMBDA function like =FILTERVISIBLE(A2:B11). Any thought or idea to achieve it?Solved52Views0likes6CommentsExcel formula to determine missing numbers
In column S of Sheet 1 I have a list of case numbers. They all start with the year that the incident occurred &, followed by the incident number. On Sheet 2, I want to be able to quickly determine if any numbers in the sequence have been skipped. For instance, 2024-033, 2025-001, 2025-003, etc. There are never a set number of cases per year, so it wouldn't matter whether there should've been a 2024-034 after #33, but I would need to be able to readily see that 2025-002 was never input. If it matters, each year begins with '001' and not '000' and I'm working with Excel 2016.71Views0likes3CommentsAllow hidden fields
Hi DingkunXie Can the product team do the following: Create an option to make a field hidden or read-only Allow URL parameters to populate the hidden or read-only field Currently we can use a workaround to hide a field using branching logic, but the hidden field can't be prepopulated with the URL parameter :( This small change will unlock a huge amount of value in the product! Especially in the age of automation and Copilot. Looking forward to seeing this happen :)27Views0likes1CommentHow to create a formula
In Excel, I am trying to create the formula N/5/4.5 = For a rubric in which I can enter any number into the n part of the equation. I'm trying to do this so that I can have a list of numbers generated from that equation for whichever number n represents. How do I do that?47Views0likes2Comments- 25Views0likes1Comment
Section Headers and Footers - 'Same as previous..'
Hi All Just seeing if anyone has a workaround for section headers and footers issue i'm having.... I have a document that multiple sections, each section has a 'Different First Page Header/Footer' as there are different header images for each section. The footer is pretty standard across the document - page numbers and specific document info... My document has..... (for example) Section 1: First Page Header/Footer (page 1) Section 1: (pages, 2, 3, 4, 5) Section 2: First Page Header/Footer (page 6) Section 2: (pages 7, 8, 9,10) and so on.... If i try 'Same as Previous' on 'Section 2 First Page' footer (page 6) it takes the footer text from 'Section 1 First Page', rather than Section 1: Page 5 If i try 'Same as Previous' on 'Section 2: Page 7' footer, it takes text from Section 1: Page 2, rather than Section 2: First Page: page 6 Is there any way of just making the footer continuous across the whole document? without changing the header which is different for each section.?? At the moment i'm having to edit each footer for each section which can be tiresome at best. Anyway, hope that makes sence Thanks for your help in advance. JSolved30Views0likes2CommentsAccessing an App through 'Open in new window' from Teams only opens file error
Hello, I have deleted an Excel file from a SharePoint folder that I don't need anymore. Now, when I try to open Excel 365 from 'Open in new window' in Teams, I don't get to the usual landing page with recent files, options for a new file, etc. but just an error message: 'Sorry, this file has been deleted or moved', referring to the file that I have indeed deleted. I can access the usual landing page if it's in the Excel 365 window embedded in Teams, but opening the app in a new window is no longer possible. Why would the landing page for opening an app in a new window not be the normal landing page, but just an error message, with no option to open another file, seems counter-intuitive. Does anyone have a solution? Best regards, MJSolved24Views0likes1CommentGroup objects
Hi, I am a longtime user of Word. I have just transferred to a new and stronger laptop; however, when trying to group more than 5 items Word stops responding and sometimes crashes. I disabled all add-ons, hoping it would help. Any ideas? I usually insert the figure in a table and just group the callouts and text boxes with arrows.12Views0likes1CommentEN-GB locale number formatting
Number format string "#, # # 0 ;[Color3] (#, # # 0 )" is not working when Excel is installed with en-gb locale. Any other language works but en-gb fails to parse "Color" - and expects it to be "Colour". Why is excel not following standard openXML in case of en-gb? How does one solve this portability issue when the workbook is generated on the server?28Views0likes1CommentButton with macro is not functioning
I created a macro. Then I added a button and added the macro to the button. When I press the button I get a message: the macro can not be executed. If I execute the same macro without using the button, there is no problem. What am I doing wrong?41Views0likes2CommentsConditional Access enforces MFA but Service Account still ask to secure account
Hi, I've setup Conditional Access policies to enforce MFA. But it excludes a group for service accounts. Whenever we login to a Service Account, they all ask to secure your account. Hit next > It says no MFA options are available > Skip. Both our own MFA conditional access policy and MS per-user conditional access policy excludes this group. The Legacy per-user authentication policy has all accounts disabled there in favour of the conditional access policy. We must be missing something here. Some of these are shared inboxes, others regular user accounts. Many of these services requires login through the typical Microsoft sign in screen to authorize access. Some does not support OpenID. So how do I 100% exclude service accounts from MFA? And how do I get rid of this popup to secure these accounts when it says no MFA options are available? TIA16Views0likes1CommentCaptions for images, including sub-captions
Good morning, I’m using Office 365 (Office 2019 at home). I wanted to ask if it’s possible in Word to create captions for images, including sub-captions, with all the corresponding indexes reflecting the hierarchy. I mean something similar to the photo below.69Views0likes4CommentsTable Properties for table inserted into Word document
Where can I find the default settings for Table in Word? Currently when I insert a table, I might find the row not wide enough. And often, it was because of the row height being set as "exactly" and I have to set it as "at least". Where can I set the default as "at least" so that it does not always use "exactly"?46Views0likes7CommentsRange showing (table array) in the wrong place
I’ve got a VLOOKUP pulling data from another excel file (sources.xlsx) the formula works as intended it's pulling the right department names based on id number, but here’s the weird part, when I double click the formula to check it, the table array ($A$2:$B$23) gets highlighted in the current sheet instead of the actual source sheet (which is in the other file). The data is still coming in correctly, just excel is showing the range in the wrong place. Is this normal when referencing another workbook? I never experience this before, and I am not sure if it new thing or a bug Example61Views0likes1CommentData Validation Conditional Formating
I have a shared spreadsheet where coordinators enter staff codes for particular tasks they would like them to do (it's not a timesheet, just a future planning tool). I have set up a data validation to warn them if they enter a staff code that is not in the list, however if someone leaves after their code has been entered, the validation doesn't re-check so the now-invalid code remains happily in the spreadsheet. I need the cells to highlight if the staff code is not in the list. Does anyone know if this is possible? Currently, I need to search for each code as someone leaves and manually remove them from the spreadsheet and then ask coordinators to re-enter new values. It would be great if it would just flag them in red when I remove them from the staffing list and coordinators can see if there is (now) an error that needs fixing. Not sure how to attach a file as it's not 'link'able with a URL, so here's screen shots:50Views0likes2Comments
Events
Recent Blogs
- You used to have to rely on external tools to crop a picture before putting it in OneNote. Not anymore!Oct 09, 2025191Views1like0Comments
- Thanks to new enhancements in how images are anchored to surrounding text, screen readers can now detect and navigate floating images effectively.Oct 07, 2025437Views0likes0Comments