Recent Discussions
Specific Rounding Rules
Howdy! My job has a bit of a weird rule for their rounding technique. I was curious if there is a way I can format my cells or write a function that allows for it. The rule is as follows: If the number your rounding is proceeded by a 5, instead of rounding up, you look at the number being rounded. If it is even, you rounding down else you round up. Basically you want the number your rounding to remain at an even number if it's being rounded by 5. Is there a way to get this rule into excel? Thanks in advance for the help!
How to write a script or any PQ or in Excel to download the zip files from a Webpage
Dear Experts, Greetings! https://www.etsi.org/deliver/etsi_ts/138300_138399/138306/ Could you please help me on how to download the pdf.zip files from above for all the versions? Using a single command in Excel or PQ-option. Thanks in Advance, Br, AnupamConnecting SharePoint Data to Copilot Insights A Complete Guide to Smarter Collaboration
The integration between SharePoint and Copilot Insights gives the chance to users ask natural questions about their organization’s data and receive instant, intelligent answers, with no more digging through folders or chasing document versions. https://dellenny.com/connecting-sharepoint-data-to-copilot-insights-a-complete-guide-to-smarter-collaboration/
Why is my =SUM equation not giving the correct total?
I have the following numbers in the following cells A1 97 A2 39 A3 66 A4 43 A5 43 A6 53 A7 45 A8 56 A9 17 In A10 I have the following equation =SUM((A1:A8)+(A9*5) In my notebook the answer is 527 but in Excel this equation gives the answer as 1122Journey to Passwordless Authentication Might Include Some Bumps
Microsoft recommends passwordless authentication to help secure Microsoft 365 tenants. The latest is synced passkeys, something that apparently leads to “syncability,” whatever that might mean. In any case, after some struggles, I managed to enable synched passkeys for my iPhone and then started to consider how to remediate user accounts that are flagged with a high-risk (compromised) status when they can’t simply update their password. https://office365itpros.com/2025/12/04/passwordless-authentication/
How do I reference query data from an Access Macro
I have a simple Select query that returns a number of records. In my Access macro (just for clarification, I do mean Access Macro and not VBA) I want to check how many records the query returns in an IF statement. In this specific case the check would be on zero returned records, but being able to check non-zero in the future might be useful. I have tried various internet searches but the only results I found relate to VBA. Suggestions on how to do this check would be appreciated. Thank You
Index and Match command is return results from the wrong column
Within Excel I'm using the Index and Match command to search an array. I've provided copy of the workbook. Here is the command =IFERROR(INDEX(D7:H11,MATCH($D$13,L7:L11,0),MATCH($E$13,M7:M11,0)),"") Here is an added twist on sheet 1 I use this formula and it works correctly. This formula is on sheet 2. The results for the Average column returns correctly. The other columns appear as if the were flipped. When the Marginal column is selected I get results from the Above Avg column. The opposite happens if I choose the Above Avg column I get the Marginal results. The same thing happens if I choose the columns on the ends. As shown in the image above the Extreme row is selected and the One column is chosen. The result should be "Caution", but instead the result is "None6". FYI, this is part of larger workbook where the results will be posted on a different worksheet, but to simplify everything I've placed it on its own page. Regards
"Unknown" Spill Range when it is very much known
I am trying to filter a list. Currently the formula looks like this: =FILTER(BS1#;DZ1#;"empty") BS1# is simply a list of things with several attributes, the very first column being a boolean on whether to include the row. DZ1# is simply the first column of BS1#. Both are always the same dimensions and never throw out any errors, however the above FILTER randomly gives a #SPILL error, always saying it does not know how large the spill area is. There is no pattern to when this error is given. While BS1# has a lot of OFFSETs in it and a previous version of that did show the same random error behavior. I fixed that one and it is now always the same size. I have no idea why the FILTER is doing this. In cases where it does show an error and I go into the cell, mark the entire formula and mouse over, it does not give the error and instead gives the array in text as though there is no error!! I am running the 64bit version and my RAM is at 30% usage, but EXCEL is only at 382 MB, far less than Google Chrome.
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!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.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/2025
Recent Blogs
- The 2025 Microsoft Excel World Championship and Collegiate Challenge wrapped up their season in spectacular fashion at Las Vegas’ HyperX Arena, drawing competitors from nearly every continent and cro...Dec 04, 2025
- With version history in Copilot Pages, you can now explore and revert to earlier versions of your work.Dec 03, 2025
