Recent Discussions
Organisation bookings and pass through data in MS Bookings
Hi All, I thought this was possible, but it doesn't seem to be working so hoping for some pointers.. When using Microsoft Bookings for a shared service, for the use of those internal to my organisation, is it possible for the person making the booking to have their details automatically populate the form (i.e. name, email address)? I'd have thought this was basic, but it looks like it's purely designed for external bookings, regardless to the audience. Many thanks, Dayna
Issues With PowerQuery Using 2 Tables with different Data Sets
Im having issues using power query when I try to use 2 tables to make a pivot table. I am using a sheet that pulls information from a system I use for maintenance. The first screenshot is a subset that breaks down sub items for a main "work order". The next 2 screenshots are from a separate table that show the main "work order" and has an "Equipment Pool" that shows who owns the vehicle in question. When trying to create a pivot table, a lot of information shows as blank. (see bottom screenshot) I am wondering what I am doing wrong for it not to be able to pull the "Equipment Pool" when it aligns to the "Asset ID". Any help is appreciated. (For security reasons I have not put all information from the tables, only the relevant ones)Microsoft to Enable Anthrophic Models by Default
After the fuss around the initial introduction of the Anthrophic models into Microsoft 365 in September, we learn that Microsoft will enable access for all in January 2026. It would have been so much better had Microsoft said that they were working on the data protection arrangements with Anthrophic, but that didn’t happen. Is all well now? We’ll see in January… https://office365itpros.com/2025/12/12/anthrophic-models-m365/
Issue with siplay a picture “The picture can’t be displayed”
I worked for many days on a document that contains a very large number of images. When I reopened it, every single image was replaced by an error/placeholder message (e.g., “The picture can’t be displayed” / “The image cannot be displayed”). After troubleshooting with Microsoft Support, we discovered the document had been saved/handled as OpenDocument Text (.odt) (OpenDocumentText) instead of a standard Word Document (.docx). Support attempted format changes/conversions, but the issue remains. I urgently need a way to recover the images/content from the existing file and guidance to prevent this from happening again. Any idea about how to solve it? Thank you in advanceAdvanced Excel Formula discussion - Problem with dynamic range
Let's assume I want to rent a house. For each house, if the landlord has an agent, I'll contact the agent; If not, I contact the landlord directly. As below: Landlord Agent House Landlord James Mary W James Linda Michael X David Y Linda Z James Column F: =IFERROR(XLOOKUP(E2:E5,A:A,B:B,E2:E5),E2:E5) This is correct Column G: =XLOOKUP(E2:E5,A:A,B:B,E2:E5) #VALUE! for X-David Column H: =XLOOKUP(E2:E5,A:A,B:B,CHOOSECOLS(E2:E5,1)) Wrong value for X-David, because it returned the first value in range of XLOOKUP([if_not_found]) field My question is: the only difference between G and H is CHOOSECOLS(). If I put =CHOOSECOLS(E2:E5,1) or =E2:E5 in a separate cell, it gives me same result. However, in XLOOKUP, they are recognized differently. What is the logic behind this? Thank you for spending time on reading this.
Formula to retrieve data from several sheets and return values from given criteria.
I am trying to get data from each of our areas of the school staff timetables EY MY LY and summaries what days each staff member works where to another sheet, as staff move around. I would appreciate some help please. This is how far I got: =IFERROR(VLOOKUP(A10,EY!$C$3:$G$33, 2, FALSE), IFERROR(VLOOKUP(A10,MY!$C$3:$G$33, 2, FALSE), "Not Found")) This just returns; I tried to add in the same formula for LY but it is saying too many arguments, this is why Michelle is Not Found. Will I also be able to return the area they are in on each of the days ? Any assistance would be very much appreciated.Changing width of columns
When I just change the width of one column (by placing cursor between columns, excel changes the look and cant continue unless I change the Zoom in bottom left. I do not have this issue when changing the height of rows. any help would be appreciated Here is the look of spreadsheet in normal before changing the column and then the after
Data Pulling
I'm trying to figure out the best way to pull data together from multiple tabs within an excel file. The file is made so that it can track issues within reports that are discovered. I'll try to break it down the best I can to explain what I have and what I'm trying to do. Within the file there are 5 tabs that are considered locations and they are named: LX, LV, CR, HR, FL Each tab is set up the same way with the only real important information in these columns of a table Column A - PCR Date Column C - PCR Owner Column G, I, K, M - Modification Category (1-4) these fields are actually drop down options from the Category Master List Within the file there is a 6th tab that has at able in it that is called Category Master List. Column A - Options for the dropdown in the above tab Modification Category columns Column B - Breakdown into one of three main categories (Billing, Compliance, Quality) Now this is what I'm trying to do: Fiscal Year Data (September 2025-August 2026) - I need to see how many times each of the dropdown options within the Master List show up in column G, I, K, M for each of the 5 location tabs. Monthly Data - I need to see how many times each of the dropdown options within the Master List show up in column G, I, K, M for each of the 5 location tabs along with how many times there is an entry with a date within that month. I would like to try and figure out how to put everything into one data table/chart type thing so it's easier to see and compare. Currently, everything needed is across a few different pivot tables and I would really like the data to pull itself automatically instead of me having to go in and copy all the data from one spot into another just to get the pivot results. Below is what I'm having to look at currently.PTO Accruals
Hello I have a PTO tracker that I would like to auto calculate PTO accrual based on hire date. Example, on year 5 from hire date PTO accrual goes from 5.54 per pay period to 7.08 per pay period. I would like for my employees to be able to enter their hire date at the beginning of the year and the PTO tracker to be able to reference functions automatically to adjust accrual after they hit their 5 and 10 year milestones.Testing the MCP Server for Enterprise
The MCP Server for Enterprise is one of a set of preview servers released by Microsoft to show how MCP servers can help Microsoft 365 tenants get real work done. I’m sure things will improve, but the current state of the preview is that it can do a splendid job to answer simple questions, but once things get more complex, don’t depend on any of the PowerShell code the server generates. https://office365itpros.com/2025/12/11/mcp-server-for-enterprise/Word glitching table headers to look like wingdings
Hi, we've had one user report that our table header text occasionally glitches to look like corrupted wingdings: I cannot replicate this issue and don't fully know at what stage of document creation it happened but will update with any extra info they provide. Any help would be appreciated!
(Apparently) Unpredictable crazy colors in Excel dark mode
Hi, At LAST, there is a so-called Dark Mode in Excel, thanks for our eyes! Unfortunately, if the developpers wanted to discourage us from using it, they probably wouln't have done it any other way! In short, I tend to use colors in my spreadsheets to highlight value, especially inconsistent or unwanted ones, obviously. Now, someone at Microsoft seems to have deemed it a decent idea to (apparently randomly) display a dirty brown when I ask for yellow, Except in the buttons backgrounds, which renders the text unreadable, to break the "automatic color" feature that should make the text readable whatever the background color, and not to provide any way to predict what will be the end color of a random pick. Is there any way to set Excel so the color I pick is the one that is displayed in Dark Mode? At worst, is there any way to get a formula that will tell me what values I need to enter so I get the color I really want in my cell? Thanks for any decent update to this really needed feature!Multiple greyed out buttons
I have a spreadsheet that is stored on a Teams page that multiple people can access. I used to have full functionality but now a lot of the buttons are greyed out. On the Review tab, it won't let me select Unprotect Sheet as shown in the attachment. All of the toolbars, Home, Insert, Page Layout, etc. have greyed out buttons. All of the sheets are ungrouped so that doesn't seem to be the issue. Does anyone have any ideas on how to get the functionality back?
Make numbering independent of position
Yes. I want to try that... (The actual question is placed at the end of the post) Below there's a gimmick ilustration of what I'm trying to achieve. The actual document I'm working on is an instructions manual of a complex machine with lots of elements. I want to place referenceable identification numbers of the elements contained in explanations throughout my document. Here I made some baloons by inserting round shapes with added texts and and also some arrows, with the Numbering Style giving me those identification numbers. These let me copy and paste, getting the next number every time. Problem 1: I can't create a new baloon for SolidWorks (for example) and assing it any desired number, like 5. Using "Set Numbering Value..." would do a mess. It seems that doing it would set the first element (that doesn't even show in the ilustration) to 5 and then re-number everything from that. Problem 2: I couldn't find any way to cross-reference headings or numbered lists insided texts in shaper nor inside text boxed. I guess that this is a subject for another post. Question: Is it possible to insert a new list item at any position of that same existing list in another paragraph or shape? It would be something like inserting number 3 like this: 1. Item 2. Item 4. Item Other location: 3. ItemMicrosoft Form
I have a query regarding Microsoft Form: For an example: I'm running a school, where 500+ students are enrolled. To collect some details, we request each & every student to fill the MS Form. My concern in MS Form: There is a branching field in MS Form, if the student is new joined, then he/she has to fill the entire form manually. If the student is an existing student, then he/she has to enter the unique ID from the drop-down field, and the rest fields will automatically pop-up or field with the responses. Once the student confirms that he/she is an existing student option, then they will get an option with the list of drop-down where they have to select their unique ID, and the moment they select the unique ID the remaining fields should automatically capture/display or pop-up the basic details which has been submitted earlier when they were the new joined. I would like to know will it be possible to achieve the above via any means of source, such as React, Python, SPFx, web developing, Power-Automate, Power App or anything. Thank you!Compare or search one data table in another table in Excel
Hi, We have two data tables in Excel that have a foreign key (a common field with the same data type). We want to search for the existence of data from the first table in the second table and identify if there are any inconsistencies in this comparison of the two tables. It should also display the found data separately. What method do you suggest? tnx
Office 365 - how do I fix a duplicate problem
I had Office 365 for my home office throuogh Go Daddy. I closed the business and cancelled GoDaddy - no more Office 365 So I signed up for Office 365 Personal and paid the yearly fee. Now I can't use Word because they have loaded all my ols business data and when I try to uses Word it says I need to sign up - when I already did Total frustration for the last 3 months trying to figure it out. Can anyone help? email address removed for privacy reasons
Recent Blogs
- Writing formulas can feel intimidating, especially when you’re unsure of the syntax or which function to use. We’ve already made formula writing easier with formula completion, which proactively su...Dec 11, 2025
- This new opt-in feature delivers a more polished, welcoming, and intuitive experience on Mac.Dec 10, 2025
