How to Be an Excel Detective: Finding and Highlighting Formulas
Hi everyone, I recently wrote a blog post on some simple, yet powerful, techniques for anyone who works with Excel spreadsheets, especially those with complex data. I wanted to share a summary of it with this community, as it might be helpful to others who are looking to understand and protect their work. The post covers two main things: Quickly Revealing All Formulas: A simple keyboard shortcut (Ctrl + `) or the "Show Formulas" option can instantly reveal all formulas in a worksheet. This is a great way to quickly see how a spreadsheet is structured. Permanently Highlighting Formulas: The article shows how to use the "Find & Select" > "Formulas" feature to select all cells containing formulas and then permanently highlight them with a fill color. This visual cue can help prevent accidental edits and protect your data. Watch This in Action: For a step-by-step guide on how to use these techniques, you can watch the video on my https://www.youtube.com/@BIGurus. 🔗 https://youtu.be/1x-1dbqlWXk You can also read the full article here: https://medium.com/@anandsharad/how-to-be-an-excel-detective-finding-and-highlighting-formulas-fe9d4fdbc1b1 I'd be happy to answer any questions you have or discuss other Excel tips and tricks in the comments!A new Project Online Content Pack for Power BI
We are pleased to announce the release of a new Project Online Content Pack for Power BI. Starting October 26 2017, Project Online users will be able to download the new content pack directly from AppSource: https://app.powerbi.com/groups/me/getdata/services/project-online Comprising of 13 visually rich report pages, the new content pack is designed to support the management needs of project managers, portfolio managers and resource managers, by retrieving planning and execution data from Project Online and arranging the data to support timely decision making. The new content pack report includes reports in three key perspectives: Individual Projects, Portfolio of projects and the organization’s resources. Each perspective encompasses the following detailed report pages.Partner Know Before You Go to the 2025 European Microsoft Fabric Community Conference!
We can’t wait to see you at FabCon Europe 2025, taking place 15-18 September at the Austria Center Vienna in Vienna, Austria! With more than 130 expert-led sessions over three days, plus workshops 15 September, this is the largest Microsoft tech conference in Europe! Our team has been hard at work planning several partner-exclusive activities throughout the event, to help ensure the best experience possible for you, our valued partners. This Know Before You Go guide will provide all the details on how to participate in: Partner Day Partner Happy Hour 1:1 Meetings Partner Booth at Ask the Experts Partner AMA Partner Photo Scavenger Hunt Cvent Event App If you have any questions, please feel free to reach out to our team at mailto:FabricPartnersTeam@microsoft.com or through the Cvent app. See you very soon! Complete details and entry form are available at https://aka.ms/FabConEuropePartnerPhotoHunt.Join the Fabric Partner Community for an AMA with Arun Ulag!
🚨 Mark your calendars now! 📅 New this year in the Fabric Partner Community, an AMA (Ask Me Anything) call series with members of the Fabric Leadership Team! 🥳 Arun Ulag, CVP of Azure Data, will kick of this new call series Thursday, September 25, from 8-9 am PT. You will not want to miss this opportunity to ask all your questions, including those related to the announcements made at #FabConEurope, provide your feedback, and more! 👏 To join theses calls, you must be a member of the Fabric Partner Community Teams Channel. Not yet part of the Fabric Partner Community? Join now by submitting the form at https://aka.ms/JoinFabricPartnerCommunity.Join the Fabric Partner Community for this Week's Fabric Engineering Connection calls!
Are you a Microsoft partner that is interested in data and analytics? Be sure to join us for this week's Fabric Engineering Connection calls! 🎉 Jia Ma will be providing a deep dive on Real-Time Hub and Jenny Jiang will be sharing the latest monitoring updates for Spark jobs. The Americas & EMEA call will take place Wednesday, September 10, from 8-9 am PT and the APAC call is Thursday, September 11, from 1-2 am UTC/Wednesday, September 10, from 5-6 pm PT. This is your opportunity to learn more, ask questions, and provide feedback. To join the call, you must be a member of the Fabric Partner Community Teams channel. To join, complete the participation form at https://aka.ms/JoinFabricPartnerCommunity. We look forward to seeing you next week!Understanding the Microsoft MVP Program: Seeking Clear Guidance
Hello everyone, I’d like to start a discussion about the Microsoft Most Valuable Professional (MVP) Program. My main concern is understanding the process of becoming an MVP and the specific requirements involved. I know the program recognizes exceptional community leaders and experts who share their knowledge and support others, but the actual path to nomination and selection seems a bit unclear. Could anyone share clear guidance on the eligibility criteria, the nomination process, the types of contributions that are most valued, and practical tips to strengthen an application? Your insights and experiences would be highly valuable, not just to me but also to others in the community who may be interested in pursuing this recognition. Thank you so much for your attention and participation.
Microsoft In a Day (XIAD) Partner Events Program - Train the Trainer Events (DIAD/FAIAD/RTIAD)
We invite you to attend an upcoming Train the Trainer session for Microsoft Partners to learn more about the Microsoft In a Day (XIAD) Partner Events Programand how to lead workshops that empower customers to use and adopt Microsoft products. Our Train the Trainer events are designed to provide you with the knowledge and tools necessary to deliver successful Microsoft In a Day (XIAD) sessions. ✨ Why Attend? Hands-On Experience: Participate in labs and demos just like customers will. Expert Guidance: Learn from experienced trainers and get your questions answered. Comprehensive Resources: Access all the content and support you need to succeed. 📅 Upcoming Events: Dashboard in a Day This is a one-day, hands-on workshop for business analysts, covering the breadth of Power BI capabilities. Currently available on-demand. Inquire at xiadevents@microsoft.com Fabric Analyst in a Day This is an intermediate-level training designed for Power BI Data Analysts who have at least one year of experience on Power BI but are new to Microsoft Fabric. August 22, 2025 (CET - EMEA) : Fabric Analyst in a Day August 29, 2025 (CET - EMEA) : Fabric Analyst in a Day September 22, 2025 (CST - AMERICAS) : Fabric Analyst in a Day Real-Time Intelligence in a Day This is an intermediate-level training designed for Power BI developers looking to extract insights and visualize streaming and time sensitive data. August 15, 2025 (CET - EMEA) : Real-Time Intelligence in a Day September 12, 2025 (CST - AMERICAS): Real-Time Intelligence in a Day Once registered, look for your registration confirmation email from notification@msftevents.microsoft.com that contains your unique Teams meeting link to join the virtual event. Be sure to check spam and junk folders, and mark as a safe sender. If you are unable to locate your registration confirmation, email pappspartnerevents@microsoft.com. We look forward to seeing you at an upcoming event! Partner with us! Are you a Microsoft Partner interested in the opportunity to join the program and deliver Microsoft In a Day (XIAD) events? 🔍 Learn more about the program and review partner eligibility criteria: https://aka.ms/xiadpartneropportunity. 📧 Contact the XIAD Program team: xiadevents@microsoft.com 📤 Submit requests to deliver events: https://aka.ms/xIAD/PartnerEvents
OLAP connection Open XML adds x: namespace which is preventing slicer to work
I serialise the excel workbook with C# OpenXml to dynamically change the connection.xml file so users can connect to olap cube tabular in pbi. So I programmatically set a connection string for the user this way. All was working fine until the user started to insert slicers to the pivot table. I noticed in the connection.xml the connections xml tag has x: namespace added by OpenXml. eg <x:connection></x:connection> According to doco "When the object is serialized out as xml, it's qualified name is x:connection." https://learn.microsoft.com/en-us/dotnet/api/documentformat.openxml.spreadsheet.connection?view=openxml-3.0.1 Once I removed these x: namespace from the connection xml tag slicers worked. <connections><connection></connection></connections> Is this a bug in excel ? Are there plans to fix this? OpenXml is a lib provided by Microsoft and adds the x: namespace and excel cant handle the namespace, Reporting this bug and to see when a bug fix will be release for excel to use slicers when you dynamically change the connection string using openxml. Thanks
