Recent Discussions
How to Integrate Tasks from Teams Copilot to To-Do List
Microsoft Teams Copilot makes it easy to track action items from meetings and discussions. By integrating these tasks with Microsoft To Do, you can streamline your workflow and stay on top of your responsibilities. This blog will guide you through the process of syncing Copilot tasks with your To Do list. https://dellenny.com/how-to-integrate-tasks-from-teams-copilot-to-to-do-list/
Excel - Matching outgoing to incoming inventory based a specific conditions
Hello, I wonder if anyone here can help me. I have created an inventory tracking file in excel but I have encountered a difficulty that I cannot seem to find an answer for. I have sequenced each incoming shipment but I am unable to sequence or match or track outgoing shipments automatically based on specific conditions: I need to assign #1 to outgoing shipments until outgoing piece count of 25 is reached, then #2 until 20 is reached and so on When incoming and outgoing piece count net out to 0, I need the status to be "Closed", when we've started pulling from but not emptied out yet, "In progress", and when untouched "Open" I would like outgoing to be link to earliest, not closed, incoming shipment. Of concern: "Out" and "Status" columns Can anyone help with this? Thank you! ChristineGuest accounts and groupchats
Hello everyone, I recently received a support request regarding adding a person with a guest account to a group chat. Unfortunately, Teams refused to add that account. Copilot explained that this is due to the restrictions guest accounts have when it comes to communicating within the tenant they are invited to. Apparently—and this is what I’d love for you to verify—guests are only able to communicate within channels (e.g., threads in a channel) and in 1:1 chats. After we deleted the guest account, we were able to add that person to the group chat. Are the following informations correct? Guest user in tenant: Added as a guest in your tenant’s Azure Active Directory Access: Teams channels, files, meetings Restriction: No regular group chats outside of Teams channels External user (federation): Remains in their own tenant, connected to yours through federation Access: Chats and calls like regular Teams users Advantage: Can be added to regular group chats Thank you for your help. Best Hisham
Excel Code trying to copy cell data from one sheet to another based on 2 criteria
Sheet "My Plan" Sheet "Tracker" I have several plans in external files that I have code for to select and import 1 to sheet "My Plan". I am using cell E6 as a named cell called PlanName and I select the name of the plan from a dropdown. Column D which is "Unique ID" Column I which is "Baseline Date" Column L which is "% Complete" Sheet "Tracker" is a Table called "Table1" I am looking for code (which I will activate by a button) which will look on sheet "Tracker" column Name "Workstream / Project" and if it doesn't match "PlanName" then go to the next row. If it matches then it needs to compare from sheet "My Plan" column D with sheet "Tracker" field "Plan Unique ID". If they are the same it needs to copy sheet "My Plan" column I and L to sheet "Tracker" fields "Baseline Due Date" and "Percentage Complete %". Great if you can help
Simply cannot delete a section break. It is impossible. Cannot be done. Please prove me wrong.
So I was introduced to section breaks as a means of getting page numbering up-to-spec for book I've written (roman. numerals in the front material, arabic numerals in the book itself). I'm using the latest version of Word (16.8?) on Mac. To my horror, I've found that it is impossible to delete section breaks once they're in my document. I have spend an entire day in Google on this subject, and every single suggestion fails. So I have enabled showing markup, so I can see page breaks, section breaks, paragraphs I cannot select a section break. Word will not allow that. So I can't select and delete it. I cannot put the cursor after a section break and then hit the delete button as many suggest. Word will not allow the cursor to be placed after a section break. Putting the cursor before the section break, as other articles recommend, is just wrong. All you're doing there is deleting text before the section break. Why is this so hard? I've lost a whole day on something that should be simple. In the screenshot from my document below, The section break simply cannot be touched.
Word random crash during Word mail merges after windows update
Hello, Since the Windows 24H2 BUILD 26100.4652 update, we've been observing a random crash during Word mail merges. These are lists of fields in tab-delimited txt format. These random crashes occur both during the generation of our VB code and during manual testing. The affected machines are those that have received the latest Windows updates, regardless of the version of Word installed (2016 and later). In addition, the crash can occur directly during the merge request, while scanning records, or during the final multi-page generation. Thank you for your help.How do I unlock an unopened Excel document?
My problem: I attempt to open a document, it hangs during the load at the "Accessing Printer" of the loading prompt. The result is a lock on an unopened document that cannot be closed at the Task Manager but not seen by Taskkill at the command prompt. The Scenario: In the image (scenario) below, PID 114776 hung when the "accessing printer" message appeared on the Excel loading prompt. When I close the prompt, the Excel task (14776) remains but cannot be ended in the Task Manager (i.e., selecting End Task), nor can it be ended via the command line because the Taskkill cannot see the process. The Result: If I attempt to open the document, then logically a separate task process opens, but the locking message appears because the unopened document is locked for editing and there is no way to kill that process that I know of - other than going through an entire computer reboot. I'm using Office - Excel 2019.PDF not Opening from Mail
I have just bought a new MacBook Air and upgraded to Microsoft 365. I have some important PDF files to open which needs a password to open them. When I click on the file an error message comes up saying "can't open file". Something went wrong and your file cannot be opened now. Please try again later. It is not giving me an option to enter a password and there is no menu bar showing. Have I not go my Mac set up right or can I not just click and open now. Please help a real techno phobe.Switch my License in Excel
Hello Community, I need some help with an issue I’m facing. I am currently using the second account license for my Microsoft 365 apps, but I’d like to switch back to the first account. I have tried using the “Switch License” option under the second account, but it hasn’t worked. I would appreciate any alternative steps or solutions you can suggest. Thank you.
Captions for images, including sub-captions
Good morning, I’m using Office 365 (Office 2019 at home). I wanted to ask if it’s possible in Word to create captions for images, including sub-captions, with all the corresponding indexes reflecting the hierarchy. I mean something similar to the photo below.Profile photo component adds unwanted overlay
Component https://myaccount.microsoft.com Run command: ms-settings:yourinfo Environment Profile picture uploaded through https://myaccount.microsoft.com Profile picture uploaded through Run command (WIN+R): ms-settings:yourinfo Retrieved via Microsoft Graph SDK / Graph REST API endpoint /v1.0/me/photos/$value Steps to Reproduce Go to https://myaccount.microsoft.com. Upload a new profile picture (no presence, badge, or branding requested). Retrieve the profile picture using Microsoft Graph endpoint: GET https://graph.microsoft.com/v1.0/me/photos/$value Render the image in the client application. Expected Result The raw profile photo is shown exactly as stored—no overlays, rings, badges, or branding. Actual Result The component renders an overlay (e.g., presence badge/ring/branding) on top of the photo, altering the image. Impact Users see altered profile photos, leading to inconsistencies with expectations. Breaks brand/UX design guidelines that rely on unmodified profile images. Severity Medium–High (affects identity consistency across apps using Graph). Notes This happens even though no overlay option was requested in either the upload or retrieval flow. Alternative: Steps to Reproduce and working as expected Run command (WIN+R): ms-settings:yourinfo Upload a new profile picture (no presence, badge, or branding requested). Retrieve the profile picture using Microsoft Graph endpoint: GET https://graph.microsoft.com/v1.0/me/photos/$value Render the image in the client application. Expected Result The raw profile photo is shown exactly as stored—no overlays, rings, badges, or branding. Actual Result The raw profile photo is shown exactly as stored—no overlays, rings, badges, or branding.Microsoft’s Effort to Develop a Broad People Platform
Microsoft 365 users see the profile card and might wonder where the information displayed on the card comes from. Entra ID is the obvious source, but the people platform that Microsoft is developing is another and could include information imported through a Copilot connector to build out a complete picture of users and contacts within a Microsoft 365 tenant. It’s early days yet, but beta code is available. https://office365itpros.com/2025/09/10/people-platform/
Delete Empty Rows ONLY
I saw someone else's post, but nobody addressed the problem. Their solutions delete every row that contains a blank cell. I want to delete ONLY the rows that are COMPLETELY blank. The top rows are what I want it to resemble. The bottom several green blank rows are what I want to batch Delete.
Double quotations appearing in an Excel .txt delimited file
I am attempting to upload a delimited .txt file to a website. The website has very specific instructions as to how that file should be formatted. Part of that formatting is that every entry should be separated by a single quotation ("), then the entry, followed by another quotation (") then a comma (,), and then the next entry begins and so on. When I open my file in text import wizard, step 1, shows, opening double quotations ("") entry, then closing double quotations ("") and a single comma (,). Step 2 of 3 then shows Delimiters with the tab box checked, and the text qualifier box showing a single quotation ("). The entries in the view box appear as I want them (") entry (") (,) Step 3 of 3 shows the same highlighted in black, with column data format set to General, and date set to mdy. Again, at this stage, just single quotations (") on either side of each entry. When I hit finish, it opens up the excel file, again, showing the quotations as required ("), and the comma (,). I then upload this to website, and it is rejected. The website provides an error log, which shows double quotations ("") on either side of all entries, and a single comma (,). Does anybody know what I am doing wrong to cause this, please? Thank you in advance!
Autocomplete has stopped working
I'm using the Office 365 (web version) of Excel to keep track of my paper trades. Until recently, I was able to populate the ticker name and symbol columns with previous entries by just starting to type their name. It would then "autosuggest" based on those previous ticker names/columns. Now, it doesn't do it anymore. I've tried to find a solution online but they often reference menu items that don't even exist. How do I fix this? I can always copy and paste but it's so much easier and convenient to be able to use this auto complete feature to populate with pre-existing entries.
Recent Blogs
- Microsoft Copilot can help you find volunteer opportunities or organize a food drive at your office.Sep 10, 2025
- 1 MIN READCelebrate Excel's 40th Birthday by joining the Microsoft Excel team for our Reddit AMA on September 30, 2025, at 10AM PT.Sep 09, 2025
