Recent Discussions
Stock quotes from Refinitiv stopped working, any alternatives?
Hi, I've noticed that after March 3rd update to 16.95 on Mac my stock quotes from Refinitiv stopped working. There is no "stock" data type in the ribbon. Same thing with online app. Did you notice this? Are there any alternatives for stock quotes to this data type that gets data from Refinitiv42Views0likes1CommentI need help with transforming data
I have been trying to move my data automatically instead of copy paste cells one by one, but because my data has lots of info, I'm failing in doing so. I added a picture, I only made 6 for the example but I have over 50 agents. I want this data to go automatically in the other format from the picture. So this other format of the table should show how many hours each of them has worked each day. As you can see I need to move the data from the first picture (different table formatting) to the other one. I have over 50 agents, and their time worked is put one by one based on the date. Now on the second one (the one I need to be filled automatically), the table is set on the way where I put the hours worked by agent, one by one for one month. How do I transform my data into that? What's the best formula to use? Please help!15Views0likes1CommentPower Query Dropping Decimals with Accounting Format
I'm encountering what seems like a bug in Power Query. I have a table with data that contains numbers with more than 4 decimal places. When this data is in the Accounting format, Power Query is only picking up 4 decimal places, even if the Query is formatting the data is Decimal Number (Changed Type). When the data is formatted as Number, Power Query is able to pick up all decimal places (Some numbers have 10+ decimals) Is this normal behavior? I would like to use the Accounting format because it looks cleaner, but obviously I cannot sacrifice data accuracy. It is also very illogical to have a format labeled "Accounting" only hold 4 decimal places when passed through Power Query I did try restarting Excel multiple times, refreshing queries, the only thing that resolved it was changing the local format to Number.75Views0likes6CommentsSUMPRODUCT() Formula Query
Hello, I'm facing issue while using SUMPRODUCT(). I have 2 different table (TableX and TableY). TableX = Contains Department, Candidates and Joining Date TableY = Department, Candidates and New Column under which I want to populate the count Candidates who will join in specific month. Below formula is not working. Can someone please help on this ? =SUMPRODUCT((TableX[Department ID])=A2)*MONTH((TableX[Joining Date])=6) Table1: Table2:36Views0likes2CommentsEmail uol imap doesn't work with New Outlook
I am trying to add my email uol Imap to the New Outlook. I follow the process to introduce a new account, it run for 4 minutes (message "Aguardando seu provedor de email" and does not complete the configuration. I have tried to speak with Microsoft Chat Support and they recommended me to report the problem here, because this is a complain without solution till the moment.21Views0likes1CommentExcel in OneDrive and on Mac.
Hi everyone, I am working in Excel on a Mac and I cannot add a logo in the header, or type in the footer. all of the ribbon is greyed out so I can't select insert date. I have checked on Microsoft 365 updates are automatic. I have put the spreadsheet in page layout view. I have checked the margins. I have downloaded both documents one contains the logo picture, and the spreadsheet, but still unable to click on the image to paste it in the header. I have checked help function, and worked on it for several hours, but still unable to use it. Cheryl.17Views0likes1CommentHow to Report the Sponsors for Entra ID Guest Accounts
Entra ID populates the sponsor property for new guest accounts with details of the person who invites the guest to the tenant. It’s data that can be used for different purposes, such as having someone to justify the continued presence of a guest account in a Microsoft 365 tenant. This article explains how to report guest accounts and their sponsors with some straightforward PowerShell. https://office365itpros.com/2025/04/18/guest-accounts-sponsors/3Views0likes0CommentsHow to unprotect Excel sheet if forgot the password
I recently encountered a problem and hope to get your help. I set a protection password for an Excel file before. Now I want to modify some data, but I found that I forgot Excel password. I wonder if there is any way to remove the protection or unprotect Excel sheet password? If anyone knows a related solution or has had a similar experience, please share it, thank you very much! This file is very important to me, and there is a lot of work data in it. I have tried some methods found on the Internet, but none of them worked. It would be great if someone could provide some specific steps or recommend some tools.700KViews0likes62CommentsIFS with VLOOKUP help
IF(OR(IFERROR(IFS(AND(F3=VLOOKUP(F3,'Dropdown list'!N2),F4=VLOOKUP(F4,'Dropdown list'!N2)),"yes",AND(F3=VLOOKUP(F3,'Dropdown list'!O2:O3,1),F4=VLOOKUP(F4,'Dropdown list'!O2:O3,1)),"yes",AND(F3=VLOOKUP(F3,'Dropdown list'!P2:P4,1),F4=VLOOKUP(F4,'Dropdown list'!P2:P4,1)),"yes",AND(F3=VLOOKUP(F3,'Dropdown list'!Q2:Q4,1),F4=VLOOKUP(F4,'Dropdown list'!Q2:Q4,1)),"yes"),"no")="yes",IFERROR(IF(AND(F3=VLOOKUP(F3,'Dropdown list'!R2),F4=VLOOKUP(F4,'Dropdown list'!R2)),"yes"),"no")="yes"),"yes","no") If 1st value is in column N and 2nd value is in column N, then return "yes" if not then return "no". This is how I would like this to work. Thoughts?95Views0likes3CommentsFilter Courses with multiple dates - 30/60/90 help!
I have a table with students that attend multiple courses. The courses expires one year from the completion date. I need to know which students have a course expiring in the next 30 60 and 90 days so they can recertify. I would like to have two sheets one with the data in a table and another showing ONLY students with the courses they need to re-certify in.48Views0likes2CommentsIFS with VLOOKUP not functioning
IF(OR(IFERROR(IFS(AND(O3=VLOOKUP(O3,'Dropdown list'!BT2:BT3,1),O4=VLOOKUP(O4,'Dropdown list'!BT2:BT3,1)),"yes",AND(O3=VLOOKUP(O3,'Dropdown list'!BU2:BU4,1),O4=VLOOKUP(O4,'Dropdown list'!BU2:BU4,1)),"yes",AND(O3=VLOOKUP(O3,'Dropdown list'!BV2:BV4,1),O4=VLOOKUP(O4,'Dropdown list'!BV2:BV4,1)),"yes",AND(O3=VLOOKUP(O3,'Dropdown list'!BW2:BW4,1),O4=VLOOKUP(O4,'Dropdown list'!BW2:BW4,1)),"yes",AND(O3=VLOOKUP(O3,'Dropdown list'!BX2:BX4,1),O4=VLOOKUP(O4,'Dropdown list'!BX2:BX4,1)),"yes",AND(O3=VLOOKUP(O3,'Dropdown list'!BY2:BY4,1),O4=VLOOKUP(O4,'Dropdown list'!BY2:BY4,1)),"yes",AND(O3=VLOOKUP(O3,'Dropdown list'!BZ2:BZ4,1),O4=VLOOKUP(O4,'Dropdown list'!BZ2:BZ4,1)),"yes"),"no")="yes",IFERROR(IF(AND(O3=VLOOKUP(O3,'Dropdown list'!CA2:CA4,1),O4=VLOOKUP(O4,'Dropdown list'!CA2:CA4,1)),"yes"),"no")="yes"),"yes","no") If the 1st value is in column BT and the 2nd value is in column BT, then return a "yes" if not a "no." This is true for all the following columns. If the 1st value is in column BU and the 2nd value is in column BU, then return a "yes" if not a "no." I am getting no for all arguments except for the 1st column. Any thoughts?68Views0likes3CommentsConditional Formatting
I am having trouble with a formula I would like to apply to a date column. I'd like a row to highlight or fill red if the date is past due (Today's Date) AND the cell next to it is "Blank". I would like to have at least the date column fill red when the date is past due =J3<TODAY() AND K4 is Blank. Thanks!Solved59Views0likes2CommentsBeta 2505 - OFFICE_MODULE_VERSION_MISMATCH
After Microsoft 365 updated to Beta Version 2505 earlier this week (April 8), Reliability Center shows an OFFICE_MODULE_VERSION_MISMATCH error when the program is closed for all installed apps (Word, Excel, and Outlook Classic). Furthermore, when Outlook runs Reliability Center shows an error identifying that the Search Protocol Host crashed. The faulting module is identified as ntdll.dll. I know the error is linked to this Beta Version, as I restored a system backup from April 7 that had Beta Version 2504 installed. There were no errors. As soon as Microsoft 365 updated to Version 2505, the errors returned. I'm hanging back on 2504 for now with updates disabled. Hopefully the issue will be resolved with the next Beta release.94Views0likes3CommentsUnderstanding Macros Function
Hi, I need to split the data in a cell into texts and numbers separately using VBA. I came across a function that does that but I have a question regarding that. I'm very new to Macros and I'm trying to understand every nuances of it. Here is the function to get text Function GetText(CellRef As String) Dim StringLength As Integer StringLength = Len(CellRef) For i = 1 To StringLength If Not (IsNumeric(Mid(CellRef, i, 1))) Then Result = Result & Mid(CellRef, i, 1) Next i GetText = Result End Function And here is the function to get numbers Function GetNumber(CellRef As String) Dim StringLength As Integer StringLength = Len(CellRef) For i = 1 To StringLength If IsNumeric(Mid(CellRef, i, 1)) Then Result = Result & Mid(CellRef, i, 1) Next i GetNumber = Result End Function I need to understand how we are using Result here as a variable without defining it first? Before this I've used variables only after first defining them. Can someone help explain this?Solved844Views0likes4CommentsExtract data from multiple sheet to new sheet in same workbook
I have a workbook with 6 sheets Master Tank List Less than 3000 WC 3000 WC 3200 WC 3400 WC 3700–5000 WC I need to pull data from the 5 WC sheets (excluding the Master Tank List) into a new sheet, keeping the same column names, except for the Quantity column, which I want to exclude. Can someone please guide me on how to do this in Excel?51Views0likes2CommentsOffice 365 - Excel 2016: Find feature no longer highlights text
I am currently searching a very large file for keywords and there is only a slight outline of the row number and cell meeting my search criteria. Previously, the cell or word would be highlighted to easily identify them. I am hoping the Find feature did not permanently stop highlighting text/cell. Is there a setting to change this?5.5KViews0likes6CommentsIs it possible to set your personal preferences in Copilot, like in ChatGPT?
Hello, Like in the title. Is it possible to set your personal preferences in Copilot, like in ChatGPT? Reffering to: https://openai.com/blog/custom-instructions-for-chatgpt1.1KViews3likes5CommentsLinking Table of Contents to Inserted PDF Documents
I have a table of contents but I want to link the first page to a PDF document, then have word automatically create sub-table of contents from the remaining PDF documents. Currently, when I import a PDF as an object, it places the object on a page by itself but I have no way to link the first page of my table of contents to this document ? Table of Contents First Page .............1 (link to first page of PDF by having it inserted into word as an object) --------- sub of table of contents automatically links to second page of PDF document but doesn't have to be inserted and so forth etc etc as there are multiple PDF documents.50Views0likes4Comments
Events
Recent Blogs
- Measure and drive Microsoft 365 Copilot adoption in your organizationApr 16, 2025345Views1like0Comments
- Level up your notetaking skills with these underrated OneNote features.Apr 14, 2025741Views2likes0Comments