Word/PowerPoint are not suitable replacements for Publisher
I’m writing following the guidance that Word and PowerPoint can be used as replacements for Publisher. This feedback is based on completing a real production document, not theoretical use Having just completed a fairly complex, layout-heavy technical document, I thought it only fair to share how that works in practice. In theory, I can see the logic: Word handles documents PowerPoint handles layouts Therefore, between the two, everything should be covered Unfortunately, in reality, this appears to be more of a theoretical exercise than a practical solution. Publisher was clearly designed for: Fixed, page-based layouts Precise positioning of objects Efficient alignment of mixed content (text, images, tables) Producing consistent, professional multi-page documents By comparison: Word is admirably committed to reminding you that it would prefer everything to flow freely, regardless of whether you want it to or not PowerPoint, while better behaved, does seem to assume every page is a standalone slide rather than part of a structured document Both tools can, with enough persistence, be persuaded into doing the job. However, this involves a level of manual intervention, workaround, and general negotiation with the software that feels somewhat at odds with modern productivity software. To put it simply: They are not replacements in any meaningful, real-world sense. The end result can be achieved, but the process is unnecessarily time-consuming, fragile, and prone to unexpected layout changes—particularly when precision actually matters. Replacing a purpose-built publishing tool with two applications that were never designed for that role gives the impression that this use case has been… optimistically simplified. I would strongly encourage Microsoft to either: Provide a genuine page-layout solution within the Office suite, or Enhance existing applications so they can support fixed-layout publishing without constant workarounds At present, the gap left by Publisher is very noticeable for anyone producing structured documents beyond basic text. I appreciate the direction of Microsoft 365 overall, but in this particular area, the experience feels less like an evolution and more like working around a missing tool. Regards Andy
Optimizing Microsoft 365 Licenses Using Behavior Data (E3/E1/F3)
Hi everyone, We are currently working on a Microsoft 365 license optimization initiative and would appreciate insights from the community and Microsoft experts. Our approach focuses on two main areas: (1) Revoking licenses for inactive users, and (2) Reviewing active users to ensure their assigned license (E3, E1, or F3) aligns with actual usage and collaboration needs. From a data perspective, we are leveraging Microsoft 365 usage signals such as Teams activity, Outlook email interactions, meetings, and SharePoint/OneDrive collaboration. While usage reports provide raw metrics, we are looking for guidance on how these signals should be interpreted and combined in a meaningful and fair way. Specifically, we would like to understand: (1) Which usage metrics best represent user collaboration behavior? (2) Are there any recommended thresholds or patterns that help distinguish light, standard, and heavy collaboration users to map E3, E1, or F3? Any best practices, references, or real-world experiences would be greatly appreciated. I'm sorry if this is the wrong forums to ask for. Thanks in advance for sharing your insights.
Power Apps + Excel Online: RFC 3339 Date/DateTime Format Error When Patching to Excel Date Columns
Hi everyone, I need help with a Power Apps canvas app connected to an Excel workbook stored in SharePoint/OneDrive. The app is a warehouse inventory system using Excel tables as the data source. The app has these Excel tables: tblSKU tblLocation tblInventory tblTransactions The main issue is with date fields when using Patch() from Power Apps to Excel. Error Message I keep encountering this error: Expected value "" to be valid RFC 3339 'date-time' format. Allowed ISO 8601 format(s): 'YYYY-MM-DDThh:mm:ssZ', 'YYYY-MM-DDThh:mm:ss+hh:mm', 'YYYY-MM-DDThh:mm:ss'. This happens during receiving / issuing / stock count transactions when patching to Excel. Date Columns Involved In tblTransactions, I have: DateTime TransDate ProductionDate ExpiryDate In tblInventory, I have: ProductionDate ExpiryDate LastUpdated These columns are formatted in Excel as Date or Date/Time. Current Patch Logic I already changed my formulas to stop saving formatted text like this: DateTime: Text(Now(), "dd mmm yyyy") TransDate: Text(Today(), "dd mmm yyyy") ProductionDate: Text(dpProductionDate.SelectedDate, "yyyy-mm-dd") ExpiryDate: "" Now I am trying to patch real date values instead: DateTime: Now(), TransDate: Today(), ProductionDate: If( IsBlank(dpProductionDate.SelectedDate), Blank(), dpProductionDate.SelectedDate ), ExpiryDate: If( IsBlank(varExpiryDate), Blank(), varExpiryDate ), LastUpdated: Now() However, I still sometimes get the RFC 3339 error. Sample Receiving Patch Here is the relevant part of my receiving button: Patch( tblTransactions, Defaults(tblTransactions), { TransID: Text(GUID()), DateTime: Now(), TransDate: Today(), Type: "RECEIVE", SKU: varSKU.SKU, Barcode: varBarcode, Description: varSKU.Description, Category: varSKU.Category, UOM: varSKU.UOM, LotNo: Upper(txtLot.Text), ProductionDate: If( IsBlank(dpProductionDate.SelectedDate), Blank(), dpProductionDate.SelectedDate ), ExpiryDate: If( IsBlank(varExpiryDate), Blank(), varExpiryDate ), Location: drpLocation.Selected.LocationCode, Qty: Text(Value(txtQty.Text)), User: User().FullName, Status: "POSTED", Remarks: "" } ) Expiry Date Calculation The expiry date is calculated based on SKU shelf life: Set( varShelfLifeDays, IfError( Value(varSKU.ShelfLifeDays), 0 ) ); Set( varExpiryDate, If( varShelfLifeDays > 0, DateAdd( dpProductionDate.SelectedDate, varShelfLifeDays, TimeUnit.Days ), Blank() ) ); Related Issue In galleries and labels, Excel sometimes returns date values as serial numbers, for example: 46192 So I had to use formulas like: Text( DateAdd( Date(1899,12,30), Value(Text(ThisItem.ExpiryDate)), TimeUnit.Days ), "dd mmm yy" ) This works for display, but I am still unsure about the correct way to patch date/date-time values back to Excel. Any guidance would be very much appreciated. Thank you.
Word for iPad cannot edit documents marked as “Recommended Reading” in Windows
I have a Word document created in Windows that was saved with the “Recommended Reading” option. When I open it in Word for iPad, the file is locked in reading mode and there is no option to switch to editing mode. Word Online can edit the document without any issues, so it seems that the limitation affects only the Word app for iPad. This appears to be a recent limitation, since the document could be edited without any issues a couple of months ago. Is this a known limitation in Word for iPad? Is there any way to remove this flag from the iPad or force editing mode without having to return to Windows? Thank you.
How do you roll up individual goals into department or company goals in M365?
We’re trying to manage goals across teams using Microsoft 365, but the structure gets messy fast. Individual goals live in different places, and it’s hard to see how they connect to department or company-level objectives. With Viva Goals out of the picture, has anyone built a clean way to roll up goals in M365, or is this something better handled with a dedicated OKR/performance tool? (I honestly wouldnt want to use something third party and much rather keep things in MS 365)
Best way to run pulse surveys inside Teams?
I’m looking for a lightweight way to run recurring pulse surveys directly in Teams. Forms works fine for basic questions, but follow-up, reminders, anonymity, and reporting become manual pretty quickly. Curious what others are using for short employee check-ins or sentiment surveys inside the Microsoft ecosystem. Or am I not using Forms to its full potential?
Employee performance management tools in Microsoft 365?
So we are a relatively large organization and in drastic move, we've decided to shift from Google Workspace to Microsoft, primarily centering our employees around Microsoft Teams while trying to encourage them to use Copilot as effectively as possible. In this transition, one of the platforms we will be saying goodbye to will be our performance management software. Are there any Microsoft native performance management tools that can help us go through goal-setting, performance reviews, and feedback? Third party suggestions would also be good but only if they fit into the whole Microsoft workflow well.
PowerPoint NEW Image Editing Tools Explained — Remove Background, Upscale & Edit Images Instantly!
🚀 PowerPoint just received one of its most powerful updates ever! Microsoft has introduced a brand‑new built‑in image editing experience, allowing you to enhance visuals without leaving PowerPoint. In my latest YouTube video, I walk through all the new capabilities now rolling out in Microsoft 365, including: ✨ Remove background 🧽 Erase unwanted objects 🔄 Move elements inside an image 🔍 Upscale low‑resolution pictures ⚡ Auto‑enhance lighting & contrast 📝 Add or edit text directly on images All of this happens directly inside PowerPoint, making slide creation faster and more intuitive than ever. These features are now available on: 💻 Windows 🍎 Mac 🌐 PowerPoint for the Web If you work with presentations daily, this update is a real productivity boost. 📹 Watch the full breakdown and demo here ➡️ https://youtu.be/OZzfFi2qpAk Let me know what feature you find the most useful! 👇 #Microsoft365 #PowerPoint #Productivity #AI #Presentations #Microsoft365Insider #Creators
