Category: Microsoft
Category Archives: Microsoft
Insert Blank Row between Filters using VSTACK
I have a working VSTACK formula with 2 filters. I would like to insert a blank row or even a copied header row between the two filter in order to separate the data visually on the combined sheet.
Here is the current formula:
=VSTACK(FILTER(‘AV POWER Overall’!A3:K200,’AV POWER Overall’!K3:K200=’TA00-A101′!N2),FILTER(‘LX POWER Overall’!A3:K200,’LX POWER Overall’!K3:K200=’TA00-A101′!N2))
Screenshot is the combined sheet.
I have a working VSTACK formula with 2 filters. I would like to insert a blank row or even a copied header row between the two filter in order to separate the data visually on the combined sheet. Here is the current formula:=VSTACK(FILTER(‘AV POWER Overall’!A3:K200,’AV POWER Overall’!K3:K200=’TA00-A101′!N2),FILTER(‘LX POWER Overall’!A3:K200,’LX POWER Overall’!K3:K200=’TA00-A101′!N2)) Screenshot is the combined sheet. Read More
Error in pivot table values
Hello. I exported some data from Power BI to excel to analyze. I want dates on the rows, and the other fields for values. When I try to drag the fields to values, I only get an error message as shown under. Hope somebody could help.
Hello. I exported some data from Power BI to excel to analyze. I want dates on the rows, and the other fields for values. When I try to drag the fields to values, I only get an error message as shown under. Hope somebody could help. Read More
template
Hi,
Anyone shares an Open-To-Buy template for retail congaing basic fields like:
A Top-Down Version: with following rows of information for input
Actual Revenue Spot CoverageForward CoverageOpening StockClosing StockPurchaseOpen to buy retail valueMargin %
Hi,Anyone shares an Open-To-Buy template for retail congaing basic fields like:A Top-Down Version: with following rows of information for inputActual Revenue Spot CoverageForward CoverageOpening StockClosing StockPurchaseOpen to buy retail valueMargin % Read More
OneDrive for Business Plan 2 Sync vs Location limits
Need to clarify “OneDrive for Business Plan 2” and it’s limits.
25 TB total storage?
30 million items. Is this correct?
Sync no more than 300,000 items.
– This 300,000 sync limit, is it per Location or all locations added together in one account?
See my screen shot for an example.
One account that has three Locations syncing. One of the current locations has 250,000 items syncing. Am I able to add a fourth Location that has another 250,000 items?
Need to clarify “OneDrive for Business Plan 2” and it’s limits. 25 TB total storage?30 million items. Is this correct?Sync no more than 300,000 items.- This 300,000 sync limit, is it per Location or all locations added together in one account?See my screen shot for an example. One account that has three Locations syncing. One of the current locations has 250,000 items syncing. Am I able to add a fourth Location that has another 250,000 items? Read More
Integrating Project, Project on the Web, Roadmap, Planner and Power BI with SharePoint
Has anyone successfully integrated Project, Project for the Web, Roadmap, Planner, and Power BI with SharePoint? I’m particularly interested in:
Sharing best practices and lessons learned.Understanding the best approach to link a data table from Excel to both a Microsoft Project Web App template and a SharePoint site.
Additionally, any insights into the frequency of data refresh between these tools would be appreciated.
Has anyone successfully integrated Project, Project for the Web, Roadmap, Planner, and Power BI with SharePoint? I’m particularly interested in:Sharing best practices and lessons learned.Understanding the best approach to link a data table from Excel to both a Microsoft Project Web App template and a SharePoint site.Additionally, any insights into the frequency of data refresh between these tools would be appreciated. Read More
Identifying AVD customers tenants with Azure lighthouse
Hello,
We have onboarded customer through Azure lighthouse and I wonder if there is a way to identify customer’s tenants with Azure virtual desktop deployments. Is it possible to run a graph query in Azure graph explorer and get a list of customers in bulk, who use AVD? Suggestions and recommendations are welcomed and thank you in advance!
Regards,
Anna
Hello,We have onboarded customer through Azure lighthouse and I wonder if there is a way to identify customer’s tenants with Azure virtual desktop deployments. Is it possible to run a graph query in Azure graph explorer and get a list of customers in bulk, who use AVD? Suggestions and recommendations are welcomed and thank you in advance!Regards,Anna Read More
Pull down and sheet number increase and cell stay the same
I would like to be able to drag down and the cel stay the same and the sheet number to increase.
At the moment I use the formula
=sheet1!$G$7
I would like to drag it down and the cell G7 stay the same but in the box below I need the next sheet. I’m having to pull it down and change the sheet number on every cell. Very time consuming 🙁
Any help will be appreciated
I would like to be able to drag down and the cel stay the same and the sheet number to increase.At the moment I use the formula=sheet1!$G$7I would like to drag it down and the cell G7 stay the same but in the box below I need the next sheet. I’m having to pull it down and change the sheet number on every cell. Very time consuming 🙁 Any help will be appreciated Read More
Azure Communication Services at the European Cloud and Collaboration Summits
We are gearing up for the European Cloud and Collaboration Summit next week from May 14 -16 in Wiesbaden, Germany with four engaging sessions for our developer audience. These conferences are premier events to learn about Microsoft technologies including Azure, Microsoft Teams, and Power Platform and offer an excellent opportunity to network with the community and Microsoft experts. We look forward to connecting with you if you plan to attend either of these conferences.
Please find below the details of Azure Communication Services sessions. Don’t forget to add them to your agenda.
Build your custom copilot on Azure
May 15, 4:20 PM CEST | By Tomas Chladek
Learn how to build a custom copilot grounded in your data and your unique scenario using the preferred messaging channels be it Voice, Video, or messaging. We’ll cover how to use Azure services to build a pro-code copilot on voice. You can use this knowledge to apply the same process in other communication channels.
AI powered customer communications
May 16, 1:30 PM CEST | By Tomas Chladek
Experience the future of customer interaction with Azure Communication Services and Azure OpenAI Services. Are you using a traditional one-size fits-all Interactive Voice Response (IVR) and chatbot? Tomas Chladek describes how to use Azure to elevate, automate, and transform your customer interactions with AI.
Event Driven Development with Azure Communication Services
May 16, 1:30 PM CEST | By Tom Morgan (MVP)
Azure Communication Services supports Azure Event Grid, meaning it can be used for event-driven development. What does that mean and how is it different from traditional software development?
Join Microsoft MVP Tom Morgan to unpack how event-driven development can help you create scalable robust solutions, using events as examples. We’ll build out a solution during the session to demonstrate how complex scenarios can be broken down into easy-to-understand components. Live demo with audience-participation at the end!
Unleash the power of Azure Communication Services and Microsoft Teams!
May 15, 2:00 PM CEST | By Tom Morgan (MVP)
Have you ever wanted a game-changing solution that simplifies complex communication tasks like voice, video, and desktop sharing? Look no further! Azure Communication Services is here to revolutionize the way developers approach these challenges.
Imagine embedding advanced capabilities into your line of business applications, creating personalized customer video portals, or even having IVRs that use cutting-edge Azure OpenAI speech technologies. Azure Communication Services also seamlessly integrates with your existing Microsoft Teams deployment, taking collaboration to a whole new level.
About our speakers
Tomas Chladek is a Senior Product Manager at Azure Communication Services, Microsoft.
LinkedIn.
Tom Morgan is a Microsoft 365 Develpment Architect and Microsoft MVP. LinkedIn.
Microsoft Tech Community – Latest Blogs –Read More
“The Future of AI” Upcoming hybrid meeting with Microsoft Texas Client Director on panel!
You’re invited to join us in-person or virtually on May 23!
IAMCP (International Association of Microsoft Channel Partners) TOLA Chapter (Texas, Oklahoma, Louisiana, Arkansas) rotates monthly and hosts chapter meetings in Austin, Houston and Dallas. All meetings are hybrid and anyone is welcome to attend, no matter where you are!
Our May 23rd meeting:
The Future of AI and Its Impact on Your Organization
Artificial intelligence (AI) will change every aspect of digital work in the coming decade. AI’s reach will proliferate in your organization and those of your partners, customers, and rivals, thanks to continued advances in hardware, software, analytics, and the ability to scale these changes.
Join IAMCP for an interactive panel discussion with key business leaders to explore how their respective organizations are using or planning to use AI to advance and improve organization productivity. You will get the opportunity to interact with our panel and discuss the impact of planning, budgeting, and challenges of AI implementation.
Our Panel:
Stephen Elkins – Texas Client Director – MicrosoftRicardo Blanco – Deputy Executive Commissioner for IT and Chief Information Officer at Texas Health and Human ServicesTim Weinheimer – Chief Innovations Officer at Hahn Labs
Join us online or in-person (lunch included) in Austin at the Microsoft office –
10900 Stonelake Blvd., Suite B-225
Austin, TX 78759
11:30am-1:00pm CST
Not a member of IAMCP? You can still attend for $30 or, as a new member, join for $1 for your first 90 days!
I myself have been a member of IAMCP for about 2+ years and I’m the Secretary of the Houston chapter. There are plenty of other virtual meetings every month covering all topics concerning partners. It’s a great way to understand the ecosystem, how to gain designations and credentials, and find partner to partner opportunities.
You’re invited to join us in-person or virtually on May 23! IAMCP (International Association of Microsoft Channel Partners) TOLA Chapter (Texas, Oklahoma, Louisiana, Arkansas) rotates monthly and hosts chapter meetings in Austin, Houston and Dallas. All meetings are hybrid and anyone is welcome to attend, no matter where you are! Our May 23rd meeting:The Future of AI and Its Impact on Your OrganizationArtificial intelligence (AI) will change every aspect of digital work in the coming decade. AI’s reach will proliferate in your organization and those of your partners, customers, and rivals, thanks to continued advances in hardware, software, analytics, and the ability to scale these changes.Join IAMCP for an interactive panel discussion with key business leaders to explore how their respective organizations are using or planning to use AI to advance and improve organization productivity. You will get the opportunity to interact with our panel and discuss the impact of planning, budgeting, and challenges of AI implementation. Our Panel:Stephen Elkins – Texas Client Director – MicrosoftRicardo Blanco – Deputy Executive Commissioner for IT and Chief Information Officer at Texas Health and Human ServicesTim Weinheimer – Chief Innovations Officer at Hahn Labs Join us online or in-person (lunch included) in Austin at the Microsoft office – 10900 Stonelake Blvd., Suite B-225Austin, TX 7875911:30am-1:00pm CST Register Here > Not a member of IAMCP? You can still attend for $30 or, as a new member, join for $1 for your first 90 days! I myself have been a member of IAMCP for about 2+ years and I’m the Secretary of the Houston chapter. There are plenty of other virtual meetings every month covering all topics concerning partners. It’s a great way to understand the ecosystem, how to gain designations and credentials, and find partner to partner opportunities. Read More
IAMCP TOLA’s Chapter is talking AI with Microsoft in Austin (or virtually) May 23rd!
You’re invited to join us in-person or virtually on May 23!
IAMCP‘s TOLA Chapter (Texas, Oklahoma, Louisiana, Arkansas) rotates monthly and hosts chapter meetings in Austin, Houston and Dallas. All meetings are hybrid and anyone is welcome to attend, no matter where you are!
Our May 23rd meeting:
The Future of AI and Its Impact on Your Organization
Artificial intelligence (AI) will change every aspect of digital work in the coming decade. AI’s reach will proliferate in your organization and those of your partners, customers, and rivals, thanks to continued advances in hardware, software, analytics, and the ability to scale these changes.
Join IAMCP for an interactive panel discussion with key business leaders to explore how their respective organizations are using or planning to use AI to advance and improve organization productivity. You will get the opportunity to interact with our panel and discuss the impact of planning, budgeting, and challenges of AI implementation.
Our Panel:
Stephen Elkins – Texas Client Director – MicrosoftRicardo Blanco – Deputy Executive Commissioner for IT and Chief Information Officer at Texas Health and Human ServicesTim Weinheimer – Chief Innovations Officer at Hahn Labs
Join us online or in-person (lunch included) in Austin at the Microsoft office –
10900 Stonelake Blvd., Suite B-225
Austin, TX 78759
11:30am-1:00pm CST
You’re invited to join us in-person or virtually on May 23! IAMCP’s TOLA Chapter (Texas, Oklahoma, Louisiana, Arkansas) rotates monthly and hosts chapter meetings in Austin, Houston and Dallas. All meetings are hybrid and anyone is welcome to attend, no matter where you are! Our May 23rd meeting:The Future of AI and Its Impact on Your OrganizationArtificial intelligence (AI) will change every aspect of digital work in the coming decade. AI’s reach will proliferate in your organization and those of your partners, customers, and rivals, thanks to continued advances in hardware, software, analytics, and the ability to scale these changes.Join IAMCP for an interactive panel discussion with key business leaders to explore how their respective organizations are using or planning to use AI to advance and improve organization productivity. You will get the opportunity to interact with our panel and discuss the impact of planning, budgeting, and challenges of AI implementation. Our Panel:Stephen Elkins – Texas Client Director – MicrosoftRicardo Blanco – Deputy Executive Commissioner for IT and Chief Information Officer at Texas Health and Human ServicesTim Weinheimer – Chief Innovations Officer at Hahn Labs Join us online or in-person (lunch included) in Austin at the Microsoft office – 10900 Stonelake Blvd., Suite B-225Austin, TX 7875911:30am-1:00pm CST Register Here > Read More
Allow Sensitive Data Inbound
My Outbound PII DLP policies for Exchange are also blocking users from receiving PII data from External senders. A Policy Tip in extrernal senders Outlook displays “The following recipients aren’t authorized to receive this type of information.”
We have 100’s of users who receive PII data across all of our business units. Do I really need to define everyone who will need to receive this data? Frankly, from an organization perspective, we are not interested who can receive it, just who can send it out.
My Outbound PII DLP policies for Exchange are also blocking users from receiving PII data from External senders. A Policy Tip in extrernal senders Outlook displays “The following recipients aren’t authorized to receive this type of information.”We have 100’s of users who receive PII data across all of our business units. Do I really need to define everyone who will need to receive this data? Frankly, from an organization perspective, we are not interested who can receive it, just who can send it out. Read More
Error – Something went wrong. [1001]
Hello, I am a 365 client for a few years. Today out of nowhere I was asked to log in to my account. When I attempt to do so, this is the error message:
******************************************************
Error
Something went wrong. [1001]
Correlation Id: 81f04800-4268-44e4-b1c2-2f758659651a
Timestamp: 2024-05-10T14:25:03.000Z
DPTI: 01080ae9bf8da57cba51e6e1c62e24077158eb66d301ccb2f46fd0e8fbb147a7
Error Tag: 7q6ca
Error Code: 2147483661
*******************************************************************
This has never happened before, and can log into my account via https://www.office.com. But when I try to use the actual apps on my desktop it will not work, and kicks back the same error message for all the apps. I have seen other posts about this, but I am not conformable trying to change code and registry values. I need support from a MS professional, please advise as this is an acute issue.
Thank you in advance for your attention – Steve
Hello, I am a 365 client for a few years. Today out of nowhere I was asked to log in to my account. When I attempt to do so, this is the error message: ******************************************************ErrorSomething went wrong. [1001]Correlation Id: 81f04800-4268-44e4-b1c2-2f758659651aTimestamp: 2024-05-10T14:25:03.000ZDPTI: 01080ae9bf8da57cba51e6e1c62e24077158eb66d301ccb2f46fd0e8fbb147a7Error Tag: 7q6caError Code: 2147483661 *******************************************************************This has never happened before, and can log into my account via https://www.office.com. But when I try to use the actual apps on my desktop it will not work, and kicks back the same error message for all the apps. I have seen other posts about this, but I am not conformable trying to change code and registry values. I need support from a MS professional, please advise as this is an acute issue. Thank you in advance for your attention – Steve Read More
How to implement a calculated column using ‘Created’ column and ‘Status Update’ column
I am attempting to add a calculated column that will calculate the difference in time between when a form is submitted (shown in a column titled ‘created’) and when a column titled ‘status’ is marked as ‘done’.
I am attempting to add a calculated column that will calculate the difference in time between when a form is submitted (shown in a column titled ‘created’) and when a column titled ‘status’ is marked as ‘done’. Read More
How do I disable the “reschedule” feature that is automatically sent to customers after using bookin
I want our Bookings page to be something for internal use, I like the automatic emails but I do not want the customer to be able to manage their own appointment. How do I disable this option but still keep the emails going out?
I want our Bookings page to be something for internal use, I like the automatic emails but I do not want the customer to be able to manage their own appointment. How do I disable this option but still keep the emails going out? Read More
Action in spreadsheet I can’t remember how to do
Several years ago I created a workbook under an older version of Excel and can’t remember how to do it. If I click on a specific cell, a down arrow shows just to the right of the highlighted cell. Clicking on the arrow gives me a list of data (a single column) from elsewhere in my workbook. Selecting from that list places the data into the highlighted cell and then that info is used elsewhere within the sheet. Don’t recall what that function is called or how use/create/edit it
Several years ago I created a workbook under an older version of Excel and can’t remember how to do it. If I click on a specific cell, a down arrow shows just to the right of the highlighted cell. Clicking on the arrow gives me a list of data (a single column) from elsewhere in my workbook. Selecting from that list places the data into the highlighted cell and then that info is used elsewhere within the sheet. Don’t recall what that function is called or how use/create/edit it Read More
Unavailable/404 Windows update? “KB4580325: Security update for Adobe Flash Player (October 2020)”
Hello all,
Ran across a couple PCs that were found to have a browser plugin vulnerability and “KB4580325” is needed to address it:
KB4580325: Security update for Adobe Flash Player (October 2020)
Problem is, there’s a Microsoft KB link that takes you to a 404 page now and is no longer showing up when searching the Microsoft Update Catalog webpage either:
https://support.microsoft.com/kb/4580325
Checking to see how others have addressed this type of situation where a KB is needed, but is no longer available to download.
Thank you!
Hello all, Ran across a couple PCs that were found to have a browser plugin vulnerability and “KB4580325” is needed to address it:KB4580325: Security update for Adobe Flash Player (October 2020) Problem is, there’s a Microsoft KB link that takes you to a 404 page now and is no longer showing up when searching the Microsoft Update Catalog webpage either:https://support.microsoft.com/kb/4580325 Checking to see how others have addressed this type of situation where a KB is needed, but is no longer available to download. Thank you! Read More
Need to edit the Non-Delivery Reports (NDRs) in M365 template
Is there a way to customize the email template received by the recipient from Non-Delivery Reports (NDRs) or bounced email in M365.
Is there a way to customize the email template received by the recipient from Non-Delivery Reports (NDRs) or bounced email in M365. Read More
Adoption Masterminds May Meetup!
Hello, Driving Adoption got an exciting Adoption Masterminds coming up! First time having a presenter, the wonderful Lindsay Zandy will be presenting a talk she did at the M365 Conference.
Building a Business Case for Micorsoft Viva
You will not want to miss this! I have looked through the deck and this topic can for sure be applied to any technology!
If time permits I would also love to open up the floor to hear any insights from people who attended the M365 Conference!
See you all in a couple weeks!
Hello, Driving Adoption got an exciting Adoption Masterminds coming up! First time having a presenter, the wonderful Lindsay Zandy will be presenting a talk she did at the M365 Conference. Building a Business Case for Micorsoft Viva You will not want to miss this! I have looked through the deck and this topic can for sure be applied to any technology! If time permits I would also love to open up the floor to hear any insights from people who attended the M365 Conference! See you all in a couple weeks! Read More
Accelerating Co-Pilot Adoption for Enhanced Business Efficiency at StriveTechAI
At StriveTechAI, we are excited to announce our commitment to accelerating the adoption of Microsoft Copilot programs among our existing customers. As a leader in AI-driven solutions, we recognise the transformative potential of Copilot to streamline operations and drive strategic initiatives across all organisational sectors.
Deepening Integration with Microsoft Copilot
Microsoft Copilot has revolutionised how businesses interact with their data and workflows. Our goal is to deepen Copilot’s integration into our clients’ ecosystems, ensuring that every department—from finance and HR to operations and marketing—can leverage AI to enhance their productivity and decision-making processes.
Seeking Experienced Copilot Adopters
We are actively seeking highly experienced Copilot adopters to support this ambitious initiative. The ideal candidates will possess extensive knowledge in deploying and managing AI solutions and a proven track record of strategic implementation across diverse organisational structures.
Role of Expert Adopters
Our expert adopters will play a crucial role in:
Guiding Clients: You will provide hands-on guidance to our clients, helping them understand how to implement Copilot to optimise their workflows and data analysis strategically.Strategic Implementation: Beyond essential integration, you can advise on aligning Copilot’s capabilities with long-term business goals, ensuring that AI adoption supports broader strategic outcomes.Training and Development: Facilitate training sessions and workshops to enable clients’ teams to effectively utilise Copilot, fostering an environment of AI literacy and self-sufficiency.
Focus on Security and Data Integrity
A significant part of this acceleration program involves addressing and mitigating potential security risks associated with AI implementation:
Data Labeling and Management: You will advise our clients on best data labelling and management practices, which are crucial for maintaining the integrity and security of sensitive information.Reducing Security Risks: Through strategic data handling and tailored security protocols, you will help minimise the risk of data breaches, ensuring that our clients’ deployments of Microsoft Copilot are secure and compliant with prevailing data protection regulations.
Join Us in Transforming Business Operations
We invite skilled professionals who are passionate about AI and have a keen understanding of Microsoft Copilot to join us on this journey. Together, we will implement technology and transform it into a cornerstone of business strategy and operations.
Contact Us
If you are interested in collaborating with us to drive AI adoption and want to make a tangible impact on the operational success of businesses across industries, please reach out. Visit our careers page or contact us directly at info@strivetech-ai.com.
Let’s harness the power of Microsoft Copilot together and lead the way in intelligent business transformation.
At StriveTechAI, we are excited to announce our commitment to accelerating the adoption of Microsoft Copilot programs among our existing customers. As a leader in AI-driven solutions, we recognise the transformative potential of Copilot to streamline operations and drive strategic initiatives across all organisational sectors.Deepening Integration with Microsoft CopilotMicrosoft Copilot has revolutionised how businesses interact with their data and workflows. Our goal is to deepen Copilot’s integration into our clients’ ecosystems, ensuring that every department—from finance and HR to operations and marketing—can leverage AI to enhance their productivity and decision-making processes.Seeking Experienced Copilot AdoptersWe are actively seeking highly experienced Copilot adopters to support this ambitious initiative. The ideal candidates will possess extensive knowledge in deploying and managing AI solutions and a proven track record of strategic implementation across diverse organisational structures.Role of Expert AdoptersOur expert adopters will play a crucial role in:Guiding Clients: You will provide hands-on guidance to our clients, helping them understand how to implement Copilot to optimise their workflows and data analysis strategically.Strategic Implementation: Beyond essential integration, you can advise on aligning Copilot’s capabilities with long-term business goals, ensuring that AI adoption supports broader strategic outcomes.Training and Development: Facilitate training sessions and workshops to enable clients’ teams to effectively utilise Copilot, fostering an environment of AI literacy and self-sufficiency.Focus on Security and Data IntegrityA significant part of this acceleration program involves addressing and mitigating potential security risks associated with AI implementation:Data Labeling and Management: You will advise our clients on best data labelling and management practices, which are crucial for maintaining the integrity and security of sensitive information.Reducing Security Risks: Through strategic data handling and tailored security protocols, you will help minimise the risk of data breaches, ensuring that our clients’ deployments of Microsoft Copilot are secure and compliant with prevailing data protection regulations.Join Us in Transforming Business OperationsWe invite skilled professionals who are passionate about AI and have a keen understanding of Microsoft Copilot to join us on this journey. Together, we will implement technology and transform it into a cornerstone of business strategy and operations.Contact UsIf you are interested in collaborating with us to drive AI adoption and want to make a tangible impact on the operational success of businesses across industries, please reach out. Visit our careers page or contact us directly at info@strivetech-ai.com. Let’s harness the power of Microsoft Copilot together and lead the way in intelligent business transformation. Read More