Recent Discussions
How to eliminate any height beyond text height on textbox
Why? I need to make a special Quick Part where stacked text boxes are close enough to overlap each other before the actual texts start overlapping. This makes the text input afterwards a struggle. I can fine-adjust the space at the bottom by dragging a text box's resize handle, but the space at the top doesn't disappear. I've already removed margins, paragraph spaces and set line spaces to minimum. Setting vertical alignment from Top to Middle doesn't change this behavior. Is it possible to adjust the text box's size to fit the text size exactly?
M365 Licensing for small retail store
I have a client who is a small retail store, using generic email addresses based on department, as opposed to individual users. Looking for the best way to license for Office Desktop Apps. Scenario: Front counter - 2 x PC's and both need access to generic email address sales@ Back office - 1 x PC needs access to generic email address admin@ For us to have Office on these machines, using M365 is the correct way: Option 1: Front Counter: Create Business Standard License and email address sales@ Install Office on both machines, as Business Standard gives up to 5 copies of Office Back Office: Create Business Standard License and email address admin@ Install Office on both machines, as Business Standard gives up to 5 copies of Office Option 2: Create 3 x Business Standard licenses, one for each PC - although the associated email addresses will never be used and be hidden Create a shared mailbox sales@ and admin@ Assign permissions for shares mail boxes as needed - the shared mailbox would need to be the default Send From email addresses I am getting conflicting advice - Option 1 is not legal as the mailboxes are not actual people, and Option 2 seems clunky Business does not want to purchase once off copies of Office due to wanting to pay monthly... Welcome people's thoughts.
Trouble Setting and Clearing Filters
Hello all. I'm on Day #2 of my VBA experience. I'm working on a spreadsheet in which I'm using a series of command buttons to filter the content my data. I have the following three subroutines - each associated with an individual command button. (ok ... I lied, there's about 20 buttons - each of which sets a different filter - but I can demonstrate my issue with just these three) When "Button A" is selected - it executes the following code: Sub xJitFilter1() Rows("14:14").Select Selection.AutoFilter ActiveSheet.Range("JitComp1").AutoFilter Field:=13, Criteria1:="1" End Sub When "Button B" is selected - it executes the following code: Sub xJitFilter2() Rows("14:14").Select Selection.AutoFilter ActiveSheet.Range("JitComp2").AutoFilter Field:=14, Criteria1:="1" End Sub When "Button C" is selected - it executes the following code: Sub ClearAndReturn() Rows("14:14").Select If ActiveSheet.FilterMode Then ActiveSheet.ShowAllData End If Selection.AutoFilter Range("xJitLanding").Select End Sub It works just like I want it to - IF I select the buttons in a specific order. For example: Button A --> Button C --> Button B Works perfectly However, IF I select buttons in a different order (i.e.,) Button B --> Button C Crash and burn: Run Time Error 1004: Autofilter Method of Range Class failed If I selection Button C (i.e., ClearAndReturn) when first opening the spreadsheet - prior to selecting one of the "Set Filter" buttons (i.e., Button A or Button B) - it's crash and burn with the same Run Time Error. Bottom LIne: IF I select any of my 20+ "Set Filter" buttons - and followed by the "ClearAndReturn" sub ... I can bounce between filters all day long. The "ClearAndReturn" sub without having selected a "Set Filter" button or try to go from one "Set Filter" button to another ... instand fail. I assume I'm failing to reset something in the environment ... but darned if I know what! Can anybody point me in the right direction? Thanks - SpaceNormanHow to sum chain values from N-number cells?
Hello, I have data of people by age, but 100 different values on a line chart would look... bad. Hence the need to group ages in sets of 5 or 10 on a separe line in chain, but what is the function to do this? It certainly isn't the humble SUM function, since it moves the range by one, producing "1 the problem". Sure, I could do the SUM chain and delete four cells between keepers, yielding "2 the problem", but that's just awful. Or I could do "WHAT I SEEK" manually, if I had an enernity... Thanks in advance, and have a wonderful day!
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)
Building relationships in data model to leverage power pivot - circumventing unique key ID issue
When building relationships between two data tables in the data model of excel, you require a unique ID / key to relate the two datasets. This makes sense but I find it has an issue: It requires you to reduce the entirety of your dataset down to unique ID's in one of your tables so that it can do the 'one to many' relationship build. If you don't have unique ID's / key, the relationship between two tables often doesn't work. Yes you can use an intermediary table with unique ID's to link the two complete tables, but when using that intermediary table I find you are limited in what additional data rows you can bring into the combined power pivot table to provide context to the relationship. Once you start bringing in contextual rows from the separate tables, there ends up being a lot of repeated values for any numerical figure from the other table, which you are trying to aggregate. An example below of the power pivot table result (data from table 1 in blue, from table 2 in green) Product ID (Unique Key) Service Line Sales Amount COGS 169AKY T Shirts $1,000 $7,500 169AKY Sweaters $2,000 $7,500 169AKY Socks $3,000 $7,500 169AKY Turtle necks $4,000 $7,500 169AKY Pants $5,000 $7,500 COGS from table 2 also has the data broken out by Service Line (T-shirts, Sweaters, etc.), but will only show an aggregate COGS value for all service lines for each unique product ID, instead of breaking it out by Service Line. This is because the Service Line column is being inserted into the power pivot table from table 1, it breaks out sales by Service Line. If you insert the Service Line data column into the power pivot from table 2, COGS would be broken out by Service Line, and only an aggregate for sales would be produced. Ideally the power pivot would display sales AND COGS broken out by Service Line (and Product ID). Is there a best practice for building relationships (unique ID's) between data tables: Without reducing the richness / variety of columns and data in your original tables (when creating the unique ID)? Maybe 'group by' function in power query to obtain unique ID's before building the relationship? With retaining the ability to slice and dice the data by different characteristics (assuming they are present in both source tables) and have that detail presented in the power pivot. Thanks for the help! The humble ApprenticeApp-Only Authentication for SharePoint Online PowerShell
The latest versions of the SharePoint Online PowerShell module support app-only authentication (certificate-based authentication) for the Connect-SPOService cmdlet. In other words, applications can now connect to SharePoint Online to run administrative cmdlets by presenting a registered Entra ID app and an X.509 certificate instead of the credentials for a human SharePoint administrator. It’s a good change, even if I still prefer using the Graph APIs for SharePoint automation. https://office365itpros.com/2025/12/02/app-only-authentication-spo/Mircosoft forms email
Hi - I have set up an internal reporting system using microsoft forms - all works well - have built power automate to direct reports to the right teams. The only thing I can't figure out is why each report comes with my email rather than the email of the reporter? I know the answer must be simple as it is forms - but I can't work it out. Any ideas? Thanks Noy
How should I write this Process?
I am not sure how to do this in function for without going through a long chain of manual brute force steps and hope I'm in the right discussion group for this. I have hunted the help hits on my search engine, but I'm not even sure if I am asking the right question so I am getting frustrated. The picture below shows where I am now. I want to set up a Function the will roll a d100 x number of times (with individual rolls reported, not added together) with x equaling the row's Chances cell (an assigned value). The 1 and 47 are the established Red/Blue cut offs for a different cell to process (outside this question, but will take suggestions if you have them). Ideally they would display as "81, 28, 42" etc. but I am interested in the function lay out. When it comes to Functions, my knowledge is limited the very basic ones and I am using baby talk when I do use them, so please be kind. Is this even possible or I am I just being crazy/unrealistic?Microsoft Authenticator issues
I’m simply locked out of my personal account because I lost access to my 2FA and the recovery form rejects due to active two-step verification. I’ve tried my verifying email and phone number but it rejects is due the active two step verification. I need manual identity verification or an escalation so my 2FA can be reset. Can you point me to the correct support channel for personal account recovery, because the link you sent is not workingAccents & Characters using "Alt+Code" appear twice on Word
Hello everyone I have been struggling with a bug on Word. Everytime I type a character using "alt+code" such as ô which is alt+0244, the character appears a second time at the next stroke of a keyboard key. Has this happened to anyone else? If so, do you have a fix? Many thanks MichaelAdd VBA Code to an Option button dynamically
Hello Excelers, I hope you are doing well. I am back for some more help and here is what I am trying to accomplish: I have some code that would add x Option Buttons to a User form. x is Unknown but usually less than 15 but maybe more at times. I need to assign a macro that would return the newly created Option Button's Caption. In a Module I have: Dim objOptBtn as MSForms.OptionButton In a For i = 1 to x loop I have: Set objOptBtn = uFrmChoice.controls.add("Forms.OptionButton.1","objOptBtn" & i,true) With objOptBtn .Caption = i .snglTextWidth = Len(objOptBtn.caption) .width = snglTextWidth + 18 .Left = 10 .Top = TopLevel + 10 .Width = 400 .Height = 18 End With I remember there was an .OnAction "MacroNameYouWantToRunWhenOptionButtonIsClicked" But I do not see it in the Intelisense???? How can I assign code to run once the user clicks on a Option Button on the UserForm and return the Caption of that Option button? I am trying to ask the user to choose ONE option from a set of unknown options.
Excel Formula Help: Reflecting Dynamic Monthly Credit Card Payments by Date
The Goal: To display the correct monthly payment amount (from the Debt Schedule tab) on the Main Worksheet tab, placing each payment under the correct date column (J4:AV4) based on the due date for each credit card. The Problem: The Debt Schedule tab lists multiple credit cards and a month-by-month payoff schedule. As each card is paid off (listed lowest balance to highest), its scheduled payment rolls over and is added to the next card’s payment. However, the formula I’m currently using on the Main Worksheet tab does not capture these changing payment amounts over time. I need a formula or approach that dynamically reflects the evolving monthly payment amounts as cards are paid off. Google Drive Link: https://docs.google.com/spreadsheets/d/1jPYLWfuOxEtxF3Mvfo5PFUTsE3_x_5iH/edit?usp=share_link&ouid=102575009763592887799&rtpof=true&sd=true
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""))Filter cells in stead of full rows by color
Hi, I have an excel that contains a set of columns with values where in each column each cell has a certain fill color. Now I want to see per column only the cells with a specific color e.g. red. I tried the filter option on the columns, but that filters complete rows. I only want to filter the cells in a column. So in the image below I want to see only the red cells. So in column B no cells, in column C C3, in column D D4 and D5. The regular filter option would show B3 and B4 as well, because it would show the full row for C3 and the full row for D4. Any ideas on how I can achieve this? Thanks!What Is the Compliance Manager Secure Score in Microsoft 365?
Companies and organizations are moving their operations, communications, and data management to cloud based environments, the need for strong compliance and security practices is now very important. Microsoft 365 provides a full suite of tools designed to help customers stay secure, productive, and compliant with all evolving regulatory needs. One of these essential tools is Compliance Manager Secure Score. In this blog we will go through Compliance Manager Secure Score is, how it works and importance of it. https://dellenny.com/what-is-the-compliance-manager-secure-score-in-microsoft-365/
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
- Word began offering verbal confirmations for common shortcuts last year. We’ve since expanded support to 60+ additional scenarios!Nov 25, 2025
- 4 MIN READWelcome to the November 2025 update. This month, we’re excited to share several enhancements across Excel. Announced at Ignite, Agent Mode in Excel now includes web search and Anthropic model support...Nov 25, 2025
