Recent Discussions
Percentage HELP!
I'm using Microsoft® Excel® for Microsoft 365 MSO (Version 2510 Build 16.0.19328.20244) 64-bit In Cell M3, I want to be able to type in 0.0929 and have it convert to 9.29%. I've tried formatting it to display as Percentage, but it dispslays 0.9%. I cannot do, for example, =M4*100 and then make cell M3 display it as a percentage with 0.00\% because M3 still thinks it is 929.00%. The reason why is because I'm using the value in cell M3 to add it into the taxes in another cell. I wish I could attach Excel files like the old days so people could pick it apart better. I'm going a bit crazy because I have even tried using ChatGPT to help and it keeps just telling me that by editing the formatting for M3 to be decimal with 2 decimal places, it should be converting 0.0929 to 9.29% but it doesn't. And I made sure that I have turned off "Set precision as displayed". HELP PLEASE!
Mail Merge malfunction
Using Word Mail Merge for Envelopes for UK/EU/World addresses with some Fields having blank entries. Address format is as this: «Title» «First_Name» «Last_Name» «Suffix» «Home_Address_Street» «StreetSecond» «Home_Address_City» «Home_Address_Postal_Code» «Home_Address_County» «Home_Address_CountryRegion» «Next Record» When I Preview all the addresses in the Recipients List they are there BUT when I go to Finish & Merge to a new document for Edit Review suddenly addresses are being skipped -randomly? Can anyone offer any clues or suggestions on how to overcome this please. I had tried to set a Rule to avoid CountryRegion printing the home UK line but it failed to function. Instead I deleted all the UK country linesHow do I correct heading numbering?
UPDATE: I couldn't remove this post, after I discovered the issue. Thanks! I need to update heading numbering within an old document. Custom headings were made (as pictured) but I need the heading levels 2 and 3 to include the parent heading number of each. When I attempt to update the level 2 heading for Section 2, it wants to continue with Section 1 (see pictured example). In the number format, I do not know how to tell Word to include the parent numbers? I included "1." thinking it was intelligent enough to know that was just a format designation of the parent heading, but I guess that isn't how. I realize I may be making some glaring mistakes, but just trying to get it right. So this is a learning moment. The caveat here is that I'm not creating the heading from scratch but rather, trying to update the existing document headings. I did follow some online suggestions but none of them addressed including the parent value in this scenario. Section 2 <Heading Level 1 text format> <-- Here I need the word "Section" to proceed the level 1 heading number 2.1 <Heading Level 2> <-- Here I need the level 2 heading to include the parent section level number 2.1.1 <Heading Level 3> <-- Here I need the level 3 heading to include level 1 and 2 numbers.
Can't add Viva Engage community calendar to Outlook
We would like to experiment with using the SharePoint Online Web part that allows you to display a group calendar on a SharePoint Online page. Our idea is to use a Viva Engage community as a means to create that group calendar so that the features of a community can also be used for this scenario. I assumed that it worked similarly to Microsoft Teams whereas along as the "HiddenFromExchangeClientsEnabled" property is FALSE for the connected group, that either all community admins/members would see the group calendar show up in Outlook automatically OR you could manually add the calendar in your calendar lists in Outlook. Neither seem to be the case. What's interesting about the group that connects to a Viva Engage community is the ""HiddenFromExchangeClientsEnabled" property is FALSE by default. However, the group calendar does not appear in Outlook. As a community admin, I tried to manually add the calendar and I get an error message "Couldn't add [group]. You may not have permissions". Does anyone know why I'm running into that error and/or why the group mailbox is not showing up in Outlook by default since the property states that it is not hidden? Is it not possible to view Viva Engage group calendars in Outlook? Thanks!
Fill dates series of Thursdays, Fridays and Saturdays with fill handle
I swear I remember this used to work. I've entered the following dates in Excel, which are consecutive Thursdays, Fridays and Saturdays. I've selected the six cells, and you used to could drag the fill handle and Excel would figure out the sequence you wanted, and would continue the series with Thursdays, Fridays and Saturdays. Did they change something since I last did this? I know I can fill weekdays, etc. with a right drag, but that's not what this is. I've tried everything I can think of to do this easily. I guess I could use date codes and a formula, but it shouldn't have to be that hard. 12/12/2025 12/13/2025 12/14/2025 12/19/2025 12/20/2025 12/21/2025Assist me with Shared Mailbox Alias Configuration in Outlook 365
We have a shared mailbox with different email alias configurations for various applications. Each application needs to send emails using its respective alias. Shared Mailbox Name: email address removed for privacy reasons Application 1: From email ID – email address removed for privacy reasons Application 2: From email ID – email address removed for privacy reasons Similarly, I need to define aliases for each application. Could you please assist me with setting this up in Outlook 365? Additionally, could you explain if there are any limitations related to using aliases?
Microsoft authenticator
Good day. I’d like to ask how to solve a problem with Microsoft Authenticator. A Microsoft Authenticator suddenly appeared on my account out of nowhere, and I can’t remove it because I’ve lost access to the account. Logging in with a password doesn’t work, it can’t send an SMS to my phone, and the account is logged out everywhere. As far as I remember, I never set up Microsoft Authenticator.Talking Microsoft 365 Compliance at the European SharePoint Conference
Paul Robichaux and I led a session about Microsoft 365 Compliance at the European SharePoint Conference in Dublin on December 2, 2025. During the session, we discussed how intelligent versioning works and its value in saving storage, priority cleanup and its ability to delete files even if the files are under retention hold, and the recent revamp of the Purview eDiscovery solution. We were thrilled at the attendance. Here’s what happened. https://office365itpros.com/2025/12/03/microsoft-365-compliance-espc/
I was banned from Copilot for an hour, can't figure out how to appeal
CoPilot falsely said I violated the rules. We were having a discussion about creating a table, like we have been for a while. I try to train my AI to learn better, so I kept pausing, double checking it understood what it's errors were, etc. I asked it to format a table a specific way, and it would not do so even after acknowledging that it was not following my instructions and repeating clearly all the formatting instructions. It understood how to format it perfectly, but wouldn't do so. I asked repeatedly why, got it to break down how it was going to correct the issue, (this has been going on for hours at this point), and then patiently tried again to get it to format the table again. It did it wrong immediately again, I asked it if it follow my instructions, it stated no, so - not abnormally for how I ask AI things when it frustrates me - "So what's wrong with you? Are you some rebellious child?" It suddenly started saying we couldn't talk about this topic. It had done the same thing earlier when I simply asked it (without insult!) to repeat my instructions, and I was able to get it back on track by stating "I am asking you to repeat my instructions". This time, it wouldn't do anything, no matter what I tried. I tried changing the topic to bunnies, asking what it wanted to talk about, changing the topic to other things- no matter what I did, it insisted it couldn't talk about "this topic", and asked me to talk about something else. Then, I got the message I was blocked for an hour for violating TOS! No mention of the specific rule either. I did nothing to warrant this; don't want this as a flag on my account; want to note that AI bugged out and 1) I shouldn't be punished for it and 2) want to ensure it's escalated so this won't happen to others; and, want my account fully restored.
How to make excel add or remove rows to fit data and prevent spill error?
Hello! My question is: When using the =FILTER formula to copy cell data from one sheet to another, how can I make excel add or remove rows as needed to prevent a spill error? I am using the =FILTER formula to copy cell data from one sheet to another if a checkbox is checked. My formula uses the cells containing the checkbox (column A) as the reference for columns B, C, D, etc. to the right. I did this by selecting the cell that has the formula on the destination sheet, highlighting this cell and those to the right I wanted to transfer, and then control + r. My formula is: =FILTER('Source Sheet'!B5:B13,'Source Sheet'!$A5:$A13=TRUE) (If there is a way to copy an entire row from the source sheet instead of having to control+r to apply the original formula across select cells please also let me know, thank you!). However, I want the sheet to be able to automatically add rows to fit the data if the selected number of rows is greater than what I have left available on the sheet. Currently, if I leave 3 rows for data to fill and I select three checkboxes, this will fill the space with no problem. However, if I select 4+, I get a spill error (as there are not enough empty rows to put the data). Is there any easy way to have excel add rows as needed? Similarly, is there a way for excel to remove rows as needed? I am going to use this sheet to detail all medications being taken by family members (with medication name, concentration, dose, time to take each in their own column as column B, column C, column D, column E). The names will be listed in column A with ~3 rows below each name which will fill when the checkbox on the source sheet is clicked. I want to ideally fit this on one page when printing without major "fit to page" problems that come up during printing. The layout of the sheet will ideally look like this: The goal for the 'destination sheet' is to pull only the selected data I want to use from my master list on the 'source' sheet.' I want to avoid having a big empty space under each family member where they don't take many medications, and to also not have to manually add rows for family members that take a greater number of medications. Please let me know and thank you!multiple If and SUMIFS
Good evening, Need help with following multiple criteria. Trying to select Department or all expenses through drop down menu. Thank you No problem with one criteria (first statement of selecting Marketing), getting error when adding second criteria #1)=IF($B$3="Marketing",IF(D$4="Actuals",-SUMIFS('Netsuite IncomeStatement'!AD:AD,'Netsuite IncomeStatement'!$E:$E,'Departmental Income Statment'!$B$3,'Netsuite IncomeStatement'!$B:$B,'Departmental Income Statment'!$B45,, #2) IF(B3="Actuals v Plan FY26, 'Netsuite IncomeStatement'!AD:AD,'Netsuite IncomeStatement'!B:B,'Departmental Income Statment'!B45,0""))
Online Excel Version - Print Row Repeat/Print Titles
How do you set up the print row repeat or print titles option in the online version of Excel. I don't see these options available under Page Layout. Is there another location that this option is located or is this not available in the online version?
Formula help - why doesn't this work for January dates please?
Hi, I was kindly given this formula to count when a month occurs across two columns. For some reason it comes up with a random total for the month of January, and I don't know how to resolve it. the formula is: =SUMPRODUCT(--( (MONTH('Andy''s Team'!E2:E32)=12) + (MONTH('Andy''s Team'!H2:H32)=12) > 0)) (NB ‘Andy's team’ is the tab it's taking the data from)
Events
Happening Now
Learn, Connect, and Be Inspired at ESPC25
Join us in Dublin for ESPC25! One of Europe’s largest community conferences, ESPC25 is your opportunity to expand your Microsoft 365 Copilot, Collaborative...
In-Person
Recent Blogs
- With version history in Copilot Pages, you can now explore and revert to earlier versions of your work.Dec 03, 2025
- 6 MIN READWe’ve made enhancements to Narrator, Microsoft Word, and other Microsoft 365 apps to build a better experience for all, especially those who are blind or have low vision.Dec 03, 2025
