Recent Discussions
Providing info on tab, based on other tabs with parent child relationship.
Hi, This post/question is based on a simplified verion of a security-matrix that is te be audited in the company and also audited against the real time security-tables in external system. I changed things to recognizable terms. What would be the best way to solve the task below? We have a PDF-image based on tab "FuntionRole_matrix" that is periodically audited against the actual situation. Thati is why this tab is not edited by hand but partially based on two additional tabs that are provided from another third party system. These additional tabs are "RoleTask_matrix" and "TaskTool_matrix" In Tab "FunctionRole_matrix" we manually fill the departments, job-titles per department and de roles assigned to the specific job-title. In Column D we have a picklist of all the known Roles, as found in tab "RoleTask-matrix" After choice the Role_ID is provided in column E. (via cell function: =X.ZOEKEN(D2;RoleTask_matrix!$A$2:$A$6;RoleTask_matrix!B$2:B$6;"Not found" (=V.Lookup in dutch Excel verison + semicolons different from english functions) The Top row is filled by a lookup of all the possible tasks. In the FunctionRole_matrix we provide insight in de assigned tasks within a role by a lookup-function in tab "RoleTask_matrix" (via cell function in topline: =X.ZOEKEN($D$1;RoleTask_matrix!$A$1:$A$1;RoleTask_matrix!E$1:E$1;"Not found") (and for cell F2 etc.. the X is set by =X.ZOEKEN($E2;RoleTask_matrix!$B$2:$B$6;RoleTask_matrix!E$2:E$6;"-")) Since we have to provide full insight in the relation between the jobtitle, the tassk within te job en the tools/matrials provided for the job we show the tools/matrials provided on the same line as the role in de FuntionRole_matrix. So that we can provide a signed PDF-copy of this excel-tab. The tools provided must be determined by looking for the, via lookup determined, X-es per role. When an X is detected we have to determine de task provided in the topcel of that row. With this task-ID value we need to search in the tab "TaskTool_matrix" and look for the checked tools/materials that should be provided for every jobtitle that has that task. Roles can overlap on tasks and this can also be the case for the tools/materials. We just need an X on FuntionRole_matrix kolom AB etc.. to see what has to be provided to a person in every job-title. Since there is no VBA-knowledge present i cannot bring this Excel sheet live with a button that sets all the X-es as of column AB. Personally i can do it, but withoud future support this cannot be the case. The solution needs functions in cells to provide the information. I guess it must be a combination of IF THEN ELSE with nested VLOOKUP functions. And we have to look for an X that is provided by a function in the cells. So possible some indirect value comparison needen instead of looking for character X in cell. but i have no clue about how to do it. Hope someone has the solution. Very grateful for response. I can provide the excelsheet via a PM. Seems like i cannot attach it to this post Best regards, Mike
Slicers show (blank), but no blanks exist in the data model
My workbook's purpose is to function as a decision tool. Providers select services they offer using a series of slicers. Their responses filter a pivot table, which shows them which license they should apply for. Some services may be required (or not permitted) under certain licenses. Each slicer represents a service category/type, and slicer options are the specific criteria/specific services used to determine the best license. All options are mutually exclusive (i.e., none of them appear in multiple service categories). In the file, the 'status' variable indicates whether a specific service can be offered with a particular license. There are 4 statuses: Required: the provider must offer this service to qualify for X license (slicer option must be selected) Optional: the provider may offer this service but doesn't have to in order to qualify for X license (slicer option can be selected but doesn't have to be) Not applicable: the service is irrelevant to X license (selecting slicer option has no effect on recommended license) Cannot provide: the provider cannot offer this service to qualify for X license (slicer option cannot be selected) The main issue: In all slicers, (blank) shows as one of the options. There are no blanks in the reference tables. All "real" slicer options also line up with something in the license requirements table... so there aren't any mismatches in the data model that I've been able to find. This is affecting my workbook in two ways: I can't find a way to hide (blank) from the slicers, because I don't know where it's coming from. When (blank) is deselected from a slicer, the filtered pivot shows the number of criteria in each status column for the corresponding service category. Example: The population served service category has 2 valid answers (1 of which is optional and 1 of which is not allowed for License A). When (blank) is deselected from the population served slicer, the filtered table shows 1 in the optional column and 1 in the cannot provide column for License A. Other info: Allowing multiple selections is critical to the final product, so that will have to be done when the file is opened. I tried creating tables for service type, status, and service types/their corresponding options, just in case the data model didn't like the original. These tables are currently part of the data model, but they don't seem to make a difference either way. There are many combinations of services that could be offered. Some act as exclusion criteria for other licenses, so slicers shouldn't be connected to each other. Therefore, I've unchecked the 'hide items with no data' and 'visually indicate items with no data' slicer options. The final workbook will include more license types and additional functions. I removed several licenses to make the file shorter, but all service categories and options are present (since that's where the problem seems to be). I'm not sure how to attach the workbook, but has anyone had this issue before? Is there an issue in the data model somewhere? What am I missing? Any help would be much appreciated!
How to purge OneDrive from the default user folders
Hi. I got this PC a while ago and OneDrive just kinda set itself up based on my Microsoft account. It was decently useful having access to my OneDrive files as a folder on my PC but I do NOT want it backing up my files automatically, partly because I want those to be offline and because I really don't need constant popups telling me I named my file wrong or that I ran out of space. So, I disabled synchronisation for those folders - I'm talking about the default documents, images, etc. folders. Yet there was then two seperate folders called Images (or whatever that folder is called in English Windows), one with the path C:\Users\cherr\Pictures, and one with the path C:\Users\cherr\OneDrive\Pictures. Explorer sees the top one as the default, and displays the shortcut to that in the bar on the left, while other programs such as my very old Canon document scanner's user interface sees it as the bottom one. I tried everything I could think of, including cutting the OneDrive folder and putting it in a different location in order to not lose any of the files), then renaming it. Yet somehow the scanner software and others, even if I manually select the correct folder, still default to the new path which is now C:\Users\cherr\piss off onedrive\anything but OneDrive\Pictures. I have had to turn off the OneDrive app altogether, which is problematic as I am also logged into a school account on that (which has caused zero problems) to which I need regular access for the files on it. Yet even this does not fix it. Please help me out with this, as I now have two seperate folders called "Pictures", which are defaulted to depending on which app I am using.
Api in every row of excel.
Hi Currently I have an excel file with the following columns. MFund Code I Bought at I Mutual fund name I latest Price 112092 I 100.00 I Fidelity world fund I 112.00 I 100.00 56432 I 25.00 I Stanley index fund I 20.00 I 25.00 There is a website which provides access to latest price through API. There arre many Mfundcodes so I use a text file to be read in a python program and extract the data. Following is the main part of the program. for x in f: # Add number variable to the api call x = x[:6] api = f"https://api.mfapi.in/mf/{x}/latest" # Get text data from api call idata = requests.get(api).text; # Convert json data into dictionary format d = json.loads(idata) # Get the first record of data if not d['data']: exit else: l = d['data'][0] k.write(f"{x} {l['nav']} {l['date']} \n") Later I import this text file into the excel for further calculations. I was wondering if there is a way to have these values load into the excel columns regards Jyothsna
Crash of Excel
Faulting application name: EXCEL.EXE, version: 16.0.19822.20150, time stamp: 0x69cd5771 Faulting module name: EXCEL.EXE, version: 16.0.19822.20150, time stamp: 0x69cd5771 Exception code: 0xc0000005 Fault offset: 0x000000000004879a Faulting process id: 0xC24C Faulting application start time: 0x1DCD1000E36A5B4 Faulting application path: C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE Faulting module path: C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE Report Id: 0fb8fffd-6a61-48fa-b50b-79d49dc71e0e Faulting package full name: Faulting package-relative application ID: Occurs every 2-3rd day.. Kutools extension is used and crash always occurs when Grid Focus feature of Kutools is enabled.Former short-term employee added as Billing Admin
Hi everyone, I’m hoping to get some insight into how this could have occurred and what we should review to prevent it from happening again. We are a small organization, and we recently discovered that a former employee (who only worked with us for about two weeks) was listed as a Billing Administrator in our Microsoft 365 tenant. This person is no longer with the company. Their Microsoft account has already been deleted. We are a small team with very limited admin roles assigned. We do not recall intentionally granting them billing-level permissions. We are trying to understand: How could a short-term user have been assigned the Billing Administrator role? Could this have been done automatically through another role assignment (e.g., Global Admin inheritance)? Is it possible this occurred through a CSP/partner relationship? Are there logs we should specifically review beyond standard audit logs? What are best practices to prevent this from happening again in a small tenant? We are currently reviewing: Admin role assignments Audit logs Partner relationships MFA enforcement for all admins If anyone has seen something similar or can suggest specific logs, settings, or controls we should review, I would really appreciate the guidance. Thanks in advance for your help.Excel - COUNTIF Function
Happy Friday! I am trying to use the COUNTIF Function on a worksheet that tracks how much liquid chlorine is used at 3 different water wells each month, each well having 2 chlorine cylinders. I'm not sure if my brain is fried from reading/watching all kinds of videos for the past 3 hours and trying to follow their instructions, but any time I put in a formula, I get a pop-up saying I've entered too many arguments. Even if I enter individual cells and use only the 3 that it highlights for me (more than 3 does not highlight). I've attached a screen shot of the worksheet (Figure 1) and have highlighted the area I'm trying to figure out. As you can see, it will be for multiple dates, on multiple lines, going through to the end of the month, with the total chlorine (CL2) tallied up on the right hand side. Chlorine tanks are changed out quite often and each tank begins at 150, depleting down to 0. Figure 2 shows a screen shot of what I'm getting when trying to enter the formula. Am I misunderstanding how the formula works or am I using the wrong formula all together? Figure 1 Figure 2
Authenticator
I need your help. I broke my Iphone and after replacing it I cannot log into my Microsoft admin account since the authentication app is not working. I am the administrator of my own small business account. I have gone through all the account recovery help but neither the send text to my number or call my number works. All online support depends on having an the code from the Authenticator app I am completely lost here ☹ hope someone can help Dadi JohannessonThe Microsoft Graph PowerShell SDK and the additionalProperties Property
The additionalProperties property is available for many Microsoft Graph PowerShell SDK cmdlets. In this article, we explain the function of the additionalProperties property and how it functions in holding output for Microsoft Graph PowerShell SDK cmdlets. It’s all because of the lack of strongly-typed properties, or so the AutoRest process would have us believe. https://office365itpros.com/2026/04/21/additionalproperties-property/
Adding Error Bars to a Graph
I created a bar chart and it wonʻt give me any option to add error bars. This is my first time using this new excel format, and I donʻt know where to go for the error bars. I have tried to google it and watch videos but all the instructions and tutorials are for different excel versions.
Losing borders in transition from Excel 97 to 2024 Pro Plus
I have a handy appointments calendar (.xls) that has used Excel 97 on a Windows 7 laptop for a long time. I want to run this on my latest laptop that has Excel 2024 Pro Plus on Windows 11. When I open this now, many of the cell borders, most of which are involved with conditional formatting, are either present when they should be absent or absent when they should be present. The calendar is useless as opened. I have worked to reformat the cells, but it has taken me hours to get from January to April and some aspects are still problematic, albeit acceptable. The conditional formatting process is very different between the two versions. Is there some trick to getting newer versions of Excel to properly recognize formatting from older versions? I created this calendar in Excel 97 very easily many years ago. I am not sure I could duplicate it, even from scratch, using Excel 2024.Margin calculator for media budget
Hi, I need help formulating a calculator where the 'Fixed Margin' is separated out from the total budget. My calculation needs to add a buffer to the margin as the platform where this is inserted will reduce the nominal margin when you also include a flat cpm fee as it increases the total amount billed. For example, if margin was 20% of $10,000 then the remaining budget left should be $8,000. However, when you add a rate card on top and deliver x amount of media impressions, the effective margin as a percent of total cost is always going to be less than the nominal margin percentage. Example: Total cost: $10,000 Margin fee: 20% Flat CPM rate: $1.50 Impressions: 2,000,000 then this would lead to this: Media Cost $5,600 Margin Fee $1,400 Flat CPM rate ($1.5) $3,000 Total $10,000 Ideally, I would like to ensure the margin is kept at $2,000 (20%) so need help creating a formula that will raise the margin to a % that keeps your nominal margin rate whilst factoring the flat cpm fee and the impressions served.
Weird bug in Excel 2024 LTSC when switching sheet direction (RTL issue)
Hey everyone, I ran into a strange bug in Excel 2024 Professional Plus LTSC (running Windows 11 25H2). Whenever I open a new workbook and change the sheet direction from Left-to-Right to Right-to-Left, I can’t properly select cells anymore. Clicking on any cell, row, or column doesn’t show the selection border — it’s like Excel doesn’t highlight anything. I have to click multiple times to make it respond. https://i.imgur.com/nAeqnRh.mp4 This only happens after changing the direction. If I keep it Left-to-Right, everything works fine. I tried reinstalling and even tested Excel 2021, and the issue doesn’t exist there. Seems like a bug specific to the 2024 LTSC version. Has anyone else seen this or found a workaround? EDIT: I've already filled a bug report at the MS Feedback Portal https://feedbackportal.microsoft.com/feedback/idea/81911365-f23c-f111-9a91-7c1e52d4091cOnce Publisher disappears...help please.
Hi all, So I see that by late 2026 Microsoft is getting rid of Publisher which means ( as I understand it ) any/all of my PUB files on the pc will no longer be able to be opened/used. I know I can convert my PUB docs to PDF but how do I do the following. I have a number of PUB docs that have multiple photos on each page. These pages are used for a notebook that I change annually. Some photos stay and some are replaced. Dead easy to do using PUB but what happens when PUB goes. I can open the changed file ( from PUB to PDF ) but it doesnt allow me to change individual images..its all or nothing. I can work out how to open a PDF in WORD but the same thing is happening..its either every picture or nothing ?? SO..my Q is..once PUB goes what can I use to keep editing these pages. HOpe someone can help me. Thank youMicrosoft 365 Security Best Practices for Enterprises
In today’s digital-first workplace, Microsoft 365 has become the backbone of enterprise productivity. From email and file storage to collaboration tools like Teams and SharePoint, it centralizes critical business operations. But with this convenience comes a growing attack surface. Cyber threats are evolving rapidly, and enterprises can no longer rely on default security settings alone. A proactive, layered approach to Microsoft 365 security is essential. https://dellenny.com/microsoft-365-security-best-practices-for-enterprises/Bad registrar on 365 side
Hello, We created a Microsoft 365 tenant several years ago but never used the online email services. We added and verifed our domain, which was registered with Orange at the time, and then created some users manually to use PowerBI. Today, we begin to migrate to Exchange Online. We have installed AD Connect and synchronized some users. Since creating the tenant, we have changed registrars (to Gandi), but I've noticed that the registrar hasn't been updated in the tenant 365. An `nslookup` correctly identifies Gandi as our current registrar. Microsoft has remained with Orange... and this is causing errors in the hybrid Exchange configuration assistant due to bad autodiscover. How can we "refresh" the registrar on the Microsoft 365 side ? Thanks for your advises NicolasBitlocker locking me out of laptop computer
I tried to start-up my laptop yesterday and I got a blue "Bitlocker" screen come up and it is asking for a recovery key. It notes the reason "..because Secure Boot policy has changed." I never installed Bitlocker, or set-up. Frankly, I never heard of it. I checked my microsoft log in and there was no bitlocker recovery key in there either. I haven't made any changes to the computer recently. Computer is an HP Envy with solid state drive I believe I am at a loss as to how to deal with this without loosing my data. I spoke to three computer guys and they were not familiar with the Bitlocker. Any assistance would be greatly appreciated.
Events
Happening Now
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
- Learn how we are leveraging AI to modernize our approach to change management and give you the tools, information, and processes you need to fully realize value from Microsoft 365.Apr 16, 2026
- Building in the era of AI can get very challenging. That’s exactly why we’re here to help you debug, refactor, and level up at the Microsoft 365 Community Conference, happening April 21–23, 2026 in O...Apr 15, 2026
