Recent Discussions
Time sheet for hours worked
I am needing to make a sheet that shows clocking in for work - clocking out for lunch - clocking in from lunch - clocking out for the day and then the total of those hours worked per day and then grand total for the week. For our pay system we do things in 6 minute increments. I found a sample sheet through Excel, but the formula we have still isnt just right. Here is what I have and the formula for the hours worked is what I am needing help on. Any help is very much appreciated!
Organizational Account authentication problem
I have encountered a new authentication problem using an organizational account with Get Data > From Web. The data source is Dynamics 365 CE on-premises (https://ce.xxx.com/api.data/v9.1), authenticating through ADFS with MFA. This has been working without any issues until recently. When I attempt to refresh the query, I get an ADFS pop-up window for username and password, as expected. However, the window then closes without the expected MFA prompt. The "Access Web content" window does say "You are currently signed in," but does not query successfully, instead displaying the error "We couldn't authenticate with the credentials provided. Please try again." The most distinctive symptom, is that clicking the "Sign in as different user" button does not work. It just quickly opens and closes an empty window, instead of the expected ADFS username/password page. In Power BI Desktop everything works. The connection and query are successful, and the "Sign in as different user" button successfully displays both the initial ADFS username/password window and the subsequent MFA dialog. Excel version: Microsoft® Excel® for Microsoft 365 MSO (Version 2512 Build 16.0.19530.20226) 64-bit
Bookings Page not sending confirmation emails to customers
Hello, I am the main technician for my company's service desk. We have a Bookings page, but any time anyone books a time slot, they receive a message indicating that they will receive a confirmation email, but no email comes to them. In the settings, it shows the checkbox to send a confirmation email is checked. I have also looked in Exchange Admin and run a message trace and cannot find any confirmation email sent to myself or other testers. In Bookings, I have unchecked the confirmation email checkbox, saved, checked, saved, and tested - same result. Additionally, this Bookings page is only for internal users, and all of them are 'customers' with their full organization email address. In researching, I found that there was mention of the Bookings needing to have an Exchange account as a shared mailbox, which I do not believe we have - when I search the email that confirms for me that someone has booked with me, it is a long string of seemingly random letters and numbers with an internal domain address. I have also tried searching in Exchange Admin for 'IT' 'Service Desk' 'Service', and 'Desk', none of which have any results under Mailboxes (which would include shared mailboxes). Any advice/suggestions would be greatly appreciated. Screenshot:
Onedrive sharing not working for one user
There is only one user who cannot share with anyone external or internal. I have checked everything, they are a site owner, a site admin, a site member, we have no restrictions on sharing, it works for others. I made a new site just for them as the only admin, they still cannot share. They have been removed and re-added 5 times. We have a microsoft support ticket and they don't even seem to know the issue. What can I do?
re-distributable installer for OneNote for Windows 10
Hi, I am attempting to obtain a re-distributable installer for"OneNote for Windows 10"( We have computers in our environment where the Microsoft Store is locked down and not accessible. I have access to the Microsoft Store on other computers and am able to successfully install/uninstall/re-install the app. I have also conducted online searches to determine where the MS Store downloads it's files to and tried to obtain the installer files by looking in the c:\programfiles\windowsapps\ directory and have been unsuccessful. I am attempting to comb through the temp directories to try to find anything. Any insight and guidance would be appreciated. Thank you.Word - Same Line Page Breaks Visibly Change Formatting
Within the last week or so, Word suddenly has started changing the formatting of visible text when a page break is used on the same line. How can this be corrected? (To be clear, yes, a page break could moved to the next line or deleted if there is not room for the extra line, but this impacts dozens of templates I have been using for years and I just want to set the formatting back to how it has worked in the past, where a page break inserted at the end of a line with centered text did not change the formatting of the visible text in said line.) Example 1 below is how it always used to appear whether the page break was on the same line as the centered title text or not. Example 2 below is how it looks now when the page break is on the same line.How to unlink cells in Format Control
I am developing a survey in excel (because the questions are complicated and long and do not format well in e.g. MS Forms) and using option buttons to choose responses. Each question has 6 potential responses. In developer I have inserted a group box, into which I placed 6 option buttons. After formatting the buttons so that they snap to the excel grid I then linked them to a cell to make calculating responses easier. On-line advice then suggested that I could copy and paste these to each new question. However, by doing this, I am only able to choose 1 option as they are ALL linked to the same cell. How do I unlink each group box of 6 option buttons so that I can link each group individually to a different cell for each question? Or - do I have to create a group box and option boxes from scratch for each question set? I have removed the questions for simplicity of view (note that there are 6 in Q1 and Q2 not visible) and highlighted the linked cell from Q1. As you can see - for Q5 this has given an answer of 26 (the 26th option button) rather than 2 (the 2nd button in Q5)HELP! stuck excel cell formula I cant get rid of
Hi - I'm no excel guru - was doing a cut/paste of a few hundred rows of data, and somehow hit a wrong key(s), and now can't get rid of this weird formula I inadvertently created, which has my spreadsheet locked up. Hitting delete or backspace does nothing. The formula at the top of my excel spreadsheet displays this: =421:G6562.45 421 is the very top row in the section I was highlighting, and G656 was the very first cell I started to highlight. 52.45 is the value in that cell Any help someone can provide so that I can get back to my project is SINCERELY appreciated. THANK YOU in advance! TomTender Tracker formula help
Hello, I am creating a spreadsheet to track tenders for various part numbers so that I can track when each part number is up for renewal. Is it possible to create a formula which based on the tender renewal date, excel would colour fill the row up until that date which is in the top row? Example screenshot. Not sure how to add an excel filePrimer: How to Use RBAC for Applications to Control App Use of the Mail.Send Permission
The temptation to use the Mail.Send application permission in scripts can lead PowerShell developers into trouble because the permission allows access to all mailboxes, including sensitive executive and financial mailboxes. Fortunately, RBAC for Applications allows tenants to control the access that apps have to mailboxes and other Exchange content. All explained here with an example script to test RBAC of Applications. https://office365itpros.com/2026/02/17/mail-send-rbac-for-applications/
Indenting in numbered list has gone haywire
My office uses custom Word templates that are updated to a legal software site, populated with an intake form through the same site, and then downloaded to our individual computers to edit as needed. The templates mostly use legal numbering under the Normal style. On Tuesday February 3, everything was working fine when I put my laptop to sleep. The next morning, I opened a Word document that I had downloaded from the legal software site and edited a week or two previously, and the formatting and indentation of the numbered lists was suddenly completely wonky. I had not changed any settings from the end of one day to the beginning of the next to cause this issue. In addition, I am the only one in the office of five people to be experiencing the problem. I contacted tech support, and the support person walked me through fixing the styles settings, and when that did not work, they uninstalled and reinstalled the entire Office suite. That also did not solve the problem. I'm completely stumped here; why would this issue suddenly arise with no input from me and also only affect my version of Word? And why didn't reinstalling the application fix it?? Details of the formatting issue: Normally, the numbering should look like this FIRST 1.1 The text goes to the right margin of the page and then wraps so that the second line is indented by the same amount. 1.1.1 The first sub-paragraph begins at the indentation of the text in the first paragraph 1.1.1.1 The second sub-paragraph starts the same way, etc. Now it looks like this: FIRST 1.1 The text begins closer to the number and goes to the right margin, then the second line is not indented to begin at the same point as the first line. When I click on the leading number (e.g. 1.1), some of the text jumps over to the right slightly. When I try to use the markers on the ruler to adjust the indentation, the text doesn't move at all. In addition, I can open a document, not mess with the wonky formatting but change something else, for example remove a watermark, then save and close the document, and one of my colleagues can open the same document and not have the formatting be messed up. Please help!
Word for Mac: markup turned on by default
I've recently had problems when saving Word docs as PDFs on my Mac (using the Word process, not the built-in Mac process): the PDFs have included the comments markup in a column on the right. After a big of digging around it seems that Word now turns on the mark-up by default in some recent Mac builds. Even after I amended the Normal.dotm template so that markup was turned off, new documents still have the markup enabled. Has anybody else come across this? It means that whenever we export to PDF, 3 extra mouseclicks are required if we want to ensure that the comments pane isn't included. And even after we've done this, if we re-open the same document, mark-up has been turned back on. There doesn't seem to be any way of changing this behaviour.those annoying ~$ files
My Word (using Mac Sonoma) leaves behind these ~$ files. They are supposed to be temporary, but they look like files I was last dealing with months ago. They are NOT temporary. I wanted to clean them up, and rm ~$* doesn't do the trick. What works well is rm -i './~$'* . Go figure. Now, WHY are these files getting left behind by Word and polluting my Desktop folder?ODBC call failed. ORA-01406
Trying to link to tables on our server which has never been an issue. ODBC connection is fine, using Driver Oracle in OraClient 11g_home 1. Selecting Data Source ODBC Database and selecting Link to the data source by creating a linked table. At this point it asks for a password which is typical, next it would normally bring up the list of tables in the Oracle database to link to. Instead I get the error which states "fetched column value was truncated", once I hit OK to clear the error the usual window appears where I would see all the available tables to link to but no tables are listed, it's blank.
Link doesn't work
We have recently started experiencing an issue when opening links within Excel on Azure Virtual Desktop. Our AVD environment is currently running the Version 2601, but the behaviour is very inconsistent, only a couple of users are affected, and the issue appears completely random. Interestingly, it works fine for most users both inside AVD and outside AVD. Affected users are receiving the following error message (screenshot below). So far, I have tried the following without success: Clearing the Excel cache Deleting the Excel container from the registry: HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel Is anyone else experiencing the same issue, or aware of a fix/workaround? Any help would be greatly appreciated.
Events
You’re passionate about what you do, and we’re passionate about empowering your potential. Microsoft 365 Community Conference - is your chance to keep up with AI, build game-changing skills, and take...
In-Person
Recent Blogs
- 4 MIN READHello and welcome to the new Agent 365 blog! As AI agents become core contributors in modern organizations, having a trusted control plane is essential. So we hope you'll follow and share this blo...Feb 16, 2026
- The Microsoft 365 Community Conference returns to Orlando this April, bringing together thousands of builders, innovators, creators, communicators, admins, architects, MVPs, and product makers for th...Feb 12, 2026
