Recent Discussions
MO 365 Excel - Difficulty Changing a Date format
I am using MO 365 - apps for Business, currently received an Excel Spreadsheet and am attempting to change date format in Excel and have tried all the usual methods however the dates remain unchanged. I need to change the date from month /day/year as 1/31/2025 to Year/Month/Day 2025/1/31 Any Suggestions? Thanks CJ
Formula for adding multiple sheets
I am trying to add multiple things across multiple sheets. example : On sheet one, I have column a date, column b check number, column c name of place, column d category, column e withdrawal amount, column f deposit amount, column g balance, column h status (cleared or pending). this same information in on sheets 2,3,4,5 and so on. I want to create a sheet that will tell me how much I have spend with each name of place (column c). let’s say sheet one looks like this 3/23 (date) 777 (check number) John Doe (name of place) 2.00 (withdrawal amount) etc. 3/23 778 John Doe Jr. 3.00 etc sheet two 3/24 666 Joe Doe Jr. 3.00 3/24 668 Joe Doe 4.00 on my total sheet with the amount I have spend with each person/place to look like this Joe Doe — 6.00 (from the 2.00+4.00) Joe Doe Jr — 6.00 (from 3.00+3.00)
Creating weekly calendar template that has overlapping positions
Hi, I have a software for individuals to sign up for shifts, but it is visually hard to see where there are open areas that need to be filled. I need help creating a calendar from this software download that I can update each week. It would have to be much like an hourly scheduler view to easily see when someone is coming on and off shift. But also laid out from Sun-Saturday. There is 3-4 "slots" for each day. It would be great if they could be color coded as well. Slot 1 needs to be anyone that is "AEMT" in the position column, Slot 2 can be anyone listed as "EMT" or "EMR" (caveat to this would be that slot 2 could also be AEMT if there is already an AEMT in slot 1 for the same time slot. Slot 3 is for driver or ride along (or the other 3 positions if there is one listed in the other slots), and possibly 4th slot would just be overflow in case there were 4 people signed up which does not happen very often. Is there anyone who can help me with designing this? Below is what the software generates when converting to excel
Allow removal of "Copilot Suggestions" from right-click menu
I have been using Excel for decades and CONSTANTLY use the right-click menu for quick access to basic functions (e.g., "Insert"). Ever since "Copilot Suggestions" was added to the drop-down list, it always throws me off due to its placement. I have Microsoft 365 on Windows 11 Pro. I have searched for ways to remove this from appearing there and the result said "go to File > Options > Copilot and uncheck the 'Enable Copilot' box". However, when I attempt to do that, there is NO "Copilot" option available! PLEASE allow removal of "Copilot Suggestions" from the right-click menu OR at least the option to move it to the bottom (so it isn't in the way of things used ALL the time). I realize that Copilot is a great resource for many users, but I am confident in my Excel skills and in my ability to research/learn new skills the "old school" way, so I have little use for this feature now and would prefer to hide it.M365 Security Basics: Keeping Your Data Safe Online
In today’s digital-first world, data is one of the most valuable assets a business or individual can have. Whether it’s emails, documents, spreadsheets, or sensitive customer information, protecting that data is critical. With Microsoft 365 (M365) being one of the most widely used productivity platforms globally, understanding its security basics is no longer optional it’s essential. https://dellenny.com/m365-security-basics-keeping-your-data-safe-online/Two days of edits inexplicably disappeared
I have a 2021 MacBook Pro and two days ago I updated my OS to Tahoe 26.4.1. The update seemed to work fine, and I continued working on a Word document I had been editing for the next two days. I always save after every line I write, and I use the auto-backup feature. There was no indication that my saves were not going through. Just now, however, I opened up the document to discover that all my edits (as well as the "last saved" time) had reset to what they were two days ago, around the time of the OS update. This is the case both in Finder and when I go to the Dropbox website, which I use to automatically upload everything I work on to the cloud. This is very alarming. Why has this happened, and is there a way to recover the lost edits? When I try to do "File -> Browse Version History" the menu item is dimmed and I can't click on it. Help!Once Publisher disappears...help please.
Hi all, So I see that by late 2026 Microsoft is getting rid of Publisher which means ( as I understand it ) any/all of my PUB files on the pc will no longer be able to be opened/used. I know I can convert my PUB docs to PDF but how do I do the following. I have a number of PUB docs that have multiple photos on each page. These pages are used for a notebook that I change annually. Some photos stay and some are replaced. Dead easy to do using PUB but what happens when PUB goes. I can open the changed file ( from PUB to PDF ) but it doesnt allow me to change individual images..its all or nothing. I can work out how to open a PDF in WORD but the same thing is happening..its either every picture or nothing ?? SO..my Q is..once PUB goes what can I use to keep editing these pages. HOpe someone can help me. Thank you
Excel 365 Sheet Views are not working
I have 7 different Sheet views in a shared document, they were working fine until about a month ago. Since then I have tried everything, I deleted them, created them again and they don't work. When I create them they look fine but once my collaborators enter to work on the spreadsheet all the views start showing the default view. The sheet has the black border and the eye in the tab. How can I solve this
Pivot Table
Hello, I am currently working on several dashboards that include multiple Pivot Tables Is there a way to filter data using the Filters field in Pivot Table design with conditions such as "greater than", "less than", etc..? At the moment, I have to manually select each value I want to keep, which is quite frustrating when the selection is huge It would be very helpful to have condition filtering available in this area Could you consider adding this feature in a future update ? Thanks in advance,Disabling Copilot in Forms not possible
Hi everyone, Not sure if this has been addressed before - I couldn’t find anything about it in this forum. Since Copilot is now integrated into Microsoft Forms, there doesn’t seem to be any option to disable it (like in Word, Excel, Powerpoint). What I find frustrating is that every time I open a previously saved form, Copilot automatically runs checks and generates recommendations—which, in my experience, aren’t particularly useful. More concerning is that this process does consume AI credits. I'm on a personal plan with 60 credits, I’d prefer to have control over how and when those are used, rather than having them spent automatically on features I didn’t explicitly choose to use. Microsoft support has confirmed that there’s currently no way to turn Copilot off in Forms. Is anyone else experiencing this, and isn't this something Microsoft should address? Thanks!
Microsoft Access and Outlook
Hi there, I have just updated my laptop (with a view for a faster laptop!) However, Access was working fine and now i can't send emails from access through outlook like before. I get a message to say a program is trying to send an email message on your behalf. I'm not sure how to get rid of this warning! Please help.... Thank you in advanceCreating a Planner Weekly Notification Email for Incomplete Tasks
A reader wanted a weekly incomplete task report to send details of Planner tasks to people with outstanding work to do. We used PowerShell to scan for incomplete tasks for people who are members of a group, perform some analysis on the data, and create and send email. Despite some deficiencies in the Planner Graph API, the code is pretty straightforward. https://office365itpros.com/2026/04/15/weekly-incomplete-task-report/
Insert a row
Hello, I want to insert a row in Excel to shift the existing data downward, but an error message prevents me from doing so, stating that non-empty cells would be pushed off the edge of the worksheet. Could you please tell me how to insert this row without deleting my existing data? thank you !Office Scripts
i have a business microsoft office account and am signed in with it. when i try running a script in excel i keep getting the error saying it requires a work or school account. my microsoft account says the following: your work or school account belongs to your home organisation. what do i need to do to get scripts working.
M365 Copilot Android Application Not Working
I am using a Samsung S24 FE phone, and the Microsoft Copilot app is not working. When I open the app, I only see a black screen. I cannot open any menus. I cannot create or search for anything. There is only an empty home screen with dead buttons. I cannot sign out of my current account, nor can I figure out which account I am signed into (it logs in automatically). Here’s what I have already tried, but the issue persists: Enabled all permissions in the app settings. Deleted and reinstalled the app. Cleared the app cache and reopened it. Cleared the app data and reopened it.
How can I overcome the HYPERLINK Functions 255 character limit?
Hi! I am trying to workout how to overcome the 255 character limit for the hyperlink function in excel. Currently I have formulated a HYPERLINK link which pre-populates information for a 3rd party form (JotForm) with values from my spreadsheet. It displays #VALUE! in the cell. Does anybody have any suggestions or solutions for overcoming this issue? Thanks!
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
- Building in the era of AI can get very challenging. That’s exactly why we’re here to help you debug, refactor, and level up at the Microsoft 365 Community Conference, happening April 21–23, 2026 in O...Apr 15, 2026
- 1 MIN READMay 12, 2026 at 9 AM PT is our next "Ask Microsoft Anything" with the Agent 365 team.Apr 15, 2026
