Recent Discussions
Export mixed text and tabular Excel to PDF
I have a sheet that I need to export from Excel to PDF. The sheet contains text and tabular data. Ideally, I'd like large bold text to export as heading tags, text as paragraph tags, and the tabular data as a table. Currently, any group of cells containing data that are surrounded with blank cells export as a table, even if they don't contain what a human would consider tabular data. I haven't selected the tabular data and chosen Import > Table. I'm not sure if that would help or not. How can I export mixed text and tabular data from Excel and have it be tagged as desired in the resulting PDF?Why are documents now displaying tiny cells and none of my cell text is visible.
Opened this application today to find this. The view is damaged or corrupted so that there are hundreds or thousands of cells visible in the viewport at 100% view scale. Zooming in does nothing to improve this. Zooming out to 10% then appears to show some of the text very small in the top left of the viewport, until zoomed in again at which point the text disappears once more. What is visible is very clear in the screenshots attached to this post. We have attempted an online repair of microsoft 365. this has done nothing. All existing documents persist in showing this. All new documents persist in showing this. We do not know what windows updates have been done. Nothing has been done by us. We do not know if any changes to drivers has occurred. Nothing has been done by us. We are looking for advice or knowledge from any user/s who have seen this specific issue before.
Delete a print area label on a worksheet
Hi, I would like to delete the print area labels on a worksheet. I find that the labels I used are not descriptive enough. Excel names the first print area as Print_Area. The next area would be labeled Print_Area_1. I would like to delete all of the labels or perhaps selected labels so I can enter a label name such as Print_Area_1_SUN. Would appreciate your help with this. JoeUsing the Microsoft Graph PowerShell SDK to Update User Profiles
Now rolling out to Microsoft 365 tenants is the ability to update user profile cards with details of awards and certifications held by users. Usually, HR departments would provide the source data and probably arrange for the data to be ingested into the Graph through a Copilot connector, but it’s possible to add awards and certifications for individual users using Microsoft Graph PowerShell SDK cmdlets. All explained in great detail with working examples here. https://office365itpros.com/2026/05/08/user-profile-card-awards/
Using average
I keep a golf spread sheet that has all the points of each round. For handicapping purposes, we use the average of the last six scores. Since not every player plays each week, the six scores needed for the average will be different cells. I need a formula that will average the last 6 entries that have a score entered. Each week I will add another column and would like it to update the average of the last six rounds with a score.Microsoft Releases Cmdlet to Retrieve Disposition Review Items
The Get-ReviewItems cmdlet (in the Exchange Online management module) is available to export details about disposition review items in either a pending or disposed state. It’s possible that you don’t care very much about records management, retention labels, or disposition processing, but if you do, you’ll be glad that the new cmdlet exists. https://office365itpros.com/2023/04/10/disposition-review-items-export/
Prevent Microsoft 365 meeting invites from automatically appearing in users’ calendars
Hi All, We are trying to prevent Microsoft 365 meeting invites from automatically appearing in users’ calendars as Tentative until the user explicitly accepts the invite. Setting for Outlook Classic, New Outlook and Windows or Outlook Web. Need Microsoft recommendation on this one.Data Loss: automatic safety labels in a file opened from WhatsApp
Hi everyone! I made a huge mistake... I sent myself a word file from WhatsApp, I opened it (without saving it, dumb I know) and started working on that file. I didn't know that Word couldn't save the file due to safety labels, I mean there was no pop up, no Alert, nothing, I just continued pushing the button save and then when I closed the window there was no special alert, no message, so I thought it was all fine... My file disappeared, I couldn't find any .TMP to restore, it wasn't in the driver or somewhere else. I swear it was like writing with invisible ink! Of course I spent this night writing everything again, but I was wondering if there's a way to suggest adding a message to make the user aware of the label. I really don't know why there wasn't any message when I pushed X button even if the file wasn't really saved.
Can't save MS Word files anymore on my Mac
Hi all, I have a macbook air 2020 version with an Intel chip. I'm using OS Sequioa 15.7.4 Microsoft Word version 16.107.1 Since this week I'm having issues with saving Microsoft Word files on my Mac. When I'm trying to save a file I'm getting the following message (translated from Dutch): "saving has failed because of insufficient memory or space on the hard disk" My hard disk is using 133 GB out of 500 GB. So that can't be the issue. I've tried already the following things: Reinstall MacOS (via cmnd R) Reinstall Word Log off out of word, restart, and log on into word. Reset Office 365 on mac via Office-Reset.com Saving the file in another folder / external disk Transfering all my files to a new Mac with OS Tahoe 26.3.1 and start working from there On both Macs I'm investigating deeper what goes wrong and this is what I've noticed so far I can open a new word file, typ in it and save that file. But the moment that I start pasting things from certain (a lot but not all) other files the problems start. I can't undo previous actions anymore I can't save the file I'm working on anymore (USB / Mac / onedrive) These issues occur on both MacOS. These issues occur often when I'm pasting pictures or formulas from those certain word-files. Does anyone has any idea how to fix this? Many thanks in advance. Kind regards, Stephan
Running engagement surveys through M365 without buying another tool?
HR asked me if we can run quarterly employee engagement surveys using our existing M365 stack. We have E3 licenses. I tried setting up something with Forms but the analytics are super basic and theres no way to track trends over time or slice by department without a bunch of manual Excel work. Before I go back to HR and tell them we need to buy a dedicated survey tool, has anyone gotten something workable going with just M365?An Explosion of Audit Events for Legacy SharePoint Online Authentication
Microsoft phased out the legacy IDCRL authentication mechanism from SharePoint Online on May 1, 2026. Sounds good, until you notice the explosion of IDCRLBlockedDueToSoftEnforcement events created by SharePoint Online in the unified audit log. The events are associated with Microsoft Office apps like Word, which SharePoint appears to think are still using IDCRL. For whatever reason, the audit log is now cluttered with unwanted events generated by the interaction between SharePoint and Office. https://office365itpros.com/2026/05/07/idcrl-audit-events/
Cross Referencing Data in Excel
Hello, I have a spreadsheet that lists document numbers that are stored in a document management system. I have to cross reference the documents in that management system, which means I have to go into each individual document in the management system and add in all the documents where that individual document is referenced. The attached spreadsheet lists all the documents in our system (column B) and each document where they are referenced (columns C-AP). Is there a way to have Excel search columns C-AP, find a specific value, and provide me with a list from column B where that value is found in columns C-AP?
Adding measures in a data model at a summary level - how ?
I'm probably not going to describe this very well - but here goes 🙂 I am new to data modeling and am trying to convert old files / pivot tables to new table design/data model structures and at the same time develop some new reports for key stakeholders. The attached file has a table (I know its not optimal in terms of structure - but way better than it was). This table (called Hours_New) collects employee time daily. The time is regular, ot or unpaid. It is also chargeable or non-chargeable (as determined by the column in the table titled SC & CD Combo. There are productivity targets (50% for labourers, 75% for other trades). What I want to be able to do is report the productivity % at various levels (Foreman, Trade, Time Period etc etc etc). When I build pivot tables to try and do this I'm not able to get the results presented as I want them - I've taken a couple of stabs at it, but the results are way too busy & I want to be able to highlight when targets are being missed (on both upper and lower ends). I'm sure its not all that tough to do but I'm spinning my wheels - grrr. The attached file has multiple tabs and I've trimmed the dataset down - its actually close to 500,000 rows and removed most of the other pivot tables not related to what I'm trying to do - any help would be most appreciated !!Agent 365 adoption resources now available
We've created a Getting Started Guide for Agent 365! You can find it on our new Agent 365 Adoption Resources page, as well as links to articles for getting started with Agent 365 in Microsoft 365 Admin Center, Microsoft Defender, Entra, and Purview. Would love to hear what you think -- or what we've missed! Please leave a comment on this post. Thank you! -- Nichole Microsoft Agent 365 – Microsoft AdoptionTues, May 12: Live AMA with Agent 365 Product Team
How to Participate Register/RSVP/Add to Cal at: Live AMA: Microsoft Agent 365 | Microsoft Community Hub Visit the AMA page on Tuesday, May 12 at 9am Pacific time to join the conversation. You can post your questions in the comments, and product team members will respond live during the AMA. Live AMA: Microsoft Agent 365 | Microsoft Community HubDocuments based on template don't have correct styles
I'm sorry if this has been asked before but I've searched and either can't find an answer or can't understand the answers offered. I'm doing some contract work for an organisation and documents related to the project I'm working on are supposed to be branded in a certain way, with a consistent font and headers etc. I've been struggling with trying to keep documents to stay with this formatting and not revert to other fonts and header styles. I thought I'd figured it out by taking one of their templates and saving it as a template on my computer and then basing new documents on this template. But it's still not working. When I open the template, everything in the document looks correct, for example heading 1 shows as Avenir Book 12pt dark grey bold. If I click on that heading in the document text itself, it shows in the style box on the ribbon as heading 1. But if I take some text in the document and apply heading 1 to it, the font turns to Arial. For some reason, the styles showing in the ribbon are not the same as in the body of the template. I went back to the original template on the organisation's share point, and it seems to be a problem there as well. However, the documents on the site and in the online version of Word are actually showing as Arial and not Avenir Book at all, despite the fact that the font box says it is. There is an exclamation mark in a yellow box beside the words 'Avenir Book' though, which makes me wonder if that font's not available in their system or the online version of Word. Perhaps the designer who came up with the branding has selected an obscure font which isn't available in the organisation. Could that have resulted in the styles becoming messed up? If that is the case, can I fix it? As far as I can tell, I'm probably the only one who cares, because I notice things like font inconsistencies and I think nobody else has noticed that they are doing everything in Arial. But I would like to get things working correctly if I could.Excel .xlsm files showing “We found a problem with some content” after saving
Hi everyone, Good day. I’m currently experiencing an issue with Microsoft Excel involving macro-enabled files (.xlsm) that contain VBA code and are stored in Microsoft OneDrive. Scenario: I open an .xlsm file (with VBA), make edits or even just open and save it. When I reopen the same file, I get the error:“We found a problem with some content… Do you want us to try to recover as much as we can?” Additional details: This issue started happening on April 15, 2026. Files created in 2023 were working before, but now they are no longer working even if I did not make any changes. The issue now happens consistently even without modifying the file. What I’ve tried: Opening and repairing the file Saving as a new file Checking OneDrive sync Has anyone encountered this issue recently, especially with OneDrive syncing and .xlsm files? Any suggestions or fixes would be greatly appreciated. Thank you in advance for your help.Granular Restore for Microsoft 365 Backup Reaches General Availability
Eighteen months after the product became generally available, Microsoft 365 Backup has delivered granular restore for SharePoint Online and OneDrive sites. It’s the kind of feature that most tenant administrators might have assumed is already in the program, but at least it now is. The next step is apparently the ability to restore files in place. That isn’t available yet. https://office365itpros.com/2026/05/06/microsoft-365-backup-granular/
Can Agent 365–registered 3rd-party agents be invoked outside MS 365 clients and still track usage?
Hello, The documentation describes how to register a third-party agent with the Microsoft Agent 365 platform (for example an agent hosted on Google Cloud Run) in order to benefit from capabilities such as observability, governance, security, and centralized management. Does this mean that users must access these agents through Microsoft 365 entry points (such as Copilot Chat, Teams, or other Microsoft clients) in order for those capabilities to apply? Or can the same registered agent also be invoked and interacted with from third-party clients or external services (for example applications running in GCP) while still benefiting from Agent 365 features like observability, governance and/or security? What if third party agent is registered to Agent 365, but it doesn't use EntraID? It's what observability, governance and/or security will be available then? Thank you.
Events
Agent 365--generally available May 1, 2026--is a control plane that empowers IT admins, Security Operations analysts, Identity and Network Security admins, and Data Security & Compliance admins to ob...
Online
Recent Blogs
- May is Family Wellness Month, and with the help of Copilot, you can turn your family’s wellness goals into tailored plans and activities in seconds.May 07, 2026
- Copilot can help you bring focus to simple, everyday moments, quickly understand what’s going on, and decide what to do next.May 05, 2026
