External people can't open files with Sensitivity Label encryption.
Question: What are the best practices for ensuring external users can open files encrypted with Sensitivity Labels? Hi all. I've been investigating proper setup of sensitivity labels in Purview, and the impact on user experience. The prerequisites are simple enough, creating and configuring the labels reasonably straightforward, and publishing them is a breeze. But using them appears to be a different matter! Everything is fine for labels that don't apply encryption (control access) or when used internally. However, the problems come when labels do apply encryption and information is sent externally. The result is that we apply a label to a document, attach that document to an email, and send it externally - and the recipient says they can't open it and they get an error that their email address is not in our directory. This is because due to the encryption, the external user needs to authenticate back to our tenant, and if they're not in our tenant they obviously can't do this so the files won't open. So, back to the question above. What's the easiest / most secure / best way to add any user we might share encrypted content with to our tenant. As I see it we have the following options: Users have to request Admins add the user as a Guest in our tenant before they send the content. Let's face it, they'll not do this and/or get frustrated. Users share encrypted content directly from SharePoint / OneDrive, rather than attaching it to emails (as that would automatically add the external person as a Guest in the tenant). This will be fine in some circumstances, but won't always be appropriate (when you want to send them a point-in-time version of a doc). With good SharePoint setup, site Owners would also have to approve the share before it gets sent which could delay things. Admins add all possible domains that encrypted content might be shared with to Entra B2B Direct Connect (so the external recipient doesn't have to be our tenant). This may not be practical as you often don't know who you'll need to share with and we work with hundreds of organisations. The bigger gotcha is that the external organisation would also have to configure Entra B2B Direct Connect. Admins default Entra B2B Direct Connect to 'Allow All'. This opens up a significant attack surface and also still requires any external organisation to configure Entra B2B Direct Connect as well. I really want to make this work, but it need to be as simple as possible for the end users sharing sensitive or confidential content. And all of the above options seem to have significant down-sides. I'm really hoping someone who uses Sensitivity Labels on a day-to-day basis can provide some help or advice to share their experiences. Thanks, Oz.
Formula not working - Dynamic array for subtraction
Currently I'm facing a error with the below formulas, which is giving Error "You have entered too many Argument for this function" or simply "Zero" is coming as output. Hence requesting any SME support to fix this formula and help me to make use in my spreadsheet. Below few trouble shoots done from my end before publish my concern here: 1. I have ensured there is no blank cells or without values. 2. I'm using MS-excel 365. where few functions in the formula is compatible for my version as mentioned on the internet. Formula 1: =IF(COUNTA(BD3:BO3)<1, "", IF(LOOKUP(2,1/(BD3:BO3<>""), BD3:BO3) = LOOKUP(2,1/(BD3:BO3<>""), OFFSET(BD3:BO3, 0, -1)), LOOKUP(2,1/(BD3:BO3<>""), BD3:BO3), INDEX(BD3:BO3, 1) - SUM(FILTER(BD3:BO3, (BD3:BO3<>"") * (BD3:BO3<>OFFSET(BD3:BO3, 0, -1))))) ) Formula 2: =IF(COUNTA(BD3:BO3)<1, "", LET( LastValue, LOOKUP(2, 1/(BD3:BO3<>""), BD3:BO3), PreviousValue, LOOKUP(2, 1/(BD3:BO3<>""), OFFSET(BD3:BO3, 0, -1)), IF(LastValue = PreviousValue, LastValue, PreviousValue - LastValue) ) ) Formula Purpose Intended: To dynamically subtract the values from left to right on the last 2 non-empty cells from the given range BD3:BO3 1. Running Subtraction: Subtract values of last 2 non-empty - Last non-empty cell from the above specified range, it should subtract the last 2 non-empty cell only, whenever the range sequentially get updated with values. 2. Ignore Duplicates: If the value being a duplicate/same in the last 2 non-empty cell, then the subtraction operation should be skipped & the formula should only give the same value in the last non-empty cell. Please help me to fix this, I have tried multiple measures but still the error persist . I have attached sheet as well.
Office 365 Problems
Hello everyone, I have been experiencing the following problem since today: As soon as I try to open Excel, Word, Outlook, etc., they close again immediately. Online repair and reinstallation did not improve the situation. Some of my colleagues are experiencing the same problem. Background: We roll out updates at intervals. The users who were in the first interval are experiencing these problems. The update interval has been stopped, but unfortunately I can no longer undo the update. The following version is displayed: Version 2509 Build 16.0.19231.20138. The computers are running Windows 11 with the 24H2 update. Does anyone have the same problem or know a solution? Thanks in advance.
Proposal for automated table naming (Excel)
We are requesting the development of an automated function to apply sequential, padded naming to tables created within Excel workbooks. Problem: When using Power Query to append tables, the default naming convention (e.g., Table1, Table2) causes an incorrect append order for any table count over nine due to alphanumeric sorting. This leads to Power Query listing tables in the wrong sequence (e.g., Table1, Table10, Table2, Table3) rather than the intended order. Proposed Solutions: Automated Padding Function: Implement a function that automatically names new tables using a padded numerical format (e.g., Table_001). This would eliminate the need for manual renaming and ensure tables are consistently sorted and appended correctly. Account-Level Naming Convention: Introduce an account option that allows users to select a specified format for table names. This would provide flexibility and enable users to enforce a custom naming convention (e.g., Prefix_000) for all tables created under their account. Thank you, George Newell email address removed for privacy reasonsCopilot in Excel Turning Data Nightmares into Insights in Seconds
We’ve all been there: staring at a massive spreadsheet filled with endless rows and columns, wondering how on earth to make sense of it all. Whether it’s messy sales data, survey results, or financial reports, Excel has long been the go-to tool for taming data chaos. But even for power users, wrangling data often means hours of formulas, pivot tables, and trial and error. That’s where Copilot in Excel comes in. Think of it as having a data-savvy partner sitting right beside you—one that can instantly analyze, summarize, and visualize your data with a simple prompt. https://dellenny.com/copilot-in-excel-turning-data-nightmares-into-insights-in-seconds/Advanced Excel Formulas for Business Analysis
Microsoft Excel remains one of the most powerful tools for business analysis. Beyond simple data entry and arithmetic, Excel’s advanced formulas help analysts uncover trends, automate reporting, and drive better decision-making. Mastering these formulas can save hours of work and unlock insights hidden within raw data. In this blog, we’ll explore some of the most impactful advanced Excel formulas for business analysis, complete with practical use cases. https://dellenny.com/advanced-excel-formulas-for-business-analysis/
