Recent Discussions
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 do I correct heading numbering?
UPDATE: I couldn't remove this post, after I discovered the issue. Thanks! I need to update heading numbering within an old document. Custom headings were made (as pictured) but I need the heading levels 2 and 3 to include the parent heading number of each. When I attempt to update the level 2 heading for Section 2, it wants to continue with Section 1 (see pictured example). In the number format, I do not know how to tell Word to include the parent numbers? I included "1." thinking it was intelligent enough to know that was just a format designation of the parent heading, but I guess that isn't how. I realize I may be making some glaring mistakes, but just trying to get it right. So this is a learning moment. The caveat here is that I'm not creating the heading from scratch but rather, trying to update the existing document headings. I did follow some online suggestions but none of them addressed including the parent value in this scenario. Section 2 <Heading Level 1 text format> <-- Here I need the word "Section" to proceed the level 1 heading number 2.1 <Heading Level 2> <-- Here I need the level 2 heading to include the parent section level number 2.1.1 <Heading Level 3> <-- Here I need the level 3 heading to include level 1 and 2 numbers.
Word: Performance and functionality concerns
Hi! Is this happening to you, too? I work on a team that has incorporated co-authoring in a way that it has become an instrumental part of our workflow and processes. We are the only team in our organization to have significant issues with Word: Comments are ghost multiplying (from under 50 to over 4,000) Mark-up is inconsistently available Changes are not always saving for various contributors Formatting, especially custom table styles, are auto-reformatting to something illegiable Important documents are slow to load, if they do Real-time editing is, on occasion, impossible . . . and more. I researched and found some insights. I can't find anything "out there" that would suggest others are experiencing these types of roadblocks. Are you? I am sorry if you are, but I'd be happy to know we're not alone. Do you have any tips or things you've done to improve your experience? Some context: We actively and regularly contribute to documents asynchronously (large and small), apply custom branding styles, comment (and @ team members in comments), share links in team chats, channels, and provide access to others through Outlook links. The majority of the team uses PC, but likely accesses and edits files through chats, channels, emails, Teams, Online, and OneDrive. We also have one Mac, which handles the heavy load for branding and formatting as well. I appreciate any perspectives! Thank you.
Linking a cell from a OneDrive excel sheet to another OneDrive excel sheet in different workbooks
Hi, I'm trying to make a cell in sheet A of workbook 1 display the cell from sheet X in workbook 2. Both workbooks are in the same parent folder with different sub folders. I want all this to be done with OneDrive apps, not desktop app. Any help would be greatly appreciated! Thanks
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, Anupam
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!Word.FieldType.ref support on Word Online
I have an issue in a Word Add-in on Word Online where I'm trying to insert a reference field in insertField method of Range. I have the same function on Word on Windows, Mac, and Onlineso I need the same result on each environment. insertField(Word.InsertLocation.end, Word.FieldType.ref, `${bookmarkName} \\w \\h \\t`, true); I know that Word.FieldType.ref is not supported on Word on Web, but I wanted to ask if there's any ETA on when it will be available or if there's any workaround to achieve the same result as in Desktop?Excel specific text search in one cell
Hello Excel Profs, i am searching for a way how to search in an excel sheet for a specific text AND mark/highlight this part. With the normal search function the cell is selected but not the specific text. Tried several functions (vlookup, xlookup, hlookup, match, xmatch, conditional fomat etc) but unfortunately without the succes. Can somebody help me with this? many thanks in advanceHow 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
Mail Merge malfunction
Using Word Mail Merge for Envelopes for UK/EU/World addresses with some Fields having blank entries. Address format is as this: «Title» «First_Name» «Last_Name» «Suffix» «Home_Address_Street» «StreetSecond» «Home_Address_City» «Home_Address_Postal_Code» «Home_Address_County» «Home_Address_CountryRegion» «Next Record» When I Preview all the addresses in the Recipients List they are there BUT when I go to Finish & Merge to a new document for Edit Review suddenly addresses are being skipped -randomly? Can anyone offer any clues or suggestions on how to overcome this please. I had tried to set a Rule to avoid CountryRegion printing the home UK line but it failed to function. Instead I deleted all the UK country linesFormula help
I have the following formula that partially works. It processes this formula and returns the 1st match based on the formula criteria. =IFERROR( LET( KeyTypes,FILTER('Key Log'!$F$4:$F$309,(TRIM('Key Log'!$A$4:$A$309)=TRIM($D$6))*(TRIM('Key Log'!$C$4:$C$309)=TRIM($K$15))), KeyNums,FILTER('Key Log'!$K$4:$K$309,(TRIM('Key Log'!$A$4:$A$309)=TRIM($D$6))*(TRIM('Key Log'!$C$4:$C$309)=TRIM($K$15))), IF(INDEX(KeyTypes,ROW(A1))="Hard Key","V"&INDEX(KeyNums,ROW(A1)),INDEX(KeyNums,ROW(A1))) ),"") This formula resides in cells A8:A18 which is designed to return a key number, whether the key be a swipe key or a hard key. Cells B8:B18 are for descriptions of the key identified in cells A8:A18. This formula is supposed to find the 1st match on the key log and then find any other matches and place them in cells A8:A18. There is another formula for defining the description based on criteria. I need this formula to search out all transactions on the key log that match the ID number on the Key Issue Form in cell D6 with the cells in column A on the ID number and to also match the room number from K15 on the Key Issue Form with the room number in column C on the key log. There is something missing from this formula that is not allowing the other transactions to be found and listed on the Key Issue Form. Can anyone help me complete this formula? This is the formula for B8:B18 =IF(A8="","", LET( FilteredRows,FILTER(SEQUENCE(ROWS('Key Log'!$A$4:$A$309)),('Key Log'!$A$4:$A$309=$D$6)*('Key Log'!$C$4:$C$309=$K$15)), RowNum,INDEX(FilteredRows,ROW(A1)), Room,INDEX('Key Log'!$C$4:$C$309,RowNum), Status,INDEX('Key Log'!$E$4:$E$309,RowNum), Type,INDEX('Key Log'!$F$4:$F$309,RowNum), DateVal,INDEX('Key Log'!$D$4:$D$309,RowNum), IsAB,OR(RIGHT(Room,1)="A",RIGHT(Room,1)="B"), DoorDesc,IF(IsAB,"Combined Main & Room Door","Main Door"), KeyDesc,IF(Type="Swipe Key","Swipe Key","Hard Key"), DoorDesc & " " Can someone help me figure this out? CarlImages not showing in microsoft forms
Hi, Please can someone help. We are trying to deploy Teams with our school to enable remote learning. We have been setting quizzes to assess understanding using Forms. However, we are getting widely reported issues of images not displaying when added to a question. Retrying in Edge, Chrome may or may not fix the issue. I have refreshed or followed the links several times myself and sometimes they appear, sometimes they do not. We just get the eternal load or the broken image link. Is there anything we can do, is it certain types of pictures etc? We have tried uploading from our PC, using built in search. Its a real flaw at the moment because students quickly switch off when something is unreliable. It makes no difference if I open via teams in browser, desktop or online. Thank youhelp with formula & functions (no Macros & VBA)
Hey all, I've created a sheet that has the following columns: (A) dates, (B) names, (C) phone numbers, (D) free text & (E) Status (done or closed). The first row (frozen) contains the title of each column. I've opened another sheet (same file) and called it 'Dashboard" . I am looking to create some sort of index where I can type in (search really) for a phone number and it will return the entire rows back with all the information. Same goes to searching for a name and return the entire relevant rows (with the phone number, dates and etc). I've been trying to look for an answer online, and also tried by myself for 2 months .. and for the life of me, came back nothing but frustration. Important to mention that I can't use macros & VBA as my workplace won't allow it due to policy issues. Needless to say, the information is sensitive. Any ideas on how to do it and tackle it in the best way possible? Big thank you in advance!
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
