Tag Archives: microsoft
New Outlook won’t search for old e-mail
Hello,
I have someone that has been having issues with their outlook account. Originally the issue persisted in the Classic Outlook. They would search for an old e-mail sent from a specific user, and they would be prompted by an error message saying “it looks like there’s a problem with your network connection – let’s check on your computer instead”. Which feels to me that it struggled to search the 365 exchange server first which prompted the error message – however, the email was able to be found as it is stored locally.
I re-installed outlook. I rebuilt the search index. I added a DWORD key in the registry ‘DisableServerAssistedSearch’ within ‘HKEY_CURRENT_USERSoftwareMicrosoftOffice16.0OutlookSearchDisableServerAssistedSearch’ and set value to 1.
This prevented the error message from cropping up whenever the email was searched for.
However, now when the same search is attempted on the new version of the outlook – it doesn’t do anything other then display an error message simply saying “Your request can’t be completed right now”.
Is there a fix for this? It’s quite annoying for anyone wishing to use the new version of the outlook.
Hello, I have someone that has been having issues with their outlook account. Originally the issue persisted in the Classic Outlook. They would search for an old e-mail sent from a specific user, and they would be prompted by an error message saying “it looks like there’s a problem with your network connection – let’s check on your computer instead”. Which feels to me that it struggled to search the 365 exchange server first which prompted the error message – however, the email was able to be found as it is stored locally. I re-installed outlook. I rebuilt the search index. I added a DWORD key in the registry ‘DisableServerAssistedSearch’ within ‘HKEY_CURRENT_USERSoftwareMicrosoftOffice16.0OutlookSearchDisableServerAssistedSearch’ and set value to 1. This prevented the error message from cropping up whenever the email was searched for. However, now when the same search is attempted on the new version of the outlook – it doesn’t do anything other then display an error message simply saying “Your request can’t be completed right now”. Is there a fix for this? It’s quite annoying for anyone wishing to use the new version of the outlook. Read More
Bookings page freezes browser
Hello,
My Bookings page freezes and crashes browsers. It will open and display normally but you are entirely unable to click on anything. Réserver l’heure avec Côté-Massicotte, Simon
Here’s what I have tested thus far :
– Changing the length and type of meetings
– Changing the header image
– Unlinking any calendar, resetting connections
– Deleting any other Bookings calendar my account was associated with
Nothing has helped in any way whatsoever. The problem is not related with my institution as all of my colleagues’ account work properly, with similar numbers of meeting types.
Has anyone else had that issue? Any other elements I should test?
Thank you all for your time!
Hello,My Bookings page freezes and crashes browsers. It will open and display normally but you are entirely unable to click on anything. Réserver l’heure avec Côté-Massicotte, Simon Here’s what I have tested thus far :- Changing the length and type of meetings- Changing the header image- Unlinking any calendar, resetting connections- Deleting any other Bookings calendar my account was associated withNothing has helped in any way whatsoever. The problem is not related with my institution as all of my colleagues’ account work properly, with similar numbers of meeting types. Has anyone else had that issue? Any other elements I should test?Thank you all for your time! Read More
Apple business manager deployment – receiving pop-up bout apple account
Hello intune forum,
I recently setup apple business manager in our enviroment to work with Intune. I’ve created the enrollment profile, setup the VPP token, etc. But now, a few of our users, myself included is getting a pop-up on our phones stating : “this apple account cannot make purchases”. I made sure only the VPP apps are being pushed to the company phones and not the apps from the store. Anyone else have this issue?
Hello intune forum,I recently setup apple business manager in our enviroment to work with Intune. I’ve created the enrollment profile, setup the VPP token, etc. But now, a few of our users, myself included is getting a pop-up on our phones stating : “this apple account cannot make purchases”. I made sure only the VPP apps are being pushed to the company phones and not the apps from the store. Anyone else have this issue? Read More
Enable MFA for external idetnities in MS Entra
Hi all,
I am planning to enable MFA for guest accounts and external identities using Conditional Access in MS Entra. I am however wondering how I can select what Authentication methods can they use – or what would be the default behaviour.
Currently, I am still using legacy MFA for internal users. I will migrate MFA to MS Entra later this year however, not sure how this is working when enabling MFA for external users.
As I do use legacy MFA, my setting in ” Authentication methods > Policies” have MS Authenticator set to NO.
Now, do I need to switch MS Authenticator to YES if I want guests to use that app? And if I enable it, how do I assign it to External identities only? I do not see that kind of option there at all… I can assign it to all, for example, but I am not yet ready to migrate internal users as well…
Would be happy to get some clarification on this.
Thank you
Hi all, I am planning to enable MFA for guest accounts and external identities using Conditional Access in MS Entra. I am however wondering how I can select what Authentication methods can they use – or what would be the default behaviour. Currently, I am still using legacy MFA for internal users. I will migrate MFA to MS Entra later this year however, not sure how this is working when enabling MFA for external users.As I do use legacy MFA, my setting in ” Authentication methods > Policies” have MS Authenticator set to NO. Now, do I need to switch MS Authenticator to YES if I want guests to use that app? And if I enable it, how do I assign it to External identities only? I do not see that kind of option there at all… I can assign it to all, for example, but I am not yet ready to migrate internal users as well… Would be happy to get some clarification on this. Thank you Read More
MS Project mime type is Application/vnd.ms-office
I have Plan 3 MS Project install on my machine and when I create new files in MS Project the mime type is always Application/vnd.ms-office why is the MS project mime type is not Application/vnd.ms-project
I have check the reg edit under ComputerHKEY_CLASSES_ROOTMIMEDatabaseContent Type
i can see Application/vnd.ms-project and the extension is mpp
I have Plan 3 MS Project install on my machine and when I create new files in MS Project the mime type is always Application/vnd.ms-office why is the MS project mime type is not Application/vnd.ms-projectI have check the reg edit under ComputerHKEY_CLASSES_ROOTMIMEDatabaseContent Typei can see Application/vnd.ms-project and the extension is mpp Read More
how do I get the url for a managed metadata set used in a document library
how do I get the url for a managed metadata set used in a document library
how do I get the url for a managed metadata set used in a document library Read More
Declarative Agent for M365 Copilot
This project showcases the use of a Declarative Agent for Microsoft 365 Copilot, designed to create personalized experiences through specific instructions, actions, and knowledge. Specializing in ServiceNow, this declarative agent leverages the following capabilities and actions:
SharePoint Integration: Enables users to retrieve information from files, which can be useful for providing context to ServiceNow tickets and for creating new tickets.
Graph Connectors: Utilizes the Knowledge Base and Services Catalog connectors from ServiceNow to enhance functionality.
Plugins: Incorporates a ServiceNow Scripted REST API that allows users to list their incidents and create new ones.
Note: This sample code is intended for illustrative purposes only and should not be deployed in a production environment without thorough review. It demonstrates how to build a simple Declarative Copilot using Visual Studio Code and the Teams Toolkit. Please note, I do not have the rights or permission from ServiceNow and Adventure Time (Ice King logo).
Prompt Samples
1. ServiceNow Knowledge Graph Connector:
List the articles regarding Outlook 2010. Place the results in a table with the article title in one column and a brief summary in the other
ServiceNow Service Catalog Graph Connector
How do I request a new laptop?
SharePoint Capability
List the items from the snow spreadsheet and format as a table. Also, please add an integer column as the first column, listing the item numbers.
Plugin: List my incidents
List my incidents
Plugin: Create a new incidents
The following prompt uses the list of incidents returned from the previously executed snow spreadsheet file. I’m asking Copilot to create a new incident based on the sixth item in that list.
Create a new incident for the item 6
Build a basic declarative agent with API plugin
Declarative agents are customized versions of Microsoft 365 Copilot that help you to create personalized experiences by declaring specific instructions, actions, and knowledge.
With the declarative agent, you can build a custom version of Copilot that can be used for specific scenarios, such as for specialized knowledge, implementing specific processes, or simply to save time by reusing a set of AI prompts. For example, a grocery shopping Copilot declarative agent can be used to create a grocery list based on a meal plan that you send to Copilot.
You can extend declarative agents using plugins to retrieve data and execute tasks on external systems. A declarative agent can utilize multiple plugins at the same time.
Get started
Prerequisites
To run this app template in your local dev machine, you will need:
Node.js, supported versions: 16, 18
A Microsoft 365 account for development.
Teams Toolkit Visual Studio Code Extension version 5.0.0 and higher or Teams Toolkit CLI
Microsoft 365 Copilot license
ServiceNow Developer Instance
First, select the Teams Toolkit icon on the left in the VS Code toolbar.
In the Account section, sign in with your Microsoft 365 account if you haven’t already.
Create Teams app by clicking Provision in “Lifecycle” section.
Select Preview in Copilot (Edge) or Preview in Copilot (Chrome) from the launch configuration dropdown.
Select your declarative agent from the Copilot app.
Send a prompt.
What’s included in the project
Folder
Contents
.vscode
VSCode files for debugging
appPackage
Templates for the Teams application manifest, the plugin manifest and the API specification
env
Environment files
The following files can be customized and demonstrate an example implementation to get you started.
File
Contents
appPackage/declarativeCopilot.json
Define the behaviour and configurations of the declarative agent.
appPackage/manifest.json
Teams application manifest that defines metadata for your declarative agent.
appPackage/instructions.txt
Define how the agent should communicate. An agent might be concise, detailed, interactive, or suggestive. Also include any restrictions that should be applied.
appPackage/ai-plugin.json
It contains everything Copilot needs to know about the API that isn’t in the Swagger file. It breaks the API down into “functions” that share a common URL path and result set.
appPackage/apiSpecificationFile/openapi.json
It is the Swagger file for the API.
The following are Teams Toolkit specific project files. You can visit a complete guide on Github to understand how Teams Toolkit works.
File
Contents
teamsapp.yml
This is the main Teams Toolkit project file. The project file defines two primary things: Properties and configuration Stage definitions.
Addition information and references
Declarative agents for Microsoft 365
Extend Microsoft 365 Copilot
Message extensions for Microsoft 365 Copilot
Microsoft Graph Connectors for Microsoft 365 Copilot
Microsoft 365 Copilot extensibility samples
ServiceNow Plugin
This project consumes two ServiceNow Scripted REST APIs to integrate with ServiceNow’s platform, enabling seamless data exchange and automation of specific workflows.
ServiceNow Scripted REST APIs
Scripted REST APIs in ServiceNow allow developers to create custom web service APIs that can interact with ServiceNow data and services. These APIs can be configured to support various HTTP methods (GET, POST, PUT, DELETE) and can be used to perform operations like querying data, creating records, updating records, and deleting records.
Creating Scripted REST APIs
This section includes the code for the Scripted REST API designed to list the incidents associated with a user.
Navigate to System Web Services: Go to System Web Services > Scripted Web Services > Scripted REST APIs.
Create a New API: Click on New and provide a name and namespace for your API.
Define Resources: Create resources by specifying the HTTP method, relative path, and any path parameters.
Write Scripts: In the scripting window, write the necessary scripts to handle the request and response objects.
Test the API: Use the REST API Explorer to test your API and ensure it works as expected.
List my Incidents REST API
The API is built on ServiceNow’s platform, utilizing its robust scripting capabilities to fetch and return incident data.
This API supports the GET method and responds with a JSON object containing the relevant incident details.
(function process(/*RESTAPIRequest*/ request, /*RESTAPIResponse*/ response) {
var username = request.pathParams.username;
//var username = request.queryParams.username;
// Get the ServiceNow instance name
var instanceName = gs.getProperty(‘instance_name’, ‘default_instance’);
// Replace ‘+’ with ‘ ‘ (space)
username = username.replace(/+/g, ‘ ‘);
// Query the Incident table for incidents associated with the email
var gr = new GlideRecord(‘incident’);
gr.addQuery(‘caller_id.name’, username);
gr.query();
// Prepare the result
var result = [];
while (gr.next()) {
result.push({
number: gr.getValue(‘number’),
short_description: gr.getValue(‘short_description’),
state: gr.getValue(‘state’)
});
}
// Check if incidents were found
if (result.length === 0) {
response.setStatus(404);
response.setBody({error: ‘No incidents found for the user name’});
} else {
// Set the result as the response body
response.setStatus(200);
response.setBody(result);
}
})(request, response);
Create a new incident
This section includes the code for the Scripted REST API designed to create new incidents on ServiceNow.
This API leverages ServiceNow’s capabilities to accept incident details through a POST request and create a corresponding incident record in the ServiceNow system. The request body should contain the necessary incident data, and upon successful creation, the API responds with the details of the newly created incident.
(function process(/*RESTAPIRequest*/ request, /*RESTAPIResponse*/ response) {
// Parse the request body to get incident details
var requestBody = request.body.data;
// Check required fields in the request body
if (!requestBody || !requestBody.short_description || !requestBody.username) {
response.setStatus(400); // Bad Request
response.setBody({error: “Missing required fields: short_description or username”});
return;
}
// Lookup caller_id based on the username
var userGr = new GlideRecord(‘sys_user’);
userGr.addQuery(‘name’, requestBody.username);
userGr.query();
if (!userGr.next()) {
response.setStatus(404); // Not Found
response.setBody({error: “User not found with username: “ + requestBody.username});
return;
}
var callerId = userGr.sys_id;
// Create a new incident record in ServiceNow
var gr = new GlideRecord(‘incident’);
gr.initialize();
gr.short_description = requestBody.short_description;
gr.description = requestBody.description;
gr.caller_id = callerId; // Assign the found caller’s sys_id
gr.category = requestBody.category || ‘inquiry’; // Optional: Default category
gr.impact = requestBody.impact || 3; // Optional: Default to low impact
gr.urgency = requestBody.urgency || 3; // Optional: Default to low urgency
var incidentNumber;
try {
// Insert the incident record
var sysId = gr.insert();
incidentNumber = gr.number;
// Set success response
response.setStatus(201); // Created
response.setBody({
result: ‘Incident created successfully’,
sys_id: sysId,
number: incidentNumber
});
} catch (e) {
// Handle error during record insertion
gs.error(“Error creating incident: “ + e.message);
response.setStatus(500); // Internal Server Error
response.setBody({error: “Error creating incident: “ + e.message});
}
})(request, response);
There are two versions.
The official one, shared at Microsoft repo, uses a REST API developed by Cristiano to connect to ServiceNow:
copilot-pro-dev-samples/samples/da-SnowWizard at main · pnp/copilot-pro-dev-samples · GitHub
My version, uses the Scripted REST API from ServiceNow and uses two ServiceNow Graph Connectors:
GitHub – luishdemetrio/SnowKing
THIS CODE IS PROVIDED AS IS WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING ANY IMPLIED WARRANTIES OF FITNESS FOR A PARTICULAR PURPOSE, MERCHANTABILITY, OR NON-INFRINGEMENT.
Microsoft Tech Community – Latest Blogs –Read More
SQL Konferenz: A Transformative Gathering of Data Experts
The SQL Konferenz 2024, held from September 30 to October 2 in Hanau, Germany, was more than just another tech event—it was a dynamic celebration of data-driven innovation, community engagement, and the start of a new chapter for Datamonster.io community. Organized by the German Data Platform Community, this year’s conference brought together 400 data professionals from around the world, marking the 9th edition of the SQL Konferenz and the 20th anniversary of the non-profit organization formerly known as PASS Deutschland.
The three-day event provided attendees with a perfect blend of technical deep dives and strategic overviews, reflecting the community’s growing appetite for diverse learning experiences. SQL Konferenz 2024 featured an impressive roster of 33 Microsoft MVPs and 14 Microsoft experts, sharing cutting-edge insights on topics like Microsoft Fabric, Power BI, and advanced database management. This year’s keynote was especially symbolic, as the newly rebranded Datamonster.io, along with its mascot “Damon,” took center stage, signifying the community’s forward-thinking evolution.
One of the most important takeaways from the event was the feedback received from the attendees, emphasizing the need for a balance between technical depth and real-world use cases. “The feedback was overwhelming,” noted MVP/RD and Vice President Constantin Klein, highlighting the excitement generated by key contributions from the Microsoft Product Group and Germany-based partners. The conference also sparked crucial discussions on increasing diversity within the data platform community, a topic that the organizers are keen to advance for future events. Constantin was not the unique organizer, he was helped by the following data experts:
Oliver Engels, Data Platform MVP
Frank Geisler (Data Platform MVP)
Benjamin Kettner (former Data Platform MVP)
Klaus Höltgen
A big thank you to all of them!
In a testament to the power of in-person connections, many attendees remarked on the value of serendipitous conversations during breaks, which often led to profound exchanges of ideas. MVP Thomas Martens, who presented a session on Microsoft Fabric, echoed this sentiment: “These ‘accidental’ opportunities to discuss new ideas are as valuable as the formal sessions.”
The SQL Konferenz 2024 was not just a look back at two decades of success but a bold vision of the future. The announcement of the next SQL Konferenz in February 2025 and the ongoing support of 16 regional Datamonster user groups ensure that this community will continue to thrive as a hub of innovation, education, and collaboration.
Microsoft Tech Community – Latest Blogs –Read More
Is it possible to hide the Presence Indicator on a Modern SharePoint List View?
Hi Everyone!
I haven’t been able to figure out how to hide the presence indicator on records in a modern SharePoint list when users have them open. I need to be able to just… show the list in a super simple format without the presence indicator. See attached image for a sample of what I’m talking about – the gray box around that one record with the user’s initials needs to go. I haven’t been able to find a JSON property for it.
Any ideas?
Thanks for your consideration!
Hi Everyone! I haven’t been able to figure out how to hide the presence indicator on records in a modern SharePoint list when users have them open. I need to be able to just… show the list in a super simple format without the presence indicator. See attached image for a sample of what I’m talking about – the gray box around that one record with the user’s initials needs to go. I haven’t been able to find a JSON property for it. Any ideas? Thanks for your consideration! Read More
“My Tasks” not showing subtasks
Our team just signed up for a MS Planner Premium license (Project 1), and we noticed that in the “My Tasks” view, there’s no way to see subtasks from our premium plans – it only shows tasks in basic plans.
Does anyone know how to have a view of all tasks and subtasks from all plans in your Planner account? Being able to get a general overview of all of your work is basic project management and I hope it’s something that’s possible in MS Planner Premium.
Our team just signed up for a MS Planner Premium license (Project 1), and we noticed that in the “My Tasks” view, there’s no way to see subtasks from our premium plans – it only shows tasks in basic plans. Does anyone know how to have a view of all tasks and subtasks from all plans in your Planner account? Being able to get a general overview of all of your work is basic project management and I hope it’s something that’s possible in MS Planner Premium. Read More
How do I disable attachments in Outlook draft messages for my organization via Powershell?
My company wants to create a policy that prevents people from starting an Outlook message, adding an attachment to that message, going to another computer or device, opening Outlook on that device, and downloading the file from their draft message. we have O365 and Exchange Online. All the information I’ve found on setting Outlook options or draft options or any of that has been for individual users rather than organizations. I’ve been told that it can be done via powershell and office group policies, but TBH, I don’t have much Powershell familiarity. Any suggestions?
My company wants to create a policy that prevents people from starting an Outlook message, adding an attachment to that message, going to another computer or device, opening Outlook on that device, and downloading the file from their draft message. we have O365 and Exchange Online. All the information I’ve found on setting Outlook options or draft options or any of that has been for individual users rather than organizations. I’ve been told that it can be done via powershell and office group policies, but TBH, I don’t have much Powershell familiarity. Any suggestions? Read More
Programmatically remediate SharePoint and OneDrive Oversharing links
Hi SPO Brain Trust,
Has anyone been able to work around a solution to programmatically remove oversharing links (from content level) from SharePoint sites and OneDrives as opposed to using 3rd party tooling?
Very keen to hear your thoughts on this as we’re looking at manually remediating these from our environment.
Thank you!
Hi SPO Brain Trust, Has anyone been able to work around a solution to programmatically remove oversharing links (from content level) from SharePoint sites and OneDrives as opposed to using 3rd party tooling? Very keen to hear your thoughts on this as we’re looking at manually remediating these from our environment. Thank you! Read More
Pricing and SKU for SharePoint Server Subscription Edition
We are looking to purchase SharePoint Server Subscription Edition and It’s CAL.
What would be the Pricing for this and what would be the SKUs that I need to confirm before purchasing this ? or where can I be able to check for the same
We are looking to purchase SharePoint Server Subscription Edition and It’s CAL. What would be the Pricing for this and what would be the SKUs that I need to confirm before purchasing this ? or where can I be able to check for the same Read More
Solver constraint R.H. side = 0 in sensitivity report
Hi,
I defined cells with my R.H. side constraints (fig 1).
I used them in may Solver (fig 2)
In the sensitivity report, Constraint RH side are equal to 0 (fig 3)
Could you explain why ?
Best regards
Hi,I defined cells with my R.H. side constraints (fig 1).I used them in may Solver (fig 2)In the sensitivity report, Constraint RH side are equal to 0 (fig 3)Could you explain why ?Best regards Read More
SQL Server failing to execute extremely complex queries
A query is failing with this error message on a customer environment:
The query processor ran out of internal resources and could not produce a query plan.
This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions.
Please simplify the query.
If you believe you have received this message in error, contact Customer Support Services for more information.
Sorry I cannot post the actual SQL query, which must be massive, but basically it is a union of a lot of tables.
Maybe around 600 tables, maybe several thousands, I don’t know exactly how many.
For technical reasons, we cannot really simplify this query.
In the documentation:
https://learn.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver16
It is specified that the maximum number of tables in a select is limited only by available resources.
Is it possible to increase the size of available internal resources somehow?
A query is failing with this error message on a customer environment:The query processor ran out of internal resources and could not produce a query plan.
This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions.
Please simplify the query.
If you believe you have received this message in error, contact Customer Support Services for more information.Sorry I cannot post the actual SQL query, which must be massive, but basically it is a union of a lot of tables.Maybe around 600 tables, maybe several thousands, I don’t know exactly how many.For technical reasons, we cannot really simplify this query.In the documentation:https://learn.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver16It is specified that the maximum number of tables in a select is limited only by available resources.Is it possible to increase the size of available internal resources somehow? Read More
What’s New in Excel (October 2024)
Welcome to the October 2024 update. This month, we’re excited that Clean Data with Copilot in Excel is now available in Excel for the web. Also, GROUPBY and PIVOTBY functions are now generally available in Excel for Windows, Mac and web. Furthermore, Focus Cell is now available to Insider users on Excel for Windows.
Excel for web:
– Clean Data with Copilot in Excel
Excel for Windows, Mac, and web:
– GROUPBY and PIVOTBY functions
Excel for Windows:
– Focus Cell (Insiders)
– Color Picker
– New Template in Excel
– Draw and Hold gesture (Insiders) #FIA
Excel for Mac and iOS:
– Seamlessly switch between your Apple devices with Handoff support (Insiders)
Excel for web
Clean Data with Copilot in Excel
With Copilot in Excel, you can clean data with just one click. Clean Data detects and offers solutions for text inconsistencies, number format issues, and extra spaces. Simply select the Clean Data option in the Data tab of the ribbon or interact with the pop-up banner to get started. Read more here >
Excel for Windows, Mac, and web
GROUPBY and PIVOTBY functions
These functions are now generally available to users in the Current Channel. GROUPBY and PIVOTBY allow you to perform data aggregations using a single formula. All you need is just 3 arguments: i) What to group by, ii) the values to aggregate, and iii) the function you’d like to use for the aggregation. Read more here >
GROUPBY:
PIVOTBY:
Excel for Windows
Focus Cell (Insiders)
Make the active cell more visible in your worksheet with Focus Cell. Focus Cell applies vibrant highlights to the corresponding row and column of the active cell and increases the active cell’s border thickness. This makes the active cell more visible and facilitates easy identification of data across the same row and column. Read more here >
Color Picker
Excel’s color picker now includes a feature that shows you if the selected color contrasts adequately with the background. By hovering over a color, you will see a tool tip indicating whether the color has “Low Contrast” or “Good Contrast” against the backdrop. Additionally, you can turn on the “High-contrast only” toggle to filter and display only colors with sufficient contrast.
New Templates in Excel
We’re excited to introduce three new Python in Excel templates. To access them, go to File > New. Then type in “Python” in the template search bar. Python in Excel template are currently only available in the English language.
1. Python in Excel tutorial: Learn about Python in Excel and how you can use it to analyze data directly within your Excel spreadsheets.
2. QR code generator: Easily generate customized QR codes in Excel to share with others for quick access to links.
3. Dummy data generator: Generate realistic dummy data for testing or demos.
#FIA
Draw and Hold gesture (Insiders)
To create neater lines and shapes, you can now use the Draw and Hold gesture. Simply draw a line, arrow, or shape (like a circle, ellipse, triangle, square, rectangle, rhombus, pentagon, or hexagon) in a single stroke, hold your pen in place for a few milliseconds, and watch as the shape is converted into a neater version. While still holding, you can drag to rotate or resize the shape. Read more here >
Excel for Mac and iOS
Seamlessly switch between your Apple devices with Handoff support (Insiders)
Handoff is an Apple feature that allows you to continue working on content while switching from one Apple device to another. For example, if you’re working on an Excel spreadsheet on your iPhone and want to switch to your Mac, Handoff makes it possible with just a couple clicks. Read more here >
Check if a specific feature is in your version of Excel
Click here to open in a new browser tab
Many of these features are the result of your feedback. THANK YOU! Your continued Feedback in Action (#FIA) helps improve Excel for everyone. Please let us know how you like a particular feature and what we can improve upon—“Give a compliment” or “Make a suggestion”.. You can also submit new ideas or vote for other ideas via Microsoft Feedback.
Subscribe to our Excel Blog and the Insiders Blog to get the latest updates. Stay connected with us and other Excel fans around the world – join our Excel Community and follow us on X, formerly Twitter.
Special thanks to our Excel MVPs David Benaim, Bill Jelen, Alan Murray, and John Michaloudis for their contribution to this month’s What’s New in Excel article. David publishes weekly YouTube videos and regular LinkedIn posts about the latest innovations in Excel and more. Bill is the founder and host of MrExcel.com and the author of several books about Excel. Alan is an Excel trainer, author and speaker, best known for his blog Computergaga.com and YouTube channel with the same name. John is the Founder & Chief Inspirational Officer at MyExcelOnline.com where he passionately teaches thousands of professionals how to use Excel to stand out from the crowd.
Microsoft Tech Community – Latest Blogs –Read More
Poor video quality is costing your business more than you think—here’s how to fix it
In this guest blog post, Polina Davydova, Content & Communication Manager at Hive Streaming, explains how subpar video communication holds back enterprises, and how focusing on IT infrastructure, video experience, and overall messaging impact with help from Hive Streaming on Microsoft Azure drives employee attend and facilitates cross-organizational alignment.
The growth of the global video conferencing market is poised to be explosive over the next decade. By 2032, the market is expected to reach $95 billion, a massive leap from $10.6 billion in 2022.
Despite the tremendous investments organizations are making in their video communication infrastructure, a key issue many face is the gap between having the right video technology and achieving a stable, high-quality video experience that drives employee attendance and facilitates cross-organizational alignment. The consequences can be far-reaching: disengaged employees, ineffective leadership messages, and missed business opportunities that may prove devasting to the bottom line.
In this blog post, we will explore how subpar video communication quality holds back enterprises – and, more importantly, how to change that by focusing on three critical areas: IT infrastructure, video experience, and the overall messaging impact.
Network instability poses financial and strategic risks
The foundation of any successful video strategy is infrastructure. If your company’s network is not equipped to handle the bandwidth demands of high-quality video streaming, it will inevitably result in buffering, interruptions, and even system crashes during critical moments. Despite significant technical breakthroughs, the vast majority of businesses still experience some form of network degradation during live video events (according to one report, the number of network and application outages rose significantly in 2023).
Outages often occur because of the complex dependencies between network infrastructures, which can lead to severe disruptions during live video events, and, as a result, to financial and reputational losses. Accounting for both, the cost of a failed internal communications can be astronomical.
And this isn’t just about technical hiccups – viewer experience directly impacts how the audience perceives the message. In an internal communications context, when employees are subjected to stream interruptions or poor-quality video, their focus shifts away from the content and onto the technical problems. This leads to lower engagement, missed key messages, and a perception that the company lacks the resources to handle modern communication tools effectively.
Testing and network optimization key to failure prevention
But there is good news: Using the right video communications technology can help bolster existing network infrastructure and eliminate the need for costly and inefficient upgrades to bandwidth allowance. An Enterprise Content Delivery Network (or eCDN) can help optimize video delivery using the bandwidth resources you already have by leveraging technologies such as peer-to-peer distribution. This reduces the amount of external bandwidth needed because the content is shared between users within the organization without repeatedly pulling data from the internet.
Investing in scalable solutions like Hive eCDN and Premium Video Optimization ensures large-scale video events don’t overwhelm your network. For added security, there is also the option to run the actual video event on user machines ahead of time and identify any issues that would otherwise arise during the live stream in advance, with ample time left to understand their root cause and remediate.
Internal video communications quality is central to business success
Once the infrastructure is stable, video experience is the second-biggest factor in how a message is received. Poor video quality – grainy visuals, lagging audio, and long buffering times – quickly undermines the effectiveness of any communication. There is plenty of research that illustrates how bitrate and buffering events play key roles in viewer engagement, some suggesting that even a 1 percent increase in buffering ratio can significantly reduce user engagement with live video content – making it dramatically less likely the message being communicated will inspire the desired action.
The significance of video quality extends beyond engagement alone. A subpar experience reflects poorly on the value a company assigns to employee experience, a critical parameter often cited as one that directly affects every single facet of business operations: from productivity and innovation to customer retention – and, by extension, revenue and profitability.
How to secure stable and reliable video experience
Control the Event by Hive Streaming empowers IT managers to effectively manage viewer experience in real time and take immediate action to prevent stream disruptions.
Control the Event works behind the scenes to detect issues based on multiple KPIs, including the number of viewers, location, and buffering severity. When an issue is identified, event managers are instantly alerted and presented with a set of recommendations they can execute on the spot – in some cases, with just a single click of a button. The result is a smooth, immersive video experience that keeps viewers focused on the content.
Maximizing communication impact with Hive VX for Teams Town Hall
Many businesses fail to track the effectiveness of their video communication, missing opportunities to refine their strategy. Even the most stable, high-quality video won’t be effective unless it achieves its intended goals – whether that’s increasing engagement, improving employee alignment, or inspiring action to drive business transformation. Without insight into viewer engagement, attendance, and message retention, it’s difficult to gauge success or identify areas for improvement.
Building on decades of industry expertise, Hive Streaming has developed the video experience (VX) technology and advisory necessary to succeed with internal video communications using Microsoft Teams Town Hall and most other major video communication platforms.
Hive Advisory Services were carefully designed to help our customers prevent the adverse effects of subpar video experience and offer personalized support at every stage of their video communication journey:
Learning how to plan, run and optimize video events – and how to measure success
Testing IT infrastructure to identify and remediate weak links
Detecting and resolving video experience issues in real time
Refining communication strategy with in-depth trend analysis
To create successful video communications, companies must address all three areas: infrastructure, video experience, and overall impact. These elements are interconnected; a stable infrastructure enables high-quality video, which in turn drives greater attendance and ensures communications resonate with viewers to facilitate cross-organizational alignment.
Hive’s next-generation VX products and Advisory Services are designed to address the entire video communication lifecycle, from planning and technical enablement to evaluation and improvement strategies.
If you would like to learn more about the impact these can create for your organization, reach out to us for a consultation today.
Microsoft Tech Community – Latest Blogs –Read More
What’s New in Microsoft EDU webinar – November 2024
Here is our November 2024 webinar agenda:
What’s new in Copilot for EDU
What’s new for AI in Microsoft Teams for EDU
What’s New in Learning Accelerators
What’s new in Microsoft 365 EDU
AMA – Ask Microsoft EDU Anything (Q&A)
How to sign up
OPTION 1: November 13th, Wednesday @ 8:00am Pacific Time Register here
OPTION 2: November 13th, Wednesday @ 4:00pm Pacific Time Register here
This is what the webinar portal will look like when you register:
Microsoft Tech Community – Latest Blogs –Read More
I hope OneNote has an anti-mistouch function.
Reading notes on the Surface and swiping the touchscreen with your hand will often cause the content to change due to accidental touches. For example, a mistouch will cause an image to be selected, and a finger slide will cause the image to be changed. Therefore, I hope that there is an anti-mistake button when reading notes, and it is not allowed to modify the content.
Reading notes on the Surface and swiping the touchscreen with your hand will often cause the content to change due to accidental touches. For example, a mistouch will cause an image to be selected, and a finger slide will cause the image to be changed. Therefore, I hope that there is an anti-mistake button when reading notes, and it is not allowed to modify the content. Read More
एयरटेल पेमेंट बैंक में पैसा कट जाने पर शिकायत कैसे करें?
एयरटेल पेमेंट बैंक से पैसे कट जाए तो क्या करें? ग्राहक सहायता टीम (8861↑111↑624} तक पहुंच सकते हैं और जितनी जल्दी हो सके अपनी शिकायत दर्ज कर सकते हैं।
एयरटेल पेमेंट बैंक से पैसे कट जाए तो क्या करें? ग्राहक सहायता टीम (8861↑111↑624} तक पहुंच सकते हैं और जितनी जल्दी हो सके अपनी शिकायत दर्ज कर सकते हैं। Read More