Series fill a formula down a column automatically skipping a set number of rows
I am trying to fill a formula down a column every 6th row but incrementing the variable in the formula ($A2) for each entry. The formula uses the Take command and inputs 5 rows of data, so to keep it from "spilling" I need the formula to increment every 6 rows, having one blank row between each section. I have been able to accomplish "copying" it each 6th row with VBA #1 and filling the series with VBA #2 but can't figure out how to combine the two. Any help would be appreciated. VBA #1: Sub FillEvery6thCell() Dim ws As Worksheet Dim startRow As Long, lastRow As Long, col As String Dim formulaText As String Dim r As Long ' Set your sheet and parameters Set ws = ThisWorkbook.Sheets("Top 5 Employees") col = "A" ' Column to fill startRow = 10 ' First row to start filling lastRow = 60000 ' Last row to fill ' Get the formula from the starting cell formulaText = ws.Range(col & startRow).Formula ' Fill every 6th cell For r = startRow + 6 To lastRow Step 6 ws.Range(col & r).Formula = formulaText Next r Range("A2:A60000" & iRow).Replace What:="@", Replacement:="", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False, FormulaVersion:=xlReplaceFormula2 MsgBox "Formula copied to every 6th cell in column " & col End Sub VBA #2 Sub FillFormulasDown() Dim sourceCell As Range Dim fillRange As Range ' Define the cell containing the formula Set sourceCell = Range("A2") ' Define the target range Set fillRange = Range("A2:A5000") ' Fill formulas down sourceCell.AutoFill Destination:=fillRange, Type:=xlFillSeries End Sub
SKU, quota and policy restrictions on Azure for Students and Free Subscriptions
Subject: Azure for Students VM Availability Appears Inconsistent Across Students Hello everyone! We're seeing an issue across multiple cohorts using Azure for Students subscriptions, and I'm hoping someone can clarify whether there are additional restrictions being applied behind the scenes. We understand and accept the recent changes regarding: Allowed deployment regions for Azure for Students subscriptions The 4 vCPU quota limitations Regional capacity constraints We've updated our teaching materials accordingly and have troubleshooting guidance for students. However, we're observing behaviour that appears inconsistent between students with what seem to be identical subscription types. Examples: Student A can deploy several B-series VM sizes in an approved region. Student B can deploy only one VM size in the same approved region. Student C sees "Size not available" for every VM size in multiple approved regions. Student D eventually succeeds only after trying several approved regions, despite having available credit and no existing VMs. In one recent case, a student had: A Free subscription $200 credit available No deployed VMs No Allowed Regions policy visible (which made troubleshooting particularly confusing) Most regions the student tested showed one or more of the following: No available VM sizes Family quota limit messages Unsupported availability zone messages Eventually, Denmark East allowed deployment of a Standard_B2als_v2 VM, while several other regions did not. I have collected examples from multiple students and am seeing several different failure modes: Total Regional Core quota exceeded (expected and understandable) Allowed Locations policy restrictions VM size unavailable in approved regions Policy assignments showing "Not Registered" because Microsoft.PolicyInsights is not registered The challenge is that students with apparently identical Azure for Students subscriptions are not encountering the same restrictions. Has Microsoft introduced additional backend controls, SKU filtering, capacity restrictions, or subscription-specific policies that are not surfaced clearly through the Azure portal? From an educational perspective, the lack of consistency is making it difficult to provide reliable lab instructions because one student's successful deployment path may not work for another student with the same subscription type. My questions are: Are there additional backend restrictions beyond the visible Allowed Locations policy and published vCPU quotas? Is VM size availability being dynamically restricted per student subscription? Are regional capacity controls being applied differently across Azure for Students subscriptions? Is there a recommended method for identifying which regions and VM families are actually deployable for a specific student before beginning a lab exercise? Any clarification would be greatly appreciated, as we're trying to reduce classroom troubleshooting time and provide students with more reliable deployment guidance. Thank you.
May 2026 KB5089549 make my system unbootable
Today, I have updated my HP Elite X2 G4 with May 2026 Tuesday update KB5089549 and several other updates. The update fail, when restarted, an error dialog read Thing does not go as expected, and it roll back my system. After restart, I attempt to update again and it fail with the same reason. So I proceed to manual update by downloading update from Mic4osoft Update Catalog. The update went fine until I restart my system. There is an error dialog stated that my system has a problem, windows 11 attempt to repair my system and fail. This make my system unbootable. Microsoft, Windows 11 is getting worst and worst. Updating is a real nightmare. It take forever and 5his time, may be it’s time for me to switch to Mac
How come all of a sudden all of my Earbuds and Headphones skip audio?
Hi, I like to use Earbuds when on my PC, (Windows 11 Pro) I never had this issue until about 2 weeks ago. I cannot use any Earbuds or Headphones because the audio skips so badly that I miss out on the majority of what is being said, I do not know what to do. I live chatted with a Microsoft rep who then connected to my PC and didn't know what to do. So, he restored an old backup - and that worked for 1 day. Then the next day I turned my PC on and boom it was back. Does anyone know what is happening or what I can do to resolve this? I play 1 game, and when I do it's just massive skips and it is incredibly annoying. I would greatly appreciate anyone's help on resolving this please. It has become unbearable. Please help! Thank you, - JonDESIGNER only mkes 1 design not 4
I use ms ai image designer to make images and i makew ai videos ,, but for a week now it only makes 1 image not 4,, and it doesnt follow the propsat as per usual,. and it makes images in 3:2 not 16:9. I updateed my subscription for this tool and depend onm it.. SO please help me fix this
Fix for CapabilityAccessManager.db-wal Growing Huge in Windows 11
I had a problem where this file kept growing extremely fast and reached around 80 GB: C:\ProgramData\Microsoft\Windows\CapabilityAccessManager\CapabilityAccessManager.db-wal At first, stopping the Capability Access Manager Service would stop the file from growing, but it also caused Wi-Fi/network problems, so that was not the right fix. We used Microsoft Process Monitor and confirmed the file was being written by: svchost.exe → camsvc camsvc is the Capability Access Manager Service, which handles Windows app permissions like location, camera, microphone, screen capture, etc. The real trigger was not the service itself. Something was repeatedly requesting Location access, which caused camsvc to keep writing to the database WAL file. What fixed it Go to: Settings → Privacy & security → Location Turn off: Location services Also turn off: Let desktop apps access your location After doing that, the CapabilityAccessManager.db-wal file stopped growing rapidly. Small changes still happen when doing things like taking screenshots because Windows logs screen-capture permission activity. That appears normal. The problem was the runaway growth. What not to do Do not permanently disable: Capability Access Manager Service / camsvc Disabling that service can cause other Windows permission and network-related issues. Other note I also left Dell SmartByte services disabled, but the final fix was turning off Windows Location services.Event Recap - European Collab Summit 2026 - Cologne Germany
From May 5 to 7, 2026, the global Microsoft community came together in Cologne, Germany for the European Collaboration Summit 2026, a gathering of innovators, builders, and leaders shaping the future of work. With over 275 sessions spanning the European Collaboration, AI & Cloud, and BizApps Summits, Microsoft’s presence was both expansive and impactful, bringing together product leaders, engineers, and community voices to explore what’s next across Microsoft 365, Copilot, and AI-powered collaboration. ECS By the Numbers 2,800+ attendees 275+ sessions across three co-located conferences 248 speakers from 29 countries across 5 continents 58 Microsoft speakers, 11 Microsoft Regional Directors, and 106 Microsoft MVPs 51 Microsoft-led breakout sessions 3 Microsoft keynotes A Strong Microsoft Presence Across Every Track Microsoft played a central role at this year’s summit with: 3 keynote sessions 50+ Microsoft sessions across all conference tracks These sessions were delivered by product leaders, our community team, and engineering teams, providing both strategic direction and hands-on guidance for organizations navigating AI transformation. From collaboration to cloud to business applications, Microsoft content was woven throughout the event, ensuring attendees could connect insights across the entire modern work ecosystem. Key Themes: AI, Copilot, and the Era of Intelligent Work Across Microsoft’s sessions and keynotes, several core themes stood out. Copilot and AI Agents Take Center Stage From deep dives into Copilot extensibility to real-world scenarios with AI agents, sessions highlighted how organizations can move from experimentation to scale. Attendees explored how Copilot orchestrates information, integrates across Microsoft 365, and enables entirely new ways of working. Microsoft 365 as the Platform for Modern Work Sessions across Teams, SharePoint, and OneDrive reinforced how the Microsoft 365 ecosystem continues to evolve into a unified platform, connecting communication, content, and workflows with AI built in. From Productivity to Transformation Keynotes from Microsoft leaders focused on how AI is fundamentally reshaping collaboration, content, and knowledge at scale, grounded in real customer scenarios and practical adoption strategies. Microsoft Keynotes: The Evolution of Agents at Microsoft and Everywhere - Marco Casalaina, Vice President of Products, Microsoft Azure AI Marco set the stage for how Microsoft is pushing the boundaries of AI — from foundation models to production-ready AI at scale — and how organizations can harness Azure AI to drive real business outcomes. The Age of the Agent: AI That Works for You - Julie Koesmarno, Principal Group Product Manager, Microsoft Julie explored how the age of the agent is here today — how AI is moving from a tool we use to a teammate we collaborate with — with live demos by Scott Durow. The Future of AI is Already Here - Adam Harmetz, Vice President of PM, Collaborative Apps & Platforms Adam closed out the Microsoft keynote series, walking attendees through the latest in Microsoft 365 Copilot, SharePoint, OneDrive, and the broader collaboration platform — with demos by Dan Holme, Erica Toelle, and Vesa Juvonen. Breakout Sessions: Practical, Technical, and Actionable CollabSummit sessions focused on preparing organizations to fully capitalize on Microsoft 365 Copilot — from technical readiness and adoption frameworks to ROI measurement, governance, and agent extensibility. Sessions dove deep into SharePoint as the knowledge platform for Copilot and agents, OneDrive innovations, Teams as an AI-driven work hub, and the latest Microsoft 365 Copilot capabilities. AI & Cloud Summit sessions gave professionals, entrepreneurs, and businesses a chance to explore opportunities with Azure, Copilot, OpenAI, and Microsoft Foundry — with a clear focus on the impact of cloud adoption and Responsible AI. BizApps Summit sessions spotlighted the Microsoft Power Platform, Power BI, Microsoft Fabric, Dynamics 365, and citizen development — helping attendees understand how low-code/no-code business applications and unified data are accelerating enterprise transformation. Highlights included: Copilot orchestration and extensibility AI-powered collaboration experiences in Teams SharePoint agents and content management innovation Enterprise AI development and automation scenarios These sessions provided both strategic guidance and hands-on techniques, helping attendees turn emerging AI capabilities into real business impact. Microsoft MVPs and Regional Directors 106 MVPs and 11 Regional Directors led sessions, lightning talks, and Innovation Hub experiences — sharing expertise on Copilot Studio, Microsoft 365 Copilot, SharePoint, Power Platform, Azure AI, and more. Their contributions enriched the community experience and reinforced the spirit of shared learning that defines ECS. Expo City: Where Innovation Came to Life At the heart of the event, Expo City brought Microsoft technologies to life through live demos, partner solutions, and hands-on experiences across Copilot, Teams, SharePoint, and Power Platform. At the Microsoft booth, attendees experienced: A central collaboration hub for 1:1 developer conversations and architecture deep dives The Microsoft Foundry Information Tower, showcasing the Agent Factory and production-ready AI at scale The Microsoft Lounge for deeper conversations on building with Microsoft AI A digital engagement screen with live demos and platform walkthroughs A Community-Driven Experience Beyond the sessions, what truly defined the European Collaboration Summit was its community. With thousands of attendees, from IT leaders and developers to MVPs and students, the event fostered meaningful conversations, knowledge-sharing, and lasting connections. From the opening keynote to the closing ceremony, ECS 2026 thrived on the energy of its community. The atmosphere was alive with enthusiasm, collaboration, and genuine camaraderie. Evening gatherings and the attendee party at Wartesaal am Dom — a vibrant mix of fun and networking with great music and local flavors. Community Panel — “So You Want to Run a CollabDays?” presented by Rodrigo Pinto, Thomas Goelles, Paul Hunt, and Thomas Vochten, giving the community a playbook for running successful local events. Women in Tech and Allies Panel — hosted by Heather Cook with Karuana Gatimu, Laura Dark, and community members Isidora Katanic and Michelle Okwudiafor. AI Competition Finals on the FutureMakers Stage — startup finalists pitched AI-focused products live, with the winning team taking home a bronze package for ECS 2027. Citroën Ami Giveaway — one lucky attendee drove away with an actual brand-new Citroën Ami, making the closing ceremony a packed, can’t-miss Thank You A huge thank you to every attendee, speaker, sponsor, and volunteer who helped bring ECS 2026 to life. Your passion, curiosity, and commitment made this year’s event truly exceptional — and a special thanks to Adis Jugo, Mustafa Toroman, Waldek Mastykarz, Garry Trinder, Brett Lonsdale, Margit Jugo, and the outstanding teams of volunteers and sponsors who continue to make this vision a reality. Looking Ahead The European Collaboration Summit 2026 once again proved why it remains a cornerstone event for the Microsoft ecosystem. The journey continues as the team looks towards ECS 2027 in Düsseldorf, Germany — May 18–20, 2027, already shaping another year of world-class sessions, community moments, and opportunities to learn, connect, and grow. As organizations continue to navigate the shift toward AI-powered work, the insights shared across Microsoft’s sessions — from Copilot to Teams to SharePoint — offered a clear takeaway: the future of collaboration is intelligent, connected, and community-driven. Until then — keep exploring, innovating, and collaborating. The future is bright, and together we’re redefining the way the world works. #CollabSummit | #ECS2026 | Come Curious. Leave Inspired.
Start Menu Mobile Bar not showing, toggles not working
Hi, finally got the new start menu Dell xps 13 7390 2in1 but the Start Menu Mobile Bar is not showing, and none of the personalisation > start toggles work. Show recent apps Show recommended files Show mobile device at start The start menu always looks the same. I have the search box (I've seen on some screenshots that there is a small mobile icon to the right of the search box, that's not there) I then have 8 columns of apps, then a dropdown list for category, grid, and list; they all work. Any suggestions? thanksMGCI | Newsletter May 2026
Hi MGCI Members! Things are moving fast across the MGCI community, and the energy is hard to miss. From behind-the-scenes looks at what makes Community Days DC successful to global events bringing thousands together, there’s a lot happening (and a lot to be proud of). Add in new Regional Leaders on the way, upcoming sessions, and a packed event calendar, and it’s clear this community keeps leveling up. Let’s dive into what’s been happening around the world and what’s coming up next. 🌎 MGCI Regional Leader Update We’re in the final stage of selecting our 2026 MGCI Regional Leaders. New leaders will be announced early next month, followed by onboarding shortly after. Regional Leaders play a critical role in bringing Community Days and events to life around the world, and the dedication shown by this community continues to make a meaningful impact. We’re excited to welcome new leaders into this role. ✅ Recently Wrapped: MGCI Monthly General Session and Event Organizer Training (May) Microsoft Global Community Initiative General Session – May 2026 Topic: Community Spotlight: Inside M365 Community Days DC 2026 Guest Speaker: Pat McGown We went behind the scenes with Heather Cook and Pat McGown to unpack what it really takes to bring a community-driven event to life - the wins, the lessons, and the ideas you can take back to your own events. Watch the Recording: https://aka.ms/MGCI-MayGeneralSession Event Training: Event & Committee Planning - May 2026 Hosts: Wes Preston and Sharon Weaver Guest Speaker: Mark Rackley Topic: Event & Committee Planning Focused on building strong planning teams, distributing responsibilities effectively, and maintaining momentum from idea to event day - helping organizers create smoother, more inclusive events. Watch the Recording: https://aka.ms/MGCI-MayEventTraining Join the conversation & access all sessions: Live and on demand: https://aka.ms/community/learning MGCI updates & reminders: https://aka.ms/MGCISignUP Learn more about MGCI: https://aka.ms/MGCI 🌍 Recent Community Event Highlight: ECS 2026 Board Members and Regional Leaders from MGCI, as well as Microsoft peers, attended the European Collaboration Summit in Cologne, Germany. With 3,000 attendees, ECS is the largest conference in Europe focused on Modern Work, Microsoft 365, and Copilot. During the conference, Heather Cook and Karuana Gatimu shared their #CommunityLuv in multiple sessions and get-togethers. A standout moment included the Women in Tech Panel at ECS with Heather Cook, Karuana Gatimu, Laura Dark, Michelle Okwudiafor and Isidora Katanic. 🗣️ Upcoming MGCI Monthly General Sessions MGCI General Sessions take place every 3rd Tuesday of the month, with both AM and PM sessions to support our global community. In June, join Heather Cook, Principal PM, Microsoft Customer Advocacy Group, Microsoft and Stacy Burris, Event Strategy Consultant, JSB Events for a fresh take on sponsorships that go far beyond logo placement. Discover how sponsors can create meaningful connections and how event organizers can design experiences that feel authentic, engaging, and worth every dollar. Walk away with practical, community-first ideas to boost visibility, drive real results, and make sponsorships more impactful before, during, and after the event. 📅 June 16 | ⏰ 8:10 AM PT | 👉 https://aka.ms/MGCIMtgAM 📅 June 16 | ⏰ 5:10 PM PT | 👉 https://aka.ms/MGCIMtgPM 👩🏫 Upcoming Event Organizer Trainings Join the monthly Event Organizer Trainings to learn how to run successful community events, from sponsorships and speakers to logistics, registration, and post-event follow-up. Sessions are led by the community, with practical insights, tips, and best practices. Date Topic Jun 25 How to Find and Select Speakers Jul 30 FOOD! Meals, Snacks, and Beverages If you have ideas, feedback, or would like to join us as a Guest Speaker to share your event tips & tricks, complete the form here:👉 https://aka.ms/MGCI-EventOrganizerFeedback 🔴Mondays at Microsoft Join Karuana Gatimu and Heather Cook every other Monday morning to stay informed in-the-know on Microsoft’s biggest topics, including the latest in AI and what’s happening in the Microsoft community. Visit aka.ms/MondaysAtMicrosoft to watch and subscribe! 💙 #CommunityLuv Spotlight This month we're highlighting this #CommunityLuv LinkedIn Post by Dominick Raimato (Data Platform MVP & MCT). Over the past two weeks, regardless of the technology or announcements, one thing has rung true - #CommunityLuv is alive and well! Over the past two weeks I have reconnected with old friends, met new friends, and finally met some friends who I have only known virtually up until now! If you know me, I am not one to be the first to say "Hey! Let's get a picture together!" I am trying to be better about it but alas I am human. Maybe I can get an agent to help me 😂 Regardless, the names are too many to tag on LinkedIn with a single post, so here are some of the photos I thought to grab or borrowed from others! #FabCon #SQLCon #MVPsummit #MicrosoftFabric #PowerBI #RealTimeIntelligence #mvpbuzz 🏆Microsoft 365 Champions Program To help you drive adoption and increase your teamwork skills, the M365 Champions Program provides a call each month for the M365 community. Calls are held the fourth Tuesday of each month at 8:05 AM and 5:05 PM Pacific. Check out all the resources, recordings and how to sign up for the Microsoft 365 Champions Program. You must register to receive the link to join, which will be sent to you in email with your webinar registration confirmation. The registration links for both sessions are below: 8:05 AM PT: aka.ms/M365ChampionCallAM 5:05 PM PT: aka.ms/M365ChampionCallPM 🌍Upcoming Community Events Around the World Events coming up in June: Community Days | AgentCamp Oslo 2026 | June 2 | Oslo, Norway Community Days | Microsoft Build 2026 Watch Party + Unconference | June 2 | Arlington, VA, United States Community Days | Workplace Intelligence Days - 1ère édition | June 4 | Lyon, France Community Days | CollabDays Madrid 2026 | June 4 | Madrid, Spain Community Days | Memphis Microsoft Community Days | June 5 | Memphis, Tennessee, United States Community Days | Community Summit Roadshow Charlotte | June 9 | Charlotte, North Carolina, United States Community Days | Dia de la estrategia: agentes y su aplicación en la empresa | June 9 | Mexico City, Mexico Community Days | Power BI Days DC | June 11-12 | Arlington, Virginia, United States Community Days | CollabDays Poland 2026 | June 11-12 | Warsaw, Poland Community Days | CollabDays Netherlands 2026 | June 13 | Utrecht, The Netherlands Community Days | POSETTE: An Event for Postgres 2026 | June 16-18 | Virtual - PDT Community Days | AI Community Days (AICD) Montréal 2026 | June 17-18 | Montreal, Canada Community Days | Africa Power Platform | June 20-21 | Cotonou, Benin Community Days | AI Community Days (AICD) Québec 2026 | June 22-23 | Quebec, Canada Community Days | MWCP 2026 | June 23-24 | Île-de-France, France Community Days | Community Summit Roadshow Pittsburgh | June 23 | Pittsburgh, Pennsylvania, United States Community Days | Community Summit Roadshow Cleveland | June 25 | Twinsburgh, Ohio, United States Community Days | AI Community Conference - New York | June 26 | New York, New York, United States Community Days | Global Fabric Community Tunisia | June 27 | Tunis, Tunisia Community Days | CollabDays Hamburg 2026 | June 27 | Hamburg, Germany Check out https://aka.ms/CommunityDays.Org for events happening in communities around the world. You can filter on region, scout open Call for Speakers, find events that are looking for sponsorships, and discover community-driven events and conferences. Closing From city to city and continent to continent, the MGCI community continues to raise the bar. New ideas, stronger events, and deeper connections are happening every day and it’s all driven by this incredible network of organizers and leaders. Keep building. Keep sharing. Keep showing what #CommunityLuv looks like in action. See you out there. 🧡 Sincerely, Your Board Officers 🕯️Special: Rest in Peace Nicki Borell, Microsoft MVP Germany The Global Community shares our deep condolences to Nicki's family, friends, loved ones, colleagues, and everyone in our community who knew Nicki. Nicki was a very active speaker at well-known community events such as ESPC, ECS and many others. We are thankful and grateful for all his contributions in our community. Rest in Peace dear Nicki🙏💙
All shortcuts icons turn blank (white) in Windows 11
I turned my PC a while ago and all shortcut icons have been turned blank. I cleared the shortcut cache by deleting the IconCache.db file. Nothing Run sfc /scannow with no errors. Nothing When I change it again nothing happens, it remains blank. The last update that may cause the problem was installed the last time I turned off my computer (2026-04 Security Update (KB5083769) (26200.8246). I uninstalled it but the problem remained. Creating a new local account didn't solve the problem either. Please advise. Thank you
