Recent Discussions
How to get all possible permutation in VBA
Hi, We all know Benjamin Franklins Square. How can I Get VBA to export a spreadsheet with all possible permutations for numbers 1-9. Filter out duplicates of the same number Filter out only combinations that the sum matches the criteria below First 3 digits = 15 Second 3 digits = 15 Third 3 digits = 15 1st, 4th, 7th = 15 2nd, 5th, 8th = 15 3rd, 6th, 9th = 15 1st, 5th, 9th = 15 3rd, 5th, 7th = 15 I hope you are following what I'm trying to do. Thanks in advance, Uncle Bear
How to protect workbook and still open hyperlinks
Hello, I have a workbook that I want to make available to the entire company that shows the status of tasks for a certain process. I want everyone to be able to see the information but not make any changes. I know I can restrict access to prevent that. However, there are hyperlinks to documents in the workbook that users DO need to be able to open. It appears that restricting access to the workbook does not allow users to open (download) the documents via the hyperlinks. Is there a way to allow users to open hyperlinks and still protect the workbook from anyone making any changes? Thank you!!
Vlook up issue related to format of cells between two different files
I want to apply the vlook formula for working purposes, the issue is : I have two files file A Nace codes file B analysis There are 616 rows in file A nace codes while in file B there are 32. When I apply the vlookup formula to find which of these 32 records from file B analysis are found in file A nace code i get no results (always #N/A). I have tried changin the format of the columns still the same results in order to have the same format but still the same results formula applied =VLOOKUP(B2,'[file B analysis.xlsx]Same G diff Code same Name 32'!$B$2:$F$33,5,false)Version 1.5 of the Microsoft 365 User Password and Authentication Report
The Microsoft 365 User Passwords and Authentication report now includes the last used date for authentication methods (when available). The new data is available through the Graph beta API for listing authentication methods and the equivalent Graph PowerShell SDK cmdlet. Another change that might break scripts is a new way to expose the created date for authentication methods. The changing sands of Graph programming… https://office365itpros.com/2025/11/06/authentication-methods-graph-2/
Title: Expose SHA-256 or SHA-1 for Mail Attachments in Microsoft Graph
Problem Email attachments in Graph don’t include a content hash. To identify or match attachments, developers have to download the entire file first. That wastes bandwidth and time and increases exposure. OneDrive/SharePoint already return hashes, but mail does not, so experiences are inconsistent. Request Add a server-provided content hash to every mail attachment. Prefer SHA-256. If that’s not feasible initially, expose SHA-1 as a minimum to align with existing Drive item hashes. Benefits Faster and cheaper: avoid downloading large files just to tell if you already have them. Deduplication: detect repeated attachments across threads and mailboxes. Security operations: correlate attachments with threat intel by hash and triage suspicious emails without fetching payloads. eDiscovery and compliance: confidently match the same document across mail and files. Consistency: a predictable, uniform approach across Mail and OneDrive/SharePoint.
Footer image cropping
Hi I'm experiencing issues when adding png images into footers. When I add the images into the footer, the bottom and right of each image is cropped when printed, no matter the size of the image. The print preview of the images looks correct. There is an additional oddity to this as follows - if I add a copy of one of the images into a cell in the main boy of the doc, then print the doc, all of the images print correctly. Any advice would be great.Need help with a nested IF w/ISNA vlookup formula
A formula that I have been using for nearly 4 years has decided to stop working and I don't know how to fix it. Everything I have tried fails miserably. The formula is this: =IF(OR($L5="Vacant",$L5="Unfunded",$L5="Intern"),$L5,IF(ISNA(VLOOKUP($M5,ActiveFTE[Employee ID],1,FALSE)),"Term","Yes")) Where M5 is the employee ID number. an the Active FTE is the current list of employees. In the past if the person was no longer in the Actice list it would put Term and if it was there, Yes. now, it returns #N/A - the ONLY thing that has changed from the last file and this file is the list of active employees. if I remove the first IF/OR part of the formula it works beautifully, but I also need to flag vacant and unfunded positions. I've tried ISNA,. IFNA, IFERROR as well as putting the IF/OR at the end instead of the beginning. otherwise, any suggestion is greatly appreciated cathyPower Query - SKU Generator
Hi, I am using MacBook Excel Version 16.102.2 I am trying to build a Power Query - that build out a SKU (e.g Column H). Based on the products I've entered in Column E and the Size Range chosen in Column F. I've managed to build a power query - but when I refresh nothing happens / updates. Some screenshots attached of my workings.Comcast email transition to Yahoo
So here is my problem and I have been battling this for 5 days now and Xfinity and Yahoo support keep striking out. I can access my account just fine in Outlook Classic. If I slide the slide over to the new Outlook nothing gets transferred or setup. If I try and add my account manually using an app password it gets to a screen where it states syncing with one drive then I get a screen where it fails and states I need a App Password. I have put in the password multiple times and it seems there is issue is with syncing the mail with one drive in the new Outlook.
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 ApprenticeMicrosoft 365 Companion Apps Fail to Impress
Microsoft 365 Companion Apps are being deployed to Windows 11 PCs now. The apps don’t seem to add much if any value over standard Microsoft 365 apps like Outlook and OneDrive. With that thought in mind, we move to unclutter PCs by either blocking the installation of the companion apps or stopping the apps starting up to take over valuable toolbar space. https://office365itpros.com/2025/11/05/companion-apps-dump/SORTBY newb... Other solutions don't appear to apply??
Hello all! Okay, here is the situation. I have an Excel spreadsheet and each row has a dropdown that allows you to set the priority of the task. The dropdown has approximately six separate items (Urgent, High, Medium, Low, Complete, Review, etc.). I set up a formula to change the row color according to the dropdown (previously they were doing it manually) and it works great. But I also need the entire sheet to sort by the dropdown selection, i.e., it needs to group them by the dropdown selection and order them; all Urgent item rows are at the top of the sheet, High are next, Medium next, etc. SORTBY seems like it can accomplish this, but every example I have seen is dealing with a small range within the sheet and not sorting the order of entire rows. The end result I am looking for is to group rows in a specific order according to what was selected in their individual dropdown and sort those rows. I've seen great examples, but they all seem to just be sorting information in a small range within the sheet and not ordering rows. Thank you for any suggestions / assistance you can provide and I'm looking forward to learning!
Table Borders in Word Disappearing
Over the past week or so, the table borders in our company's Word documents are disappearing. I am seeing a lot of posts in message boards around the internet where people are having the same issue. Is this a known bug with a recent update? Even when we go into the table style and modify the style add the borders, they disappear again once the document is closed and reopened.Match value in cells, perform formula
I have a spreadsheet with a list of items and their costs. I have another section with a list of retailers and a hypothetical discount. How could I write a formula that matches the value in A2 with Column F and then multiplies the value in C2 by corresponding value in Column G? In this example, I would want to find the value of A2 (Kohl's) in column F, and then multiply the cost of the shirt, C2, by the discount % Kohl's offers, G4. I don't want to have to do multiple manual formulas of = C2 * G4, it's a big spreadsheet.Troubleshooting Queries in Access
Hi All, I am trying to run a query in an Access database, the query is expected to populate an existing table with new data, however it is not running as expected. As per the set-up process, 1. Have deleted old tables (with previous data), and imported new data for these tables from a different Access database 2. Then I am doing a compact and repair. 3. Then I am running query that is expected to populate the table, I see no records are added to the table Could this be a file reference issue **or** lack of data **or** missing tables /steps **or** a connection within Access. Appreciate step by step process to diagnose the issueMicrosoft Won’t Dump Outlook for a New AI Client
A recent report says that new Microsoft leadership wants to reimagine Outlook with lots of many AI features to make the client much more of an effective assistant. While this might be true, it doesn’t mean that New Outlook is dead. However, there’s a bunch of uninformed commentaries out there alleging that Microsoft will change course dramatically. I think there is little chance that this will happen. https://office365itpros.com/2025/11/04/new-outlook-not-dead/People data lookups
Hi, I have created an MS Form where anyone can nominate their peers for recognition - we have 20k employees. I've added a field in the form for a unique employee number for the nominator to include. So they would submit the nominee's: emp number, full name, role, area of the business. The output comes to me in excel and I need to update a list of 00's of employees, where they work, their contact details, line manager detail etc. The challenge is this: whilst I can do all the look-ups to the external data to provide this, the output of the form could have numerous errors. First of all, a missing emp number or incorrect emp no. Second of all, incorrect name spelling, or shortened names, or duplicate names, or too many spaces etc. Then there's incorrect role or missing role, and finally the same for area of the business. Using either multiple IFs or look-ups or Power Query, what's the best solution to pull through the correct emp number (from my external data), when those first four fields could be all wrong, partly wrong, missing or all correct, and what about dealing with duplicate names? I can concatenate if the four fields are correct, but this isn't reliable. Is there a fuzzy match that takes the best guess at the four fields completed - leaving me to just check a handful of #N/As? I have Copilot and licence too. Thanks!Recording just a month and a year
Hello - Looking to refresh a spreadsheet I have for keeping track of all my books, games and when I complete them and what-not. One thing I'd like to properly set-up this time is a pivot table of some sort, so I can generate some charts based on what I've completed in a given month. My first thought is I need a way to make a note of what month I completed something in, alongside the year so I don't get mixed data with this going forward. Is there a way for Excel to record a month and a year specifically, without needing to specify a date? Or would it make more sense for me just to have a "Jan-2026" as a general entry? Seems simpler, but don't know if it'll auto-sort by month like would be ideal.
Events
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
- Thanksgiving and Christmas are fast approaching! Prepare for the holiday shopping and travel rush with Microsoft Copilot.Nov 06, 2025
- Bug Name Issue Fixed Undo/Redo don’t work for Bring To Front and Send To Back commands. In Form/Report Design view, after executing a Bring To Front or Send To Back command...Nov 05, 2025
