Recent Discussions
Entra-ID Privileged Identity Management for Groups
We have used PIM for groups to assign certain Azure Security groups to eligible users. For example a group which provides the contributor role to a certain subscription. This group is added in PIM for groups, and eligible users have been assigned to the group, in which they can provide themselves with the privileges if required to do so for maximum 8 hours. However, when we assign a user to a PIM protected group, then there is no way to tell from the user's properties, that the user has been assigned (eligible) to a PIM protected group. Therefore wouldn't it be better to create PIM groups and add the assigned user as a member of a PIM group, and assign the PIM group as eligible to the PIM protected group? Then you would able to see from the Groups list if the user is illegible for any PIM groups.
Transfer form Ownership to another personal user
Hi there, since I'm going to be unavailable for a couple of weeks I would like to transfer ownership of an internal form to another user who's taking over for me. I can only find the solution to transfer it to another group which is not suitable for my issue. How may I transfer ownership to another personal user?
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.Loops table rules broken
When attempting to create a rule on a table in Loops, I get the following: The "here" opens the Loop in a new tab. MS Support, through our corporate support, responded that the Loops product team was deprecating this feature and taking it out of the UI. There is a Power Automate trigger based on Loop triggers. The above seems unlikely unless there is a replacement in the works, such as using Power Automate. Does anyone know what gives here?Pivot Tables
Hello all, For some reason, I cannot create PIVOT tables anymore, and I am not sure why. I am using the online version of Excel, on Microsoft Edge. When trying to pivot my data, it will with show up blank, or not at all. Does anyone know how to fix this issue? Please see attached photos..
Reciprocate Relationship - how to setup
I think I almost have this...and then I don't. I'm creating a db that has a single 'Contact' table (ContactTbl - think 'Customer' table or 'Entity' table...). The table has both Organizations and Individuals - I do have a 'ContactType' field (Organization/Individual). I've created a form (ContactF) that brings in the OrgName, FName, LName....(the OrgName or F/LName fields are populated pending ContactType) - that's not the problem. I have a SubForm (RelationF) that...when an Org record is displayed on the Main/Parent form (ContactF), the SubForm (RelationF) shows all the Ind (employees) and their titles (titles in a free-form txt field for now). When an Ind record is displayed on the Main/Parent form (ContactF), the SubForm (RelationF) shows the Orgs that the Ind works for (has relationships with) and their title with that org (an Ind could work for multiple Orgs). I actually have this working but all the input in manual...in other words, if on XYZ Corp record and I add an Ind as a relationship, I have to go to the Ind record and create the relationship - that's the issue that I'm having...how can I have Access create the relationship automatically. In other words, when I'm creating the relationship from the Org record, I want Access to create the relationship on the Ind record (since I'm making that relationship through the SubForm. Same thing the other way around - if on the Ind Record and a relationship is created with an Org record, then have Access automatically create the relationship on the Org record. That way when viewing the records through the form, I can see the proper relationships: How can I have Access automatically create the relationship.
Automatic version history not working for self created document libraries
Hi, Our SharePoint environment is currently using the default version history number of 500. We were looking at lowering this because we're just consuming way too much storage. Last year we noticed that there was a new way to manage version history, automatically, which is also recommended by Microsoft. I finally got my head wrapped around on how it works, and we're doing some testing on it on just a few sites, but when I set it on a document library outside of the default "Document" library that comes with the site, it doesn't work. Nothing is set to expire even though there is lots of documents with aged versions that should have seen expiry dates by now. When I set it the versioning to automatic on the default "Document" library, it seems to work, as I do see files that have expiry dates. Is anybody else having a similar experience trying to use automatic version history?
Amortization Help
So I made a quick simple Amortization calculator to speed up some processes that I do but I've found so small calculation errors. For instance if I wanted it to calculated $7,268.00 over a 24mo term it come up with a payment of $302.83, which is correct, but because the actual payment amount is $302.83333333333 it doesn't calculated the right last payment which should be $302.91 to account for the repeating 3. I've found this is the only time it calculates wrong is just when the payment isn't perfectly round. Is there anyway to fix this? Again the only time I've found it to be wrong is when the payment doesn't calculate out perfectly round.Excel lookup help
Hi, I am trying to work out the formula in excel to look at a column (C12:C23) and if there is the same text more than once only return it once (A15). Then repeat this in A16 but disregard the value that was already returned already in A15 so it doesn't keep repeating. I have a list of descriptions that can be selected via a drop down list (image below C12:C23) and I need to bring them over to another sheet but not double them up if the description has been used more than once. It just keep doubling up. How can I do this? Thanks for any help with this.Clicking on an email address in a drop down list opens up Outlook
I have a form with one of the fields being Email Address (~100 entries). When our users get to this drop down, the list is shown as a hyperlink list of email addresses. Naturally, when they click on a selection, it opens Outlook rather than selecting the choice. The workaround right now is to click on the space after the email address. Is there a way to disable the hyperlinks so that the emails show as plain text?
Alternate to SUMIFS array assistance
Hello, everyone. I apologize for asking yet another SUMIFS question, but I haven't been able to find a thread anywhere (so far) that offers a sample similar to what I'm trying to do. I have a spreadsheet with 3 tables located in separate sheets: SKU, Production, and Expected. In the SKU table I have a list of item codes that are part of a general Category. In the Production table, I pretty much have a manual log of the number of Units that I produced in different Dates for each Item Code that applies. In the final table I pretty much just have a table with the Dates. The file I uploaded has a total of 4 columns in this table, but in my actual document the last 3 columns are actually arrays. I just placed them inside the table for purposes of this example. Anyhow, columns B-D are the Categories each Item Code belongs to: Blue, Green, or Red. What I'm trying to do is as follows: I'm trying to do the equivalent of a SUMIFs formula for Blue, Green, and Red. It first checks that the date in the Expected sheet matches the date in the Production sheet. Next, it checks in the SKU table which Category the Item Code belongs to for the selected date. It then adds the total Units for each Category column. I've tried with variations found online of SUMIFs and SUMPRODUCT, but I haven't been able to make them work. Any and all help is greatly appreciated.Formula doesn't "read" 0 as a number
Hello, I have a document what I get from my customer with lots of data, and need this to implement to our system, but I need only a few columns. The template is everytime the same. So, I made a new sheet, with a "output" and a "input" tab. I copy the whole document I get from the customer in the "input" tab, and in the "output" tab, I take the needed data with formulas. Now I have a column named "weigth". This is also in the document from the customer, but it is not converted to a number. When the number is 0("zero"), I have to leave it in my output-document blanc. I use this formula: =ALS(invoer!T=0; "";invoer!T2) But when the number is "zero", I get the number "zero" back, and it would not be leaving empty. When I enter a weigth in the input, like 15, I get in the output tab also the output 15. So, it works. Only not with a number "zero". When I convert the column to "number" in the Input-tab, it works also. Is there some work-around to make this work, without everytime converting the columns in the Input-tab? As of example I post a part of the input-document. I have to take weigths from several columns, in this sample it is column T. The output: I tried already to set the column as a "number", but everytime when I paste new data, it is overruled and fails again. Thanks a lot for help with this. Regards, Durk
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
- Boost your productivity with Microsoft 365 Copilot! Discover how to crush your daily tasks and save time.Mar 14, 2025
- Are you managing Microsoft 365 environments and looking for quick, reliable setup information? Introducing Microsoft 365 Setup Expert, your go-to AI-powered solution that helps you streamline Microso...Mar 13, 2025
