Recent Discussions
Mail Merge Dates Issue
I have an Excel Sheet that includes dates. I have created a Word Mail Merge Document that includes the merging of dates and other information from the Excel Sheet. In the merge, all data other than the dates are merging correctly. The dates are merging in as numbers, regardless of switches. I do not understand why I am having so many problems with this date issue. The date clearly shows as a date in Excel yet its merging in as numbers. No matter what I try, I cannot get the Date to merge in as the Date shown in Excel. How can I make this work. Carl
Multiple filter in a pivot table to show the best "x" values using slicers
I have a pivot table with the following fields Row Fields Level 1 Level 2 Empl code Empl name Value Field Ranking By slicers, I make filters for the fields Level 1 and Level 2. I need to get the best x (e.g. the top 10) from the filtered lists based on the value of the Ranking field. don't know if it can be done with slicer, although it would also be useful to group the ranking by brackets (for example 1-10, 11-20....) and create a slicer with these brackets to filter the list. Thnks in advance.
Why does Excel STILL automatically remove zeroes at the start of numbers I export into the program?
Seriously, who designed this godawful application? It's needlessly "helpful", just auto-formatting all my information into whatever dumb setting it wants. I have to export 500 barcodes into a sheet and organize them but of course Excel HAS to jump in and remove ALLLLLLLLL the zeroes at the start so I need to waste my time going in and formatting all the cells to "text" (otherwise they'll just keep "helpfully" re-formatting all my data without asking me). Oh man, and don't even get me started on trying to type the number "102320241016" into a cell. For some reason Excel decided that should be a scientific notation and constantly changes it to "1.0232E+11". Honestly why is this a feature? Who thought that we'd all want this? Why is EVERY Microsoft product I am forced to use for job so excessively anti-user? Between excel, teams, and outlook like an hour of my day ends up being spent trying to parse my way through these bloated, poorly running applications. It's like they're all designed to try and help but the way they "help" is by being as annoying and in the way as possible which just ends up slowing down everyone who actually knows what they're doing.
Sharepoint Hyperlink not Dynamic
Recently a bunch of items were moved from a drive to Sharepoint and I am trying to update my dynamic hyperlinks. Every month there is a checklist of tasks that need to be accomplished and I have Hyperlink formulas to click on and go to the current month-year folder. I setup my formula using the "December 2024" folder as my basis and the formula sent me there. Perfect! Then I changed the MONTH_YEAR cell to "December 2023". The only difference between the file paths when copied and pasted from the address bar is 2023 versus 2024. When I clicked on the updated link it sent me right back to the 2024 folder. Does anyone know why the link isn't changing when I change the parameters? =IFERROR(HYPERLINK(CONCAT(http_to_Master_Folder, "%2F%5F%5FCharacter%2FCY", RIGHT(MONTH_YEAR,4), "%2FNotes&viewid=x00000f2%2X0x0x%2XD0xxx%0Xx00x%0X0000x000xx00"), CONCAT("Game > Campaign > Player > Character > CY", RIGHT(MONTH_YEAR,4), " > Notes")), CONCAT("Game > Campaign > Player > Character > CY", RIGHT(MONTH_YEAR,4), "> Notes")) Thank you
Can't apply font from table style to table
I've set up a table styles, but when I apply it to a table, the font characteristics (for example, white color in the header row) aren't applied. This seems to be because the rows in the table have the Normal paragraph style applied to them. How to I remove paragraph styles from a table, so that the text styles used are those defined in the table style?
Excel graphing help to show grouped data
Hi there, I would like to make a stacked bar chart to display this data but I would like, for example, the Kimberley 2020 information to be on top of the Kimberley 2015 information, the Cranbrook 2020 information to be on top of the Cranbrook 2015 information, etc. Can you please advise me how to do that? Thanks!
** Help ** Need to filter same result but in different formulas dependent on Quarter
Hi HansVogelaar I need help modify my formula/logic (request below) Formula 1 =TEXTJOIN("; ", TRUE, FILTER( Catalogue!$B$3:$B$987 & IF((Catalogue!$L$3:$L$987 = E$1 & "+"), "Q1'25+", "") & IF(Concat!$B$1 = "XXX Group", IF(TRUE, IF(Catalogue!$M$3:$M$987 = "Y", " UK", "") & IF(Catalogue!$O$3:$O$987 = "Y", " IT", "") & IF(Catalogue!$Q$3:$Q$987 = "Y", " DE", ""), ""), ""), (Catalogue!$A$3:$A$987 = $D$1) * (Catalogue!$C$3:$C$987 = $D2) * IF(Concat!$B$2 = "POR", (Catalogue!$F$3:$F$987 = "POR"), IF(Concat!$B$2 = "POI", (Catalogue!$F$3:$F$987 = "POI"), IF(Concat!$B$2 = "Both", (Catalogue!$F$3:$F$987 = "POR") + (Catalogue!$F$3:$F$987 = "Both"), TRUE))) * IF(Concat!$B$1 = "Superset", ((Catalogue!$J$3:$J$987 = E$1) + (Catalogue!$J$3:$J$987 = E$1 & "+")) * (Catalogue!$I$3:$I$987 = "Y"), IF(Concat!$B$1 = "XXX Group", ((Catalogue!$L$3:$L$987 = E$1) + (Catalogue!$L$3:$L$987 = E$1 & "+")) * (Catalogue!$K$3:$K$987 = "Y"), IF(Concat!$B$1 = "XXX UK & ROI", ((Catalogue!$N$3:$N$987 = E$1) + (Catalogue!$N$3:$N$987 = E$1 & "+")) * (Catalogue!$M$3:$M$987 = "Y"), IF(Concat!$B$1 = "XXX IT", ((Catalogue!$P$3:$P$987 = E$1) + (Catalogue!$P$3:$P$987 = E$1 & "+")) * (Catalogue!$O$3:$O$987 = "Y"), IF(Concat!$B$1 = "XXX DACH", ((Catalogue!$R$3:$R$987 = E$1) + (Catalogue!$R$3:$R$987 = E$1 & "+")) * (Catalogue!$Q$3:$Q$987 = "Y"), IF(Concat!$B$1 = "XXX CHOPS", ((Catalogue!$T$3:$T$987 = E$1) + (Catalogue!$T$3:$T$987 = E$1 & "+")) * (Catalogue!$S$3:$S$987 = "Y"), IF(Concat!$B$1 = "Omux", ((Catalogue!$V$3:$V$987 = E$1) + (Catalogue!$V$3:$V$987 = E$1 & "+")) * (Catalogue!$U$3:$U$987 = "Y"), IF(Concat!$B$1 = "Letxof", ((Catalogue!$X$3:$X$987 = E$1) + (Catalogue!$X$3:$X$987 = E$1 & "+")) * (Catalogue!$W$3:$W$987 = "Y"), IF(Concat!$B$1 = "DT", ((Catalogue!$Z$3:$Z$987 = E$1) + (Catalogue!$Z$3:$Z$987 = E$1 & "+")) * (Catalogue!$Y$3:$Y$987 = "Y"), FALSE)))))))) * TRUE ), "None") ) Request There are two things that I'm expecting to see return 1.) B243 = Test - do not remove M243 = Y (UK) N243 = Q1'25 O243 = Y (IT) P243 = Q2'25 Id expect to see returned in formula 1 (E2) "Test - do not remove UK" as this formula is looking for Q1'25 values in formula 2 (F2) id expect to see "Test - do not remove IT" as this is looking for Q2'25 values 2.) B306 = Migrate Verdi & Beethoven O306 = Y (IT) P306 = Q2'25 Q306 = Y (DE) R306 = Q1'25 Id expect to see Migrate Verdi & Beethoven DE in formula 1 as this is a Q1'25 value and id expect to see Migrate Verdi & Beethoven IT in returned in formula 2 as this is a Q2'25 value This logic should only apply when B3 = XXX Group on "Concat Tab" Formula Tab - so essentially instead of seeing Test - Do not remove UK IT in E2 Id like to see Test- Do not remove UK as it in Q1'25 for UK and then id expect to see in F2 "Test - Do not remove IT" as its in Q2'25 for IT and the same for E6 I expect to see "Migrate Verdi & Beethoven DE" as its in Q1'25 and Migrate Verdi & Beethoven IT in F6 as its in Q2'25 Catalogue Tab Catalogue TabThwarting Social Engineering Attacks Against Teams Federated Chat
A recent reported noted an increase in social engineering attack through Teams federated chat. You can stop these attacks by limiting external access to an allow list of known domains, which is what I do. Or you can depend on the technology built into Teams to detect suspicious connections and remind users about potential risk. This now extends to connections from brands commonly targeted by phishers. https://office365itpros.com/2024/12/06/federated-chat-brand-impersonation/
Protected sheet - how to edit text in unlocked cells
I have an excel spreadsheet with a protected sheet. There are certain unlocked cells that allow for data input. My issue, is around updating data in the unlocked cells. Once data has been input into the cell, if I double click on the cell again to edit the text, all the text disappears. This only occurs on a protected sheet, so seems to be a 'feature' or limitation of a protected sheet. Is there a way to stop the text disappearing? I just want to be able to double click in the cell and edit the text without it disappearing on me. I'm avoiding using macros/VBA as I don't want a macro-enabled workbook as I need to email this document to external customers and don't want the file to be blocked by their mail servers.Mutiplying values based on criteria
Hi all, appreciate some help. I'm trying to get excel to multiply values in column M with column G based on criterias in column E and F. For example, If item type is 20DV and category is Y, then mutiply value in column M with 2. If item type is 40ST and category is Y, then multiply value in column M with 4Add cells together using multiple criteria
Hi. In one cell on sheet 2, I want to add together cells from sheet 1 that have the same value under the column N/C. I know basic excel formulas but think this one needs a few "rules" to be able to give it the correct instruction. I need it to update automatically for future when a N/C is entered under supplier K for example. Thanks.Outlook calendar on mac not showing up
I'm using a Mac (macOS Big Sur version 11.0.1) and using Microsoft Office 365 (Microsoft Outlook for Mac version 16.43). Email is working (and syncing) fine to my Yahoo and Gmail accounts. However, recently I have lost the function of the Calendar. It is essentially blank. I've tried reinstalling Outlook which did not change anything. Any ideas?
Xlookup using multiple criteria and itself
Hello, I am trying to automate a process of looking up values from two other sheets and I can't seem to get the last part down. I have the working sheet and I am looking to match the Line Item from Sheet A and Sheet C. The criteria is: the line item must be between 50 and 100, and the department/line combo must be the same for Sheet A and Sheet C. Looking at the Results Wanted, department 55678 has a line item 60 in both sheets. Department 999000 has line item 60 in Sheet A, but not in Sheet C, but it does have both for line item 100 and 100 is returned. Which number it returns doesn't matter, so long as it matches. My formula so far is =xlookup(1,(SheetADepartment Colum = Working Sheet Department)*(SheetALineItem Colum>=50)*(SheetALineItem Colum<=100),SheetALineItem Colum) This formula is working, but I can't figure out how to also return something that is matching from Sheet C. Thank you for the help!
My first Add-In
Hello everyone, I’m working on developing my first Add-In for Outlook 365. In theory, it’s quite simple—it’s a drop-down menu with two options. Each option opens a new email and loads a different template, depending on the selection. So far, the menu is functioning smoothly. Selecting option A displays the corresponding template, and the same goes for option B. However, I’m facing a problem: I can’t get the user’s signature to load automatically as expected, even though the signature is properly configured and set as the default for new emails. I’ve attached part of mymanifest.xml and command.ts files for you to review. If you could provide some guidance on how to resolve this issue, I’d greatly appreciate it. Thank you so much for your support! manifest.xml <Requirements> <Sets> <Set Name="Mailbox" MinVersion="1.5"/> </Sets> </Requirements> <FormSettings> <Form xsi:type="ItemRead"> <DesktopSettings> <SourceLocation DefaultValue="https://localhost:3000/taskpane.html"/> <RequestedHeight>250</RequestedHeight> </DesktopSettings> </Form> </FormSettings> <Permissions>ReadWriteItem</Permissions> <Rule xsi:type="RuleCollection" Mode="Or"> <Rule xsi:type="ItemIs" ItemType="Message" FormType="Read"/> <Rule xsi:type="ItemIs" ItemType="Message" FormType="Edit"/> </Rule> <DisableEntityHighlighting>false</DisableEntityHighlighting> <VersionOverrides xmlns="http://schemas.microsoft.com/office/mailappversionoverrides" xsi:type="VersionOverridesV1_0"> <Requirements> <bt:Sets DefaultMinVersion="1.5"> <bt:Set Name="Mailbox"/> </bt:Sets> </Requirements> <Hosts> <Host xsi:type="MailHost"> <DesktopFormFactor> <FunctionFile resid="Commands.Url"/> <ExtensionPoint xsi:type="MessageReadCommandSurface"> <OfficeTab id="TabDefault"> <Group id="msgReadGroup"> <Label resid="GroupLabel"/> <!-- Menú desplegable para las opciones --> <Control xsi:type="Menu" id="DropdownMenu"> <Label resid="DropdownMenu.Label"/> <Supertip> <Title resid="DropdownMenu.Label"/> <Description resid="DropdownMenu.Tooltip"/> </Supertip> <Icon> <bt:Image size="16" resid="MenuIcon.16x16"/> <bt:Image size="32" resid="MenuIcon.32x32"/> <bt:Image size="80" resid="MenuIcon.80x80"/> </Icon> <Items> <Item id="InternalAction"> <Label resid="InternalAction.Label"/> <Supertip> <Title resid="InternalAction.Label"/> <Description resid="InternalAction.Tooltip"/> </Supertip> <!-- Imagen para la opción Internal --> <Icon> <bt:Image size="16" resid="InternalIcon.16x16"/> <bt:Image size="32" resid="InternalIcon.32x32"/> <bt:Image size="80" resid="InternalIcon.80x80"/> </Icon> <Action xsi:type="ExecuteFunction"> <FunctionName>handleInternalAction</FunctionName> </Action> </Item> <Item id="ExternalAction"> <Label resid="ExternalAction.Label"/> <Supertip> <Title resid="ExternalAction.Label"/> <Description resid="ExternalAction.Tooltip"/> </Supertip> <!-- Imagen para la opción External --> <Icon> <bt:Image size="16" resid="ExternalIcon.16x16"/> <bt:Image size="32" resid="ExternalIcon.32x32"/> <bt:Image size="80" resid="ExternalIcon.80x80"/> </Icon> <Action xsi:type="ExecuteFunction"> <FunctionName>handleExternalAction</FunctionName> </Action> </Item> </Items> </Control> </Group> </OfficeTab> </ExtensionPoint> </DesktopFormFactor> </Host> </Hosts> <Resources> <bt:Images> <!-- Iconos del menú --> <bt:Image id="MenuIcon.16x16" DefaultValue="https://localhost:3000/assets/menu-icon-16.png"/> <bt:Image id="MenuIcon.32x32" DefaultValue="https://localhost:3000/assets/menu-icon-32.png"/> <bt:Image id="MenuIcon.80x80" DefaultValue="https://localhost:3000/assets/menu-icon-80.png"/> <!-- Iconos para la opción Internal --> <bt:Image id="InternalIcon.16x16" DefaultValue="https://localhost:3000/assets/int-16.png"/> <bt:Image id="InternalIcon.32x32" DefaultValue="https://localhost:3000/assets/int-32.png"/> <bt:Image id="InternalIcon.80x80" DefaultValue="https://localhost:3000/assets/int-80.png"/> <!-- Iconos para la opción External --> <bt:Image id="ExternalIcon.16x16" DefaultValue="https://localhost:3000/assets/ext-16.png"/> <bt:Image id="ExternalIcon.32x32" DefaultValue="https://localhost:3000/assets/ext-32.png"/> <bt:Image id="ExternalIcon.80x80" DefaultValue="https://localhost:3000/assets/ext-80.png"/> </bt:Images> <bt:Urls> <bt:Url id="Commands.Url" DefaultValue="https://localhost:3000/commands.html"/> <bt:Url id="Taskpane.Url" DefaultValue="https://localhost:3000/taskpane.html"/> <bt:Url id="CommandsJs.Url" DefaultValue="https://localhost:3000/commands/commands.js"/> </bt:Urls> <bt:ShortStrings> <!-- Nombre del grupo --> <bt:String id="GroupLabel" DefaultValue="New Client/Matter"/> <!-- Etiqueta para el menú desplegable --> <bt:String id="DropdownMenu.Label" DefaultValue="Choose Action"/> <!-- Etiqueta para la opción Internal --> <bt:String id="InternalAction.Label" DefaultValue="Internal"/> <!-- Etiqueta para la opción External --> <bt:String id="ExternalAction.Label" DefaultValue="External"/> </bt:ShortStrings> <bt:LongStrings> <!-- Tooltip para el menú --> <bt:String id="DropdownMenu.Tooltip" DefaultValue="Select an action to perform."/> <!-- Tooltip para la opción Internal --> <bt:String id="InternalAction.Tooltip" DefaultValue="Opens an internal email template."/> <!-- Tooltip para la opción External --> <bt:String id="ExternalAction.Tooltip" DefaultValue="Opens an external email template."/> </bt:LongStrings> </Resources> </VersionOverrides> </OfficeApp> command.ts /* global Office */ Office.onReady(function (info) { if (info.host === Office.HostType.Outlook) { Office.actions.associate("handleInternalAction", handleInternalAction); Office.actions.associate("handleExternalAction", handleExternalAction); } }); /** * Handles the "Internal" action. * param event The Office Add-in event. */ function handleInternalAction(event) { console.log("Handling internal action..."); openEmailTemplate("internal"); event.completed(); } /** * Handles the "External" action. * param event The Office Add-in event. */ function handleExternalAction(event) { console.log("Handling external action..."); openEmailTemplate("external"); event.completed(); } /** * Opens an email template with the user's signature. * param templateType The type of template ("internal" or "external"). */ function openEmailTemplate(templateType) { var templateBody = templateType === "internal" ? "This is the internal email template." : "This is the external email template."; var subject = templateType === "internal" ? "Internal Client/Matter" : "External Client/Matter"; console.log("Opening email template..."); // Open a new email draft Office.context.mailbox.displayNewMessageForm({ subject: subject, htmlBody: templateBody, }); // Insert the user's signature after the draft is created Office.context.mailbox.item.body.getAsync(Office.CoercionType.Html, function (result) { console.log("Attempting to get user's signature..."); if (result.status === Office.AsyncResultStatus.Succeeded) { var userSignature = result.value || ""; console.log("User's signature retrieved: ", userSignature); // Combine the template body with the user's signature var combinedBody = templateBody + "<br/><br/>" + userSignature; console.log("Updating email body with template and signature..."); // Update the email body with the template and the user's signature Office.context.mailbox.item.body.setAsync(combinedBody, { coercionType: Office.CoercionType.Html, asyncContext: { value: "setBody" }, // Optional: track async operation }); } else { console.error("Failed to get user's signature:", result.error); } }); } //# sourceMappingURL=commands.js.map
Recent Blogs
- Not long after we announced a preview of Focus Cell in the Microsoft Insider's Blog had we received positive feedback about this feature. Now, we are happy to announce that Focus Cell is now generall...Dec 07, 2024
- The Cloud Policy service and cloud update are features in the Microsoft 365 Apps admin center designed to keep your devices managed and up to date. As keeping the Microsoft 365 Apps current and confi...Dec 05, 2024
