Recent Discussions
Need help with conditional fomatting formula based in text on cells
Hi everyone, I have a list of owners' names in column C. C2 contains 1+1 CAR CORPORATION C3 contains 8-J ENTERPRISES, LLC C4 contains LOYD RENTALS LLC C5 contains SMITH PAUL & PAULA C6 contains DOE JHON & JANE C7 contains MENENDEZ JAMES C8 contains BROWN INVESTMENTS, INC. And so on I'd like to highlight the whole row for the cells that have CORPORATION, LLC, INC, ENTERPRISES in their names. Hope this makes sense and someone can help me. Thank you.
Trying to insert Pivot Table
I recorded a new macro, using the tab View Macros-Record Macro, which resulted in the following VBA code: Sub CreatePivotTable() Sheets("Year Data").Select Range("A3:F24").Select ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _ "Year Data!R3C1:R24C6", Version:=xlPivotTableVersion14).CreatePivotTable _ TableDestination:="Yearly Summary!R3C1", TableName:="PivotTable3", _ DefaultVersion:=xlPivotTableVersion14 Sheets("Yearly Summary").Select Cells(3, 1).Select End Sub The recording did exactly as I wanted, taking the data from the "Year Data" WS and adding the new pivot table to the "Yearly Summary" WS. As a test of the macro, I deleted the initial pivot table that was created on the "Yearly Summary" WS. The problem I have now, when I attempt to run this macro again it constantly fails on the 4th line of the macro with Run-time error '5': Invalid procedure call or argument. ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _ "Year Data!R3C1:R24C6", Version:=xlPivotTableVersion14).CreatePivotTable _ TableDestination:="Yearly Summary!R3C1", TableName:="PivotTable3", _ DefaultVersion:=xlPivotTableVersion14 I cannot figure out why it works when I am recording the macro but fails when I try to run it alone. Help is greatly appreciated.
formula Excel help
In tab 1, I have three columns on row 2 F, G and H (representing first name, second name and family name) In tab 2, I want to import column F, G and H combined in one single cell. I have tried =IF(Import!F2="";"";Import!F2)+IF(Import!G2="";"";Import!G2)+IF(Import!H2="";"";Import!H2) but result wrong #VALUE! What is the correct formula ?
How to add a new field to existing XML Mapping
Hi, everyone! Good day! I've made an XML file which I imported to my doc using XML Mapping Pane -> (Add new part...) and I used it to map some texts. How could I add new fields to this XML Mapping? What I tried: I tried editing the XML file and then importing it again. As a result, I have two XML Mappings with the same name that act as completely separate mappings. I couldn't even find a way to delete the older one.
#Name? error in a formula adjusted for circular reference
How can I solve #Name? error in formula: =H2+(I2*Parameters_2026!$G$1)+(I2*Parameters_2026!$G$3)+(I2*Parameters_2026!$G$5)+((I2-I2*Parameters_2026!$G$1-I2*Parameters_2026!$G$3)*İNDEX(Parameters_2026!$C$3:$C$7;MATCH(MAX(I2;1);Parameters_2026!$A$3:$A$7;1))). Where: H2 → Net Salary I2 → Gross Salary (to be calculated iteratively) Parameters_2026!$G$1 → Employee Social Insurance Rate (0,14 of Gross Salary) Parameters_2026!$G$3 → Employee Unemployment Insurance Rate (0,01 of Gross Salary) Parameters_2026!$G$5 → Stamp Tax Rate (0,00759 of Gross Salary) INDEX + MATCH → Finds income tax rate (range C3:C7) applicable for Gross Salary amount (A3:A7 range) Iterative calculation enabled for Maximum Iterations: 1000 and Maximum Change: 0.000001. Thank you in advance
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
"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/
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
