Recent Discussions
Student Behaviour Tracker
This is a very cheeky request for help. Now approaching 70 I've forgotten most of what I knew about Excel. I'm a Chair of Governors at an 11-16 school. I receive notifications about pupils who have been suspended (also known as fixed term exclusion). Roughly I have about 200 individual suspensions over 1 year. I want to record and analyse these. The information to record is Name: Last and First (about 30-40 students) Reason for exclusion (usually 1 or possibly 2 out of about 8 categories) Length of exclusion 1 - 15 days Flags e.g. SEND; PP, Year group: 7, 8 , 9 10, 11 Date As many of the students are repeat offenders I'd like to set the spreadsheet up so by either by typing the name or through an editable drop down list the name appears once and then the reason for the suspension and date is entered (as opposed to multiple entries appearing on the same page). I'd then like the spreadsheet to report, using an editable date range: By pupil name; the number of suspensions; total number of days and total number of days for each category of exclusion By suspension category: number of suspensions; total number of days for each category By flag: number of suspensions; total number of days for each category Year group: 7, 8 , 9 10, 11: number of suspensions; total number of days for each category I've looked at some cheap packages e.g. at Etsy but I cant see anything that does this. There are commercial packages, intended for whole school, but cost several hundred - thousand plus, pounds. Thanks in advance if you are interested and my apologies to you if you feel this is an inappropriate request. Regards NickSolved76Views1like4CommentsCan I restore my whiteboard created by Microsoft Whiteboard UWP?
I created several whiteboards by MS Whiteboard UWP in 2023. As I cannot transfer the data to new Whiteboard, I kept the old version ( Microsoft.Whiteboard_52.10201.5809.0). But days ago MS Store updated it automatically, and I lost my data. I didn't transfer it to OneDrive, so it should be stored on Azure. When I find the update (when it updated the local data should be already removed from my device) and recover the old version and login again today, I find nothing but a new created empty whiteboard, all of my data lost and I cannot access it from the cloud. How can I recover my data?20Views0likes1CommentPublish an Excel Add-in by just submitting the add-in manifest to Microsoft Marketplace
I am working on Excel Add-in built using the react template. We are planning to host the add-in code on our domain and update the manifest to point to the URL for our domain. Can I just submit the add-in manifest to Microsoft to publish it in Microsoft Marketplace?12Views0likes0CommentsFormula Help
I have a spreadsheet I use for bidding construction work. On items 1-40 the formula in cells G22-G65 work like they are supposed to. From G66 to G88 where the sheet stops, the formula returns #NAME?. I've checked the formula from G65 to G66 and below, and they appear to be correct. I can't figure out what the problem is. This is the formula that works. =IF(D65>0,'40'!Rate+$G$18,0) This is the formula that does not work. =IF(D66>0,'41'!Rate+$G$18,0) The '40' and '41' refer to individual sheets within the workbook that contain the data in the !Rate cell. I've been looking at this for hours and can't figure it out. Any help or advice would be great.57Views0likes3CommentsMicrosoft Takes Aim at ChatGPT
Microsoft would very much like Microsoft 365 tenants to use Copilot instead of ChatGPT. A recent comparison between Copilot and ChatGPT outlines some areas that Microsoft thinks are important when deciding which AI tool to use. Microsoft has a point because Copilot is embedded into Microsoft 365 whereas ChatGPT is more of an add-on. The competition for hearts and minds is very intense in the AI space. https://office365itpros.com/2026/02/20/copilot-and-chatgpt/36Views0likes0CommentsExcel returns incorrect answer to simple multiplication.
I'm saving a few favourite math examples, and ran into a problem - the last of the calculations came back with an incorrect answer. I'm using a simple =cell1*cell2 formula. It should end with 21. Please help I'm using android app. All cells formatted as numbers.Solved86Views0likes2CommentsUsing Dev Proxy with the Microsoft Graph PowerShell SDK
Dev Proxy is a Microsoft tool built to help developers figure out the most effective way of using Microsoft Graph API requests. On the surface, Dev Proxy doesn’t seem like a tool that would interest people who use the Microsoft Graph PowerShell SDK to write scripts for Microsoft 365. But all tools have some use, and Dev Proxy can help. https://office365itpros.com/2026/02/19/dev-proxy-graph-sdk/13Views0likes0CommentsRemoving a possible user selection from a slicer
I have a column field in Excel with 4 possible values. My slicer shows all 4, as it should. Three of the possible vales are alphabetic strings. One of the possible values is a blank field indicated by (blank) on the slicer. A blank is a valid value for this field in some situations, so I don't want to just ignore the rows where this field is a blank. But I would like to eliminate it as a user selection in the slicer itself. I thought checking the slicer setting, "Hide items with no data" would do the trick, but it doesn't appear to do so. Any tips on how that setting is supposed to work and/or why it might not be? (Maybe it has to actually be a 'null'?? No idea....)Solved71Views1like2CommentsAccess to subAddress Property of Hyperlinks in Powerpoint Javascript API
Recently my company has me developing a Taskpane Add-in for Powerpoint using the Javascript API. Right now the API is still missing a 'subAddress' property for the Powerpoint.Hyperlink class. My heart's deepest longing is to add a slide to a presentation with existing slide-to-slide hyperlinks, check those hyperlinks for discrepancies between the slide ID and the text (ie: a Hyperlink reading '13' that now links to slide 14), and finally correct the text to the subaddress ID of the hyperlink in Javascript. It is my burning passion to do this for every hyperlink in my presentation with the push of a button. In the interest of all mankind I would ask that the 'subAddress' property of the hyperlinks be available for use in addition to the 'address' and 'screenTip' properties which now exist. To the microsoft dev who can grant me this boon I offer half my kingdom. Truly there is no dev more favoured than thee.49Views1like2CommentsTrying to create a form field that uses images (but not a simple one!)...
I have a Word form that uses a https://www.fema.gov/emergency-managers/practitioners/lifelines-toolkit/lifelines-icons used in the public safety community. For each icon, there are four different border colours, indicating a certain level of urgency, using the TLP model - green, yellow, red, grey. What I would like to do is create a dropdown (elsewhere on the form) where someone chooses an option in that field, and depending on the choice, the icon with the corresponding colour displays. Example: Any assistance is appreciated!42Views0likes3CommentsLink 2 sheets, then sort column A on sheet 2 alphabetically and match correct data
I have two sheets on the same spreadsheet, and I want to pull in the data from 4 different columns to the second sheet and have it automatically update when there are changes or additions to the first sheet. I have a couple issues making this happen - the main one is that the data in my first sheet is custom sorted by color, but I want the new sheet to take the data from column B on sheet 1 and sort it alphabetically, and take the other columns and match them correspondingly to the correct values they match to from column B on the first sheet. Secondly, for blank cells, I want it to leave them blank instead of inputting zero, or any dates. I don't know if this is all even possible, or if I should just remove my custom filters from sheet 1 by cell color and just link it that way. I've spent hours trying to find formulas that work. Please see attached images for reference on what I've tried, and for more clarification as to exactly what I'm requesting. Sorry for the copious redacting, I wanted to be safe rather than sorry with identifiable info regarding this. Any help would be greatly appreciated.Solved150Views0likes7CommentsCancelling Microsoft Customer Agreement (MCA)
I'm a Microsoft CSP provider. My customer wants to cancel their subscriptions because they want to leave the Microsoft. Do I need to cancel their MCA or will it be cancelled automatically? If it is necessary to cancel the MCA, where should this be done? Thank you very much!32Views0likes1CommentHow to Use Scoped Graph Permissions to Access SharePoint Files
Scoped permissions grant apps granular access to files and folders in SharePoint Online and OneDrive for Business sites using the Files.SelectedOperations.Selected Graph permission. The permission allows apps to access specific files or all the files in a folder. It’s a great way to make sure that apps don’t have unfettered access to confidential documents. Not that any app would try to have that kind of access… https://office365itpros.com/2026/02/18/scoped-access-files-and-folders/24Views0likes0CommentsOrganizational Account authentication problem
I have encountered a new authentication problem using an organizational account with Get Data > From Web. The data source is Dynamics 365 CE on-premises (https://ce.xxx.com/api.data/v9.1), authenticating through ADFS with MFA. This has been working without any issues until recently. When I attempt to refresh the query, I get an ADFS pop-up window for username and password, as expected. However, the window then closes without the expected MFA prompt. The "Access Web content" window does say "You are currently signed in," but does not query successfully, instead displaying the error "We couldn't authenticate with the credentials provided. Please try again." The most distinctive symptom, is that clicking the "Sign in as different user" button does not work. It just quickly opens and closes an empty window, instead of the expected ADFS username/password page. In Power BI Desktop everything works. The connection and query are successful, and the "Sign in as different user" button successfully displays both the initial ADFS username/password window and the subsequent MFA dialog. Excel version: Microsoft® Excel® for Microsoft 365 MSO (Version 2512 Build 16.0.19530.20226) 64-bit48Views0likes1CommentSearch and replace can't seem to delete \o or \t in URLs
I am trying to delete specific text that has been added to all of the URLs in a Word document. The added text follows a specific format: "random characters" \t "_blank" \o protect" Using search and replace (with wildcards) and show field codes (so I can see the URLs) hasn't been successful. This approach -- searching for "random*protect" and replacing it with [blank] -- does nothing. Trying to delete just the \t and \o entries by surrounding them with parentheses deletes all the t's and o's in the document. Any help getting rid of these additions would be greatly appreciated. pjsSolved39Views0likes2CommentsOnedrive sharing not working for one user
There is only one user who cannot share with anyone external or internal. I have checked everything, they are a site owner, a site admin, a site member, we have no restrictions on sharing, it works for others. I made a new site just for them as the only admin, they still cannot share. They have been removed and re-added 5 times. We have a microsoft support ticket and they don't even seem to know the issue. What can I do?32Views0likes1CommentTime sheet for hours worked
I am needing to make a sheet that shows clocking in for work - clocking out for lunch - clocking in from lunch - clocking out for the day and then the total of those hours worked per day and then grand total for the week. For our pay system we do things in 6 minute increments. I found a sample sheet through Excel, but the formula we have still isnt just right. Here is what I have and the formula for the hours worked is what I am needing help on. Any help is very much appreciated!225Views0likes11Comments
Events
Recent Blogs
- AI isn’t a side conversation at the Microsoft 365 Community Conference—it’s at the center of how work is changing. The Copilot, Agents, & Copilot Services Sessions are designed for anyone who wants t...Feb 20, 202699Views0likes0Comments
- Version 2511 (Build 19426) Bug Name Issue Fixed Query Design view showed incorrect joins after selecting SQL text When using the Monaco SQL editor with a query containing mul...Feb 18, 2026135Views3likes0Comments