Recent Discussions
How can I display negative values for time in calculation results
I'm trying to create an Excel spreadsheet with a column that shows the time relative to a predetermined point in time in 15-minute intervals with negative values for time in the cells above 0:00 and positive values below. I have the correct formulas entered in, but I can't seem to figure out how to get Excel to display negative values for time. Is there a way to do this?
restrict external services using assigned\delegated api permissions to single files
I have an ongoing issue where my customers want to use external services to perform tasks, but those services require access to SharePoint. Of course the complete security non minded service providers say they need sites.readwrite.all permissions. I'm not going to give them access to read and write every single one of my internal SharePoint sites when they only need access to one file. Ridiculous in this day and age with so many data breaches happening. Now i have used the sites.selected to some success to limit this but it's still all the site. How can I get this down to file or folder level within a site? Has to be something we can do.
How does Excel calculate named formulas and materialized named ranges?
I have been creating utility formulas with AFE to make my lambdas more readable and maintainable, for example: ManualAllocRng =OFFSET(ManualAllocCorner,1,0,URows,EntityCount); How does Excel calculate these results? Are they calculated every time I use them, or is there an internal type of materialization that happens once and then is re-referenced on each usage? In particular, I am wondering: (1) If I have a lambda that references my ManualAllocRng twice, does it matter if I write it as thing = LAMBDA(x,LET( rng, ManualAllocRng, a, something(rng), b, otherthing(rng), res, combine(a,b,x), res )); or as thing = LAMBDA(x,LET( a, something(ManualAllocRng), b, otherthing(ManualAllocRng), res, combine(a,b,x), res )); Does version 2 calculate the result twice? Does version 1? (2) Should I instead be materializing the value in a Calcs sheet, naming the corner ManualAllocResMaterialized, and using ManualAllocResMaterialized# throughout the workbook instead of referencing ManualAllocRes? Does every reference to the named formula calculate its result again? Does every reference to a spill recalculate the result, or does it "look" at the spilled range that was already calculated? On a related note, I have found a circumstance where sheet-based spilled result =Ledger.FilterMatch produces a different result from VBA Dim B as Variant B = Evaluate("=Ledger.FilterMatch") This seems like a serious bug. So I am considering materializing all my AFE-based named formulas onto a Calcs sheet just to avoid this bug, even if there is no performance issue to consider in the questions I asked earlier.
Custom Validation in Forms
Hi, I have a text field in forms, and I was wondering if I could do some kind of custom validation or multiple validations (i.e. 1 AND (2 OR 3)) on that text field. I feel like I have seen custom validation functionality (e.g. RegEx) before but this is not available in my version of Microsoft forms. Suppose it is only available in another version of Forms (i.e. Pro), is it possible to request for this functionality to exist in the normal version? The reason why I cannot use power automate or what not to post validate is because I do not collect E-mails (Not because I don't want to, but because my users simply don't have one or do not maintain one).If, Then formula from multiple columns
Hi there! I'm doing a mail merge for a scholarship award letter. The data report that we're running doesn't specify where the funds will be deposited in words. it only has a header of locations a, b, c, etc. and underneath it says "yes" or is left blank. Right now I have this on a sheet labeled "data" The merge is pulling from sheet 2 labeled "merge" in the award letter we need to insert "your award will be applied to <<location>>" so what i've done so far is made additional columns with this formula: =IF(BG3="Yes","LOCATION A",0) where I'm stuck is: how do I take multiple columns of information (one column containing a word and the rest 0) and tell a cell on another sheet to pull the word out and leave the zeros. If there's a better way to take the initial data and narrow down this information into Sheet 2 "merge"?
Vlookup using short and full name with case insensitive
Hi Experts, I have a sheet named Source, with these columns: Column A: ID Column B: Full Name Column C: Department (data starts from Row 3.) I have a sheet named Sheet2, with these columns: Column A: dept with short name Column B: Full Name Column C: ID Column D: Department I would like to populate the data [full name, ID and department] in sheet Source into sheet2 column B, C and D respectively by matching the short name with the full name. Upper/lower case mismatch and name not match exactly, only can match 2 words. What formula should i use to insert into Sheet2, column B so that I have the information to be automatically filled up in column B, C and D ?Excel sharing, New Outlook and Outlook 2016
Hello, when I try to share an Excel file (File => Share => Send as attachment), Excel opens Outlook 2016 (Office 365). But I only use New Outlook (the native Windows application). I've changed the default application, but it doesn't make any difference. Do you know how to force Excel to share files through New Outlook? I'm French and I used a translator. I hope you understand.Excel bug Data sorting largest to smallest
I have some problems by sorting data in excel. First sorting by column M Largest to Smallest, than by column L also Largest to Smallest. In one case sorting is not successfully (Marked font color RED). Can someone explain this to me? https://drive.google.com/file/d/1n_IWsw9YH6FDxXnFm_wWwJEVQIN9AxRu/view?usp=sharingPower Pivot Connection Issue
Hello everyone, Recently I have prepared an Excel file with 2 different tables. One is the Headcount Table which has the agent information. The other one is the login data for those and many other agents. I added these two tables into the datamodel and connected them with the column that contains the Agent Usernames. Then I added a Power Pivot from the database and added the login data to the values to see the login durations. Then I add the agent names from the Headcount Table to the rows section of the pivot. Every agent name that I have on the HC table appears but for some reason the duration shows me the total duration of the all agents for each agent. I'm sure I did everything correct because I have some other files with the same exact way but for some reason this one is not working properly. Instead of giving me the login duration for each agent itself, it is showing me the grand total for each agent. Below you can see the grand total is the same as all the agents because for some reason its directly taking the total for the agents as well.
How to count duplicates ... sort of ...
Greetings! Here is part of a table that I am working on: RepairID ModelID Serial Number Date Started Date Tested ReportedSymptom SPEA-1010 PT206 8FA552 10/22/2025 10/28/2025 No Boot - White Screen SPEA-1024 PT206 8FA552 10/22/2025 11/4/2025 No Boot - White Screen SPEA-1037 PT206 7C99BD 10/22/2025 11/10/2025 EGM No Comms SPEA-1038 PT206 715473 8/21/2025 EGM No Comms SPEA-1039 PT206 715473 11/10/2025 11/11/2025 Failed Battery Test SPEA-1056 PT206 7142AE 10/20/2025 11/12/2025 Black Screen SPEA-1057 PT206 71584F 10/20/2025 11/12/2025 Black Screen SPEA-1144 PT206 7142AE 11/24/2025 11/24/2025 No Boot - Black Screen I am trying to count the number of repairs based on serial number in this table. But there are some duplicates. However, if you look at the rows with red font, you will see that the serial numbers, though they are the same, were not being repaired for the same reason. So, these need to be counted as 2 separate repairs. If the repairs to the same serial number are for the SAME symptom, we only count it once. What would be a good approach to creating a function that will count this into a cell on a separate table? Any assistance would be greatly appreciated.
Is there no way to allow people to comment on my word document?
I am trying to share something I am working on with beta readers and some friends but the only options are "can edit" or "can view". There is no option for "can comment" or to let them viewers use the review function. I asked for help with the issue and got told that because my account is personal OneDrive and not business that there is no review only feature. Was that a mistake or is Microsoft really this behind on basic features? Google Drive has allowed giving people access with "comment only" for years.
How 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!Task in Word comment does not show in Planner or To Do
When I check of to assign a task to a person the task is not assigned in Planner nor in To Do. It only send an email. Is there a setting which needs to be changed? https://support.microsoft.com/en-au/office/using-modern-comments-in-word-edc6ae71-0a2d-49fe-8faa-986f1e48136aExcel banner goes grey in MacBook when screen is maximised
When I click green circle in top left/h corner to maximise screen in macbook, the excel green header turns grey and icons are dificult to see. if i then click yellow circle to part minimise screen, header goes back to green. I have done a short screen capture video to show this. Why is this happening, can it be fixed please? Tks, Jon.Ugly Defender awareness training screen
I want to use the extensive training material available from the E5 licenses we just shelled out a boat load of $$ for. However, when someone gets an invite and they click the link to do the training they are taken to the Defender page. This might be fine for a technical person but its ugly as F for my users. Plus, there is extra rubbish like Threat Intelligence, Trials, Reports, settings etc they can access that I don't want them too. This is not a very polished interface for non-technical people. Is there a way to fix this? Can it send them the direct training URL, so it just opens the training and not the defender page from them to open the video? Can we do a custom landing page but put the assigned training URLs into that? This is ugly there has to be a way to make this more user friendly.Excel selects wrong cell
Hello, I am here to report on what seems to be a common issue... After working for a few minutes in excel, when I go to click on a cell, the wrong cell actually gets selected, and it is usually several cells above or below the cell my mouse is hovering over. I sometimes have success in saving, closing and reopening the book, but not always. Excel Office 365 version, updated on schedule, as always.merge cells
I have a table with dozens of rows and seven columns. Each column (B through H) contains a two-digit number in txt format because I want to retain the leading zeros. I'm having trouble merging the different numbers from columns B through H into a separate cell (column A). The goal is to merge each individual row (columns B through H) into the same row in column A. A B C D E F G H 12345678909854 12 34 56 78 90 98 54 65432109870203 65 43 21 09 87 02 03 … None of the formulas provided in Excel (Microsoft Office LTSC Professional Plus 2021) help. Do you have a solution? Thanks in advance.SharePoint sync issues when opening from File Explorer
Hi there, Some users in my company are having issues with files not syncing with SharePoint when they save them and are also unable to concurrently edit files. They open the files via File Explorer and the 'autosave' functionality is disabled. Enabling autosave prompts them to save as a new copy. These users have recently switched to a new laptop running Windows 11 (previous laptop was Windows 10) and had no sync issues when using the old laptop. If the user first opens Excel/Word and then uses the File menu to open the document then the autosave is enabled and the file syncs with SharePoint. Here are some of the troubleshooting steps I've tried: stopping the sync and starting it again unlinking the pc and re-syncing the SharePoint site uninstalling and re-installing OneDrive Has anyone come across this issue or know of a fix that I haven't tried yet? Regards, Steve
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
- 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
