Recent Discussions
CANNOT OPEN THE SPECIFIED FILE with tel:-hyperlink
Hi, I have several "tel:" hyperlinks in a Excel sheet (xlsm). Yesterday, they sended the phone numbers to whatsapp. But today i become the errer:"CANNOT OPEN THE SPECIFIED FILE". I saved yesterday a xlsx file as xlsm, after the conversion, the links were still working. What goes wrong?
IF ISBLANK and NOT
Hi all, I am banging my head against a brick wall trying to figure this out. Column C has a day in it. Cell X6 has a value in it which automatically updates every day. Column X has new values entered every day. The value in column AM for each row is calculated with a formula, so it will give the value of X6 if X in the same row is empty, or 0 if X in the same row has a value. =IF(ISBLANK(X324),X$6,0) will give me what I want if just looking at the cell in row X, but I also need to check if C324 is either Saturday or Sunday. =IF(AND(OR($C327="Saturday",$C327="Sunday"),(ISBLANK(X327))),0,X$6) will give me 0 if X327 is Blank and C327 is either Saturday OR Sunday, but will not give me 0 if X327 is Blank and C327 is not Saturday or Sunday. Is there a way to use the NOT function with the ISBLANK to say if X327 is Blank and C327 is not either Saturday or Sunday then it will return value X6, but is any of those statements are not true then it returns 0. Thanks in advance...
Excel Comments gone/unable to view
I've created a workbook to log information for my work. In this, I had a notes section that I could log all conversations I had when I had contacted a customer so when I hover over the purple indicator in the cell, it would show me the conversations/key notes i've had with customers. I have just opened my workbook today to try and view/add to these comments and all comments now have a red indicator in the cell and the text says the following ' [Threaded Comment] Your version of excel allows you to read this... How can I recover my notes as they are extremely important to my work.
Threaded Comments/Notes after update
Got a message that I needed to update this morning, I thought I was already working on most up to date version, but I clicked OK and updated office 365. When I opened up my worksheet I looked at a threaded note/comment (white box with 'Post' button) I had left on a cell last week. It has changed to a comment (the yellow box, I'm loosing track of which is which). It also shows this message on all the comments: [Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 I no longer see any options for Notes. Not on the Review Tab, shift-F2, or right-click menu. I can only open comments (yellow text box). I would like to see my comments as threaded notes again and start posting more. It looks like the most recent info from "Help" and the support pages is telling me that the threaded comments are the ones I 'post,' and the yellow text boxes are 'notes.' but when I insert a 'comment' it opens up the yellow text box and all the editing options are for 'comments' which refer to the yellow text box. Any help would be appreciated.I can't add an O365 email to Outlook desktop client but I can access it from the web
I can't add a O365 to Outlook desktop client but I can access from the web This a weird thing, whenever I try to add in Outlook from File > Add Account I get the message "Something went wrong and Outlook couldn't set up your account". From Control Panel > Mail > Email accounts > New > Manual Setup > here I put the email and gets stuck at "Searching for... Settings" and then " An encrypted connection to your email is not available, click Next to attempt using an unencrypted connection", so I do that and get the error "We're sorry we couldn't set up your account automatically. To try setting up the account yourself click Next" which is basically the same. Everything works fine in the browser, any ideas on this?Cleaning up data with Macros
Hello everyone! I am cleaning up a worksheet that I use frequently to track weekly expenses and spending. I just discovered Macros and I want to use them to clean up my worksheet. Using Macros, how can I create a button that clears entries that are 3 (or more) months old?
Problem creating an Excel formula
I am contacting you because I am having trouble creating a formula to count names in an Excel spreadsheet. I have created a schedule in Excel in which there is usually one name per cell. The calculation of these simple cells is fine. However, in cells where there are two names written ‘NAME F.1 / NAME F.2’, only the first name is counted. I do not know how to make the second name count as well. If necessary, I can send you the Excel file. Thank you for your help, as I do not know how else to solve this problem.Worksheet tabs to include date from a cell
Hello , I have a worksheet with four tabs. Cell H1 in both tabs 1 and three contains a date. I would like to include that date in the tab name in the following format: for Tab 1 "AR - as of (the date in H1)" and for Tab 3 "AP - as of (the date in H1)". The dates in the tabs would update whenever the date in cell H1 is updated. I am using Microsoft 365 Apps for Enterprise, version 2510, Build 19328.20178. Thank you for your assistance.
Comcast email transition to Yahoo
So here is my problem and I have been battling this for 5 days now and Xfinity and Yahoo support keep striking out. I can access my account just fine in Outlook Classic. If I slide the slide over to the new Outlook nothing gets transferred or setup. If I try and add my account manually using an app password it gets to a screen where it states syncing with one drive then I get a screen where it fails and states I need a App Password. I have put in the password multiple times and it seems there is issue is with syncing the mail with one drive in the new Outlook.Table Borders in Word Disappearing
Over the past week or so, the table borders in our company's Word documents are disappearing. I am seeing a lot of posts in message boards around the internet where people are having the same issue. Is this a known bug with a recent update? Even when we go into the table style and modify the style add the borders, they disappear again once the document is closed and reopened.
How to make a pie chart dynamically update by selecting a role from a slicer in Excel Pivot Table?
Hi everyone, I’ve created a table in Excel using Power Query, and the table name is All-Training. The table has the following columns: Process Training deliverables name Relevant to (workday role) Here’s a small data sample: Process Training deliverables name Relevant to (workday role) Compliance Training Data Privacy and Protection Employee Compliance Training Anti-Bribery and Corruption Employee Technical Training Excel Essentials Employee Technical Training Power BI Basics Employee Leadership Skills Coaching for Growth Manager Leadership Skills Leading High-Performing Teams Manager Compliance Training Workplace Ethics Manager Performance Management Goal Setting and Review Manager Technical Training Azure Fundamentals Engineer Technical Training Kubernetes Essentials Engineer Compliance Training Health and Safety Standards Engineer Performance Management Feedback Conversations Analyst Technical Training SQL for Data Analysts Analyst Reporting and Dashboards Power BI Advanced Reports Analyst Goal: I want to create an interactive Pivot Table and a Pie Chart that dynamically update when I select different roles from a slicer. Here’s what I expect: The slicer should allow selecting roles such as Employee, Manager, Engineer, or Analyst. When I select Employee, the Pie Chart should show two equal halves (50–50), because there are four training deliverables — two under Compliance Training and two under Technical Training. Similarly, when I select Manager, Engineer, or Analyst, the chart should update automatically to show the distribution of training deliverables across their respective Process values. I’ve already created a Pivot Table and inserted a slicer, but the pie chart doesn’t seem to update interactively when I change the slicer selection. Can someone guide me step-by-step on how to link the slicer, Pivot Table, and chart properly so the pie chart reflects the selected role’s data automatically? Thanks,
MS Forms If function ignoring new data
Hello, I have a MS form setup collating information, I need to then reformat how this data comes in so it can be copied directly into another bit of software. Currently we have sheet 1 as below which is what gets filled in automatically and directly from the form I have created a new sheet in the same excel file which then pulls the data from sheet 1 and rearranges it into the order I need. This uses the function as below. =IF(Sheet1!J2="","",Sheet1!J2) This works fine when initially setup, but when new entries are submitted to the form and new rows of data appear in sheet 1, the If formula on sheet 2 then skips these new data rows. For example if a new submission to the form has been made, then on sheet 2 cell b5 will say =IF(Sheet1!J6="","",Sheet1!J6) which is correct but the cell in the one below will =IF(Sheet1!J8="","",Sheet1!J8) which has missed J7 Can anyone shed any light on this? Thank you"Heading" and "Body" fonts are sometimes incorrectly displaying as Times New Roman
This appears to have started with the latest update that also made table formatting go nuts. Sometimes when we open a document from SharePoint, any text that has been formatted with "Body" or "Headings" will display as TNR. The font box will show "Times New Roman (Body)". The style definition will show "Body". Under the Design tab, the font scheme shows the Heading and Body as both being "Aptos" though, which is correct. Limited testing shows that closing Word down completely fixes it. But it's causing a lot of consternation!
Microsoft 365 Board?
I used to be a regular visitor to the Office 365 Yammer Partner community until it closed down earlier this year. I think they said that Tech Community was the place to go and I've found this board, but I can't find an equivalent one covering Microsoft 365. The community had regular updates about changes in the platform, upcoming webinars, partner offers, etc. It seems odd that various boards exist under the Microsoft AI Cloud Partner Program section of Tech Community, but nothing for M365. Can anyone point me in the right direction? Thanks, NickFilter Function or any Logic
Dear Experts, I have a data like below , Column "H" has rnti's , Column "F" has sfn which can range from 0~1023( and once 1023 it shall start again from 0) slots that can range from 0~9, each sfn(say 252) has slots(0~9), Column "J" is Sn( Sequence number) , In Output , I want like this, example for the rnti 384, column "B" = count of spdu-1 for the rnti=384, and so on How the spdu-1 counted? (spdu-x's are counted per rnti & per-rlcCtrlAckSn_ ,) as below for example for rnti==384, Thanks in Advance, I posted this earlier also , not sure why post got deleted somehowLock down Form creation for staff
Hi, I want some staff being able to create forms/surveys etc. https://forms.microsoft.com/ I want to ensure that the rest of the staff can consume the forms ,i.e. fill in, but not create new or "Collaborate or Duplicate". What is the best way for me to do this? Thank you for your time, Ollie
Events
Learn, Connect, and Be Inspired at ESPC25
Join us in Dublin for ESPC25! One of Europe’s largest community conferences, ESPC25 is your opportunity to expand your Microsoft 365 Copilot, Collaborative...
In-Person
Recent Blogs
- 2 MIN READThank you for a fun decade of feedback, community, and engagement!Nov 13, 2025
- We’re thrilled to announce that Surveys Agent - your intelligent assistant for managing surveys end-to-end - is now generally available to all commercial customers worldwide with a Microsoft 365 Copi...Nov 10, 2025
