Recent Discussions
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
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, MikeThe 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.
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-7c1e52d4091cMicrosoft 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/
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.
Help comparing 2 different data sets
Dear Excel community, Hope everyone is keeping well :) I'm looking for some help comparing two different data sets (addresses to be precise). Sheet 2 contains a service list. Unfortunately they are formatted differently. I want to know which addresses from the Master are missing from Sheet 2. I'm not sure what is the best way to approach this without having to format the whole thing. Hope the above makes sense ?! I wanted to attach the workbook but can't seem to upload anything. Thanks RajFormer 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.
Broken Account Recovery (discontinued product)
Hello everyone, We have the MSFT Office Family plan which has the now discontinued custom domain support that used to be an option as a "Premium" feature. Back in August we upgraded the phone of one of the account members on the family plan and lost connection to their MS Office account with the only device that was accessing to the account (the phone with access was reset as part of the upgrade/trade in process). I have tried the account recovery form and it simply doesn't work. I have tried to explain to MSFT support that the tool is broken but can't get anywhere. For the account in question we have an Outlook email client (with non working password) that has a cache of all of the email until loss of access occurred. So when I do the account recovery form, I have name, DOB, region, past passwords and data for all fields including sent email Id's and send subjects, But every time the MSFT recovery mechanism says "Unfortunately, we have determined that the information provided was not sufficient...". WTF. Every time I contact MSFT support I get the same answer, an explanation of the point system used to reset the the account. Same steps to recover....based on this, the recovery should work...yet it doesn't. I have tried somewhere 50+ attempts now over the last 9 months. I even have a contact who is VP level at MSFT who sponsored a support ticket internally but that just ended up with the support person sending me a link to the account recovery form and closed the ticket without looking in the details of the ticket. I can't modify / add a new account as MSFT has as a discontinued product no longer allow members to add/change id's. So I'm locked at the current user set. I have created another email address by saving the cached data to OLM file and importing via the Outlook client but that doesn't restore use of the @mydomain.com for that person. I even retained a lawyer who send a demand to MSFT legal...but the email address didn't go anywhere so at the point of needing to do this on headed paper/send via snail mail. Does anyone have any idea how to get through to MSFT explain the recovery tool is broken? I assume there are so few accounts using custom domains pin family plans that they simply don't test this recovery path. At this point without some internal guidance is a) lawyer and force a demand for password reset b) give up, ditch all of the users using the custom domain, configure an alias for all of the accounts and then change my MX record to a company doing email forwarding and then forward to the new/old legacy accounts (i.e. the ones with the mailto:email address removed for privacy reasons).what happened to my robux digital gift card in Microsoft rewards?
Hello everyone so what happened to my robux digital gift card in microsoft rewards this happened a long time ago to me but im following up about this topic just now microsoft can you please bring back the robux digital gift card? i already have enough points for it and im also a bit sad as well. ok thank you Microsoft if you bring this back. regardless i hope you guys bring it back.
Unable to view Active user and unable to add shared mailbox
Hi Team, I'm trying to add a shared mailbox under MS 365 Admin, I am unable to 1. Add a new user (admin role error) 2. View active user (which I'm logged in with) 3. Add a shared mailbox (retry again/ from last few days) 4. Contact Support - error loading chat Any help would be appreciated.PivotTable Date Slicer Not Visible in Excel for the Web (Works in Desktop)
Hi everyone, I'm experiencing an issue with Excel for the web and was hoping to get some help. I have an Excel workbook that is linked to a 'Microsoft Forms' form. The form responses automatically populate the main sheet, and from that data I've created several PivotTables. In one of the PivotTables, I added a date slicer to filter the data. Everything was working fine at first, but recently the slicer is no longer visible in Excel for the web. However, when I open the same workbook in Excel Desktop, the slicer is visible and it works as expected. What I have tried so far: Recreating the PivotTable and adding a new slicer Creating a completely new PivotTable and slicer Checked if the slicer is hidden by adjusting the zoom Unfortunately, the issue persists in Excel for the web. Has anyone experienced this before and found a workaround? Any help would be appreciated. Thanks in advance.Managing Blank Cells in multiple linear regression analysis.
Hello, I am performing a multiple linear regression analysis using the Analysis Toolpak in Excel 365. I have complete y-data, but the x variables are missing some data points throughout a large data set. I know I can fill in the data with the mean or potentially use a regression analysis to predict data to fill in the blanks; however, I would prefer to ignore the blank data if possible. Is there a way to do this inside the data toolpak?Excel: Subtract multiple parts from inventory with a single input
Ho un sistema di inventario in Excel con tre tabelle: Elenco principale di tutti i ricambi (Codice ricambio, Voce, Usato, Magazzino) Registrazione delle parti in entrata Registri UTILIZZATI delle parti consumate Il sistema funziona bene quando consumo singoli componenti , dato che mi basta inserire il codice del componente nella tabella UTILIZZATI e aggiornare le scorte. Il problema si presenta quando utilizzo dei componenti nell'ambito di un processo. Per esempio: Un Gruppo1 utilizza più parti Un assemblaggio completo utilizza tutte le parti Al momento, se completo un gruppo o un intero assemblaggio, devo inserire manualmente ogni singolo componente nella tabella USED. Vorrei poter inserire un singolo riferimento nella tabella USED (ad esempio: Gruppo1 o Completo) e far sì che Excel lo calcoli automaticamente: dedurre tutte le parti correlate dalla tabella PARTI basato su una mappatura predefinita La mia idea è quella di creare una tabella di mappatura (simile a una distinta base/definizione di gruppo), in cui ogni gruppo sia collegato a più codici articolo con una quantità definita per articolo. Quindi, quando inserisco un gruppo nella tabella USED, Excel dovrebbe sottrarre di conseguenza tutte le parti associate. La domanda è: come posso farlo?Transfer MS Office 365 Business ownership from MSP to own MS Business account
Hello Everybody I need to transfer my clients MS Office 365 Business from current MSP to their own MS Business account. Current MSP very bad service. So, at the end they want to manage their Emails\Licenses on MS Admin Center. What are the steps on doing this?Office.com “All Apps” unreachable on mobile until you “Request Desktop Version”
Title: Unable to Access “All Apps” on [Office.com] from a Mobile Browser Summary: When signing in to [Office.com] on a mobile device, users may be redirected to the App Store or Microsoft 365 mobile app page. Returning to the browser results in a mobile‑only version of [Office.com] where the standard navigation menu (including the “All Apps” option) is not available. Additional steps are required to force the desktop version so the full app launcher can be reached. --- Symptoms No 9‑dot “waffle” app launcher icon appears on [Office.com] when using a mobile browser. After signing in, [Office.com] displays a simplified mobile page with no left navigation bar. Selecting “All Apps” (once desktop mode is enabled) fails to redirect. • Users are unable to browse or launch the full list of Microsoft 365 apps. --- Cause [Office.com] detects a mobile device and forces a mobile‑optimized experience. Mobile redirection also occurs after being sent to the App Store or Microsoft 365 app download page during authentication. This prevents access to the desktop navigation UI, including the full “Apps” menu. --- Resolution / Workaround Follow the steps below to force the full desktop version of [Office.com] and successfully access the “All Apps” list. Step 1 — Sign in normally Open your mobile browser. Navigate to https://office.com/. Sign in with your Microsoft 365 account. If redirected to the App Store/Microsoft 365 app page, return to your browser. Step 2 — Open the browser’s site‑options menu In your address bar, tap the puzzle‑piece icon located beside the URL. Inside that menu, tap the three dots ( … ) to expand options. Select Request Desktop Version. Step 3 — Re‑authenticate [Office.com] will reload and may require you to sign in again. After signing in, the mobile site may still appear. Step 4 — Request the desktop version again Tap the puzzle‑piece menu a second time. Select Request Desktop Version again. This time, [Office.com] will load the full desktop interface, including the left navigation bar. Step 5 — Access the full apps list In the left sidebar, select Apps. The All Apps link in this menu may fail to redirect. This is expected. Step 6 — Use a direct URL to reach All Apps In the address bar, manually enter: https://office.com/apps The page will load successfully. Selecting All Apps from this page now works as expected.Reserve Calendar Time for Bookings
How do you block space out on your personal calendar such that it's only available to Microsoft bookings, and shows busy to others in your organization? I've created a personal bookings page with custom timeslots--that's working just fine. The problem is that people in my org who can see my calendar are sending calendar invites for those same timeslots, making them no longer available to the bookings page. If I add my own events to my personal calendar to mark time as busy, those slots also disappear from the bookings page. How can I adjust things such as to reserve time exclusively for Microsoft bookings and no other users at my org?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
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
