Category: Microsoft
Category Archives: Microsoft
Auto populate a calendar
I am looking for pointers on how to auto populate a calendar with the info in the attached file, basically start and end info with course and subject info
I am looking for pointers on how to auto populate a calendar with the info in the attached file, basically start and end info with course and subject info Read More
How to download songs on Spotify to my computer
Recently , I found some great tracks on Spotify that I’d love to download and listen to offline on my computer. However, I’m not entirely sure how to go about this. When right click on the song, there is no DOWNLOAD option available.
I’ve heard that there are specific tools that can help with downloading songs on Spotify, but the suggestion from Google search is crap! I’m looking for a reliable and straightforward way to do it. Could anyone provide some guidance on how to download Spotify songs onto my computer?
Regards,
Stephane
Recently , I found some great tracks on Spotify that I’d love to download and listen to offline on my computer. However, I’m not entirely sure how to go about this. When right click on the song, there is no DOWNLOAD option available. I’ve heard that there are specific tools that can help with downloading songs on Spotify, but the suggestion from Google search is crap! I’m looking for a reliable and straightforward way to do it. Could anyone provide some guidance on how to download Spotify songs onto my computer? Regards,Stephane Read More
Trying to report mail usage, internal vs externally sent messages
Hi,
I am trying to find a way that I can report per user per day the number of messages sent, split between internal or external. My company has a few different domains that we class as Internal, checked the 365 Admin > Reports section but nothing there appears to provide the breakdown.
Has anyone done this, if so, how exactly, don’t mind if PowerShell or GUI
Hi,I am trying to find a way that I can report per user per day the number of messages sent, split between internal or external. My company has a few different domains that we class as Internal, checked the 365 Admin > Reports section but nothing there appears to provide the breakdown.Has anyone done this, if so, how exactly, don’t mind if PowerShell or GUI Read More
Sync Emails with microsoft email to main organisation (for us NHS mail) email together?
Hi
I want to sync the Microsoft account with our organisation (NHS) email account, is this possible?
We need this to sync into the staffs calendars etc but if its linked with our Microsoft log in (which is a different email) we will need it to be sync. Or is there a way to forward/redirect emails to the NHS account?
We need it to be linked with the account as we do not have permissions etc in the NHS account (as says do not have access to create shared bookings but it is an option on the other Microsoft email account as there licence is linked with this). However this is not the main account we use and need this sync together. Please can i check this ASAP?
Thanks!!
HiI want to sync the Microsoft account with our organisation (NHS) email account, is this possible? We need this to sync into the staffs calendars etc but if its linked with our Microsoft log in (which is a different email) we will need it to be sync. Or is there a way to forward/redirect emails to the NHS account? We need it to be linked with the account as we do not have permissions etc in the NHS account (as says do not have access to create shared bookings but it is an option on the other Microsoft email account as there licence is linked with this). However this is not the main account we use and need this sync together. Please can i check this ASAP? Thanks!! Read More
Microsoft Teams VOIP capability
Hi Team,
Here we have a breakdown of the requirements as per our understanding i am looking for this solution for the India location:
VoIP service to connect users to customer support agents via data calls.Free data calls for customers, including international connections, ensuring no extra charges.SDKs for both iOS and Android platforms to facilitate easy integration using a Call to Connect (CTC) feature.An admin panel for call logs, monitoring, and analytics, offering a robust dashboard experience.Intended for VIP users, implying initially low traffic.VoIP service that allows their VIP users to call directly to their customer support agents from their app.
Need your suggestion? Is it possible to achieve the solution mentioned above using Microsoft Teams? If feasible, could you please guide us on how to implement it? Your guidance on this matter would be highly appreciated.
Hi Team, Here we have a breakdown of the requirements as per our understanding i am looking for this solution for the India location: VoIP service to connect users to customer support agents via data calls.Free data calls for customers, including international connections, ensuring no extra charges.SDKs for both iOS and Android platforms to facilitate easy integration using a Call to Connect (CTC) feature.An admin panel for call logs, monitoring, and analytics, offering a robust dashboard experience.Intended for VIP users, implying initially low traffic.VoIP service that allows their VIP users to call directly to their customer support agents from their app. Need your suggestion? Is it possible to achieve the solution mentioned above using Microsoft Teams? If feasible, could you please guide us on how to implement it? Your guidance on this matter would be highly appreciated. @mgormsen Read More
There is no shadow when moving mouse upon an adaptive card column which was set “Selection action”.
There is a shadow when moving mouse upon an adaptive card column which was set “Selection action” in adaptive card designer.
However, with same adaptive card codes, there is no shadow when moving mouse upon an adaptive card column which was set “Selection action” in teams chat.
The adaptive card codes is :
{
“type”: “AdaptiveCard”,
“$schema”: “http://adaptivecards.io/schemas/adaptive-card.json”,
“version”: “1.6”,
“body”: [
{
“type”: “ColumnSet”,
“columns”: [
{
“type”: “Column”,
“width”: “stretch”,
“items”: [
{
“type”: “TextBlock”,
“text”: “New TextBlock”,
“wrap”: true
}
],
“selectAction”: {
“type”: “Action.OpenUrl”,
“url”: “https://adaptivecards.io/designer/”
}
}
]
}
]
}
There is a shadow when moving mouse upon an adaptive card column which was set “Selection action” in adaptive card designer. However, with same adaptive card codes, there is no shadow when moving mouse upon an adaptive card column which was set “Selection action” in teams chat. The adaptive card codes is : {
“type”: “AdaptiveCard”,
“$schema”: “http://adaptivecards.io/schemas/adaptive-card.json”,
“version”: “1.6”,
“body”: [
{
“type”: “ColumnSet”,
“columns”: [
{
“type”: “Column”,
“width”: “stretch”,
“items”: [
{
“type”: “TextBlock”,
“text”: “New TextBlock”,
“wrap”: true
}
],
“selectAction”: {
“type”: “Action.OpenUrl”,
“url”: “https://adaptivecards.io/designer/”
}
}
]
}
]
} Read More
Vlookup with 2 scenarios
Hi All, I am trying to formulate a formula to lookup two values. One is the tag number and the other the date and then it should return the test results in column 4 of the test results tab.
=IFERROR(VLOOKUP(A3, Table10, 1, FALSE)+VLOOKUP(X3, Table10, 2, FALSE)=VLOOKUP(A3,Table10,4,FALSE), “Not Tested”)
Hi All, I am trying to formulate a formula to lookup two values. One is the tag number and the other the date and then it should return the test results in column 4 of the test results tab. =IFERROR(VLOOKUP(A3, Table10, 1, FALSE)+VLOOKUP(X3, Table10, 2, FALSE)=VLOOKUP(A3,Table10,4,FALSE), “Not Tested”) Read More
All SharePoint Online Sharing Links Now Support Expiration Dates
A very useful update to support sharing links expiration for all link types used by SharePoint Online and OneDrive for Business is now rolling out and should be available in all Microsoft 365 tenants soon. Until now, expiration dates were only available for anyone links. Many organizations don’t allow anyone links, so enabling the feature for company-wide and specific people links will be much appreciated.
https://office365itpros.com/2024/07/04/sharing-links-expiration/
A very useful update to support sharing links expiration for all link types used by SharePoint Online and OneDrive for Business is now rolling out and should be available in all Microsoft 365 tenants soon. Until now, expiration dates were only available for anyone links. Many organizations don’t allow anyone links, so enabling the feature for company-wide and specific people links will be much appreciated.
https://office365itpros.com/2024/07/04/sharing-links-expiration/ Read More
How to install Windows 11 without internet or network on a PC?
Hi everyone,
I’m planning to install Windows 11 on a PC, which only has cable connection. My home is a WiFI router. So this PC does not have Internet connection or any network during the installation process. I’ve heard it’s possible to install Windows 11 without Internet, but I’m not sure about the steps involved.
I understand that the typical installation process for Windows 11 often requires an internet connection, especially for the setup of a Microsoft account. Can someone guide me on how to install Windows 11 without network on a PC?
Hi everyone, I’m planning to install Windows 11 on a PC, which only has cable connection. My home is a WiFI router. So this PC does not have Internet connection or any network during the installation process. I’ve heard it’s possible to install Windows 11 without Internet, but I’m not sure about the steps involved. I understand that the typical installation process for Windows 11 often requires an internet connection, especially for the setup of a Microsoft account. Can someone guide me on how to install Windows 11 without network on a PC? Read More
OneDrive personal – The request is blocked
Accessing onedrive personal from 46.37.X.X range is being blocked with error below:
The request is blocked.
Ref A: F1291C91A2BD407E8BBAE377871C8D0A Ref B: LON21EDGE1112 Ref C: 2024-07-04T08:21:45Z
We are ISP/MSP and most of our customer are on this range and getting the same error. Where do i check if our IP address range is blacklisted?
Accessing onedrive personal from 46.37.X.X range is being blocked with error below:The request is blocked.Ref A: F1291C91A2BD407E8BBAE377871C8D0A Ref B: LON21EDGE1112 Ref C: 2024-07-04T08:21:45Z We are ISP/MSP and most of our customer are on this range and getting the same error. Where do i check if our IP address range is blacklisted? Read More
Windows 11 computers occasionally have black screens
My Windows screen will go completely black and unresponsive. It’s like the computer is stuck or frozen, but it’s not shutting down or restarting. The keyboard and mouse don’t work, and I can’t even get to the login screen. Sometimes I have to wait for a few minutes, and then the screen will flicker back to life and everything will be normal again. But other times, I have to restart my computer manually.
What’s wrong?
My Windows screen will go completely black and unresponsive. It’s like the computer is stuck or frozen, but it’s not shutting down or restarting. The keyboard and mouse don’t work, and I can’t even get to the login screen. Sometimes I have to wait for a few minutes, and then the screen will flicker back to life and everything will be normal again. But other times, I have to restart my computer manually.What’s wrong? Read More
BSOD Loop, cannot log in?
My computer gets stuck in a Blue Screen of Death (BSOD) loop. Every time I try to log in to my Windows account, the computer crashes and restarts, and then immediately goes back to the login screen. It doesn’t matter if I try to log in with my admin account or guest account, or even try to boot in safe mode – the same thing happens every time. The BSOD says that the problem is caused by a driver or hardware issue, but I’ve tried updating all my drivers and running a disk check with no luck.
My computer gets stuck in a Blue Screen of Death (BSOD) loop. Every time I try to log in to my Windows account, the computer crashes and restarts, and then immediately goes back to the login screen. It doesn’t matter if I try to log in with my admin account or guest account, or even try to boot in safe mode – the same thing happens every time. The BSOD says that the problem is caused by a driver or hardware issue, but I’ve tried updating all my drivers and running a disk check with no luck. Read More
How to enable Secure Boot on AMD based Gigabyte motherboards?
I’ve checked the BIOS settings and I see the option to enable Secure Boot, but every time I try to enable it, I get an error message saying that Secure Boot is not supported by my CPU or motherboard. I’ve tried updating my BIOS to the latest version, but the issue persists. I’ve also checked online documentation and tutorials for similar motherboards, but none of them seem to mention this specific issue. I’m not sure what I’m doing wrong or what I need to do to get Secure Boot working. Can anyone help me troubleshoot this or provide a solution?
I’ve checked the BIOS settings and I see the option to enable Secure Boot, but every time I try to enable it, I get an error message saying that Secure Boot is not supported by my CPU or motherboard. I’ve tried updating my BIOS to the latest version, but the issue persists. I’ve also checked online documentation and tutorials for similar motherboards, but none of them seem to mention this specific issue. I’m not sure what I’m doing wrong or what I need to do to get Secure Boot working. Can anyone help me troubleshoot this or provide a solution? Read More
Azure stack 23h2 – Control plane
Hi all,
What happens if you delete by accident Control plane local linux appliance after building all cluster in azure. Is there a way to restore it? Please dont tell me you have to rebuild cluster
Hi all,What happens if you delete by accident Control plane local linux appliance after building all cluster in azure. Is there a way to restore it? Please dont tell me you have to rebuild cluster Read More
MVP/RDs United to Inspire: European Cloud Summit 2024
The European Cloud Summit, a conference where technologists from across Europe gather to learn about the latest AI and cloud technologies and connect with tech experts, industry leaders, and Microsoft members, was held in mid-May. This year’s event was combined with the European Collaboration Summit, offering attendees a chance to engage with the latest developments in a wide range of Microsoft technologies, including modern work, Microsoft 365, and Copilot, attracting over 3,000 participants.
This conference was a highly valuable three-day event for attendees who came to enhance their technical skills and apply them in their businesses. It offered sessions where participants could consume the latest technological information and use cases, including keynote speeches. Additionally, there were Pre-day Tutorial sessions, booth exhibits, and panel discussions at the EXPO.
Many leaders from the tech community, including Microsoft MVPs and Regional Directors (RDs), attended and significantly contributed to the conference by sharing their knowledge and insights as speakers. In this blog post, we interviewed two of these MVP and RD speakers to reflect on their conference experiences.
Damir Dizdarevic, a Cloud and Datacenter Management MVP and RD from Bosnia and Herzegovina, who spoke on the Business Stage session “New generation of cyber attacks and what businesses should know about that,” reflects on the conference as a great community event. He says, “It is driven by the passionate work of the few very enthusiastic people, all MVPs and/or RDs. This year, it was even bigger than ever before, but it is really not just about the number of people or number of sessions. For me, as a long-term speaker and an MVP, this conference is quite specific as it really covers not just a lot of topics, but also a different perspective.”
Regarding the unique aspects of this year’s conference, Damir shares his reflection, “This year, as expected, a lot of content was about AI and sessions were chosen in a way that everyone was able to learn about AI, no matter how much they know (or don’t know) about it already. Also, I liked the panels that were organized in Expo space – other attendees were also quite attracted to them. Being able to speak with quite a few Microsoft people was also one of the benefits of this conference. And this year, there were many sessions on the business stage, which means that the audience expanded to business people too.”
From his perspective as an RD with extensive business experience, Damir tells us the impact of this conference on technology users. “I noticed that most sessions on the business stage were full of people. My session was also on the business stage, and I talked about what CxO and BDM people should know about the new generation of cyber-attacks. I was quite surprised to see that there are many BDMs not aware that a lot of things have changed when it comes to security. Raising awareness about new technologies, new challenges and new opportunities is something that is the real value of having a business stage, even on community-driven conferences. While talking to attendees of my session, I realized that BDMs and CxO really need sessions where they can learn and better understand technologies that affect their core business,” says Damir.
Jussi Roine, a Security MVP from Finland and speaker of two sessions, “Microsoft Copilot(s) Powerclass” and “Copilot for Security Deep Dive,” says this conference is the highlight of his spring each year. “It’s very community oriented, and you get to meet awesome speakers and an enthusiastic audience at the same time in a beautiful setting. I’ve lost count of how many times I’ve attended and delivered sessions at the event and this year was the largest so far. The highlight for me was the breadth of content from the diverse set of speakers, and I got to finally meet so many people I’ve known on social media, but this time in person.”
Jussi recalled receiving numerous questions from attendees about Copilot for Security during and after his sessions. “People are piecing together Defender for Cloud, Microsoft Sentinel, Defender XDR and Copilot for Security, and the questions revolved around cost management, governance and compliance. It’s a relatively new capability, so I felt that the feedback was also based on the audience wanting to try it out, once they had more information on the how’s and the what’s,” says Jussi.
The next event, the European AI and Cloud Summit, has already been announced for May 26-28, 2025, in Düsseldorf, Germany. While the detailed agenda, including session information, has not yet been released, participants can look forward to learning about the latest advancements in AI and cloud technologies at that time.
For information on this year’s conference speakers and sessions, as well as the latest updates on the upcoming conference, please visit the official website and follow the posts on European AI and Cloud Summit LinkedIn.
*MVP profile details as of June 30, 2024.
Microsoft Tech Community – Latest Blogs –Read More
Microsoft Word – Getting rid of unused fields in equations (small dotted squares)
Dear All,
I have several Word documents containing equations, and I did not use all the proposed fields. For example, an operation can have an upper limit and a lower limit, and sometimes I don’t need both. The fields I didn’t need, I left them blank, so they show a small dotted square in Word.
Unfortuntely, the PDF and the printed version still shows those empty squares.
Is there any way, without editing each of my equations (:anxious_face_with_sweat:), to get rid of all those empty squares when I export my file to a PDF, so that they don’t show when printed?
Many thanks!
Dear All,I have several Word documents containing equations, and I did not use all the proposed fields. For example, an operation can have an upper limit and a lower limit, and sometimes I don’t need both. The fields I didn’t need, I left them blank, so they show a small dotted square in Word. Unfortuntely, the PDF and the printed version still shows those empty squares. Is there any way, without editing each of my equations (:anxious_face_with_sweat:), to get rid of all those empty squares when I export my file to a PDF, so that they don’t show when printed? Many thanks! Read More
how to put curly brackets at bottom of the equation?
Hello experts,
I would like to know how to put curly brackets at bottom of the equation in ms word document. I have tried but I was not able to do it, I need experts guidance.
Attached is the image for your reference to understand my question.
Quicker reply will help alot.
Thank you.
Hello experts, I would like to know how to put curly brackets at bottom of the equation in ms word document. I have tried but I was not able to do it, I need experts guidance. Attached is the image for your reference to understand my question.Quicker reply will help alot.Thank you. Read More
How to make multiple “date” rules against “today” in a single column of data
Hi,
I have to monitor many clients and be able to order the data based on when they were referred in from oldest to newest. But in addition, I would like to make them RED, AMBER or GREEN based on how old they are against the current date (ie today).
EG;
– More than 2 days old = GREEN
– More than 3 days old = AMBER
– More than 5 days old = RED
Can someone tell me the formula I should use, or how I can set the rules under conditional formatting?
Thanks
Hi,I have to monitor many clients and be able to order the data based on when they were referred in from oldest to newest. But in addition, I would like to make them RED, AMBER or GREEN based on how old they are against the current date (ie today).EG;- More than 2 days old = GREEN- More than 3 days old = AMBER- More than 5 days old = REDCan someone tell me the formula I should use, or how I can set the rules under conditional formatting? Thanks Read More
Multiple IF in one cell
Hi
I need some assistance writing a formula with the following specifics:
“If A1 contains a value lower than 59% then return 0, and if A1 contains a value greater than 59% but lower than 75% then return 1, and if A1 contains a value greater than 74% but lower than 85% then return 2.5, and if A1 contains a value greater than 84% then return 5”
I managed to get the first 2 working =IF(AND(B12<59%), “0”, IF(AND(B12>59%, B12<75%), “1”,”0″)) but can’t seem to add the others.
Thanks for the help 🙂
Hi I need some assistance writing a formula with the following specifics: “If A1 contains a value lower than 59% then return 0, and if A1 contains a value greater than 59% but lower than 75% then return 1, and if A1 contains a value greater than 74% but lower than 85% then return 2.5, and if A1 contains a value greater than 84% then return 5” I managed to get the first 2 working =IF(AND(B12<59%), “0”, IF(AND(B12>59%, B12<75%), “1”,”0″)) but can’t seem to add the others. Thanks for the help 🙂 Read More
How to reinstall Windows 10 from usb without losing files?
I need to reinstall Windows 10 on my computer and I’ve heard that it can be done using a USB drive. However, I’m not entirely sure about the steps involved in creating a bootable USB and then using it to reinstall the OS. Could someone please provide a detailed, step-by-step guide on how to reinstall Windows 10 from USB? Here are a few specific questions I have:
What tools do I need to create a bootable USB drive?How do I prepare the USB drive for the installation?What are the steps to follow during the installation process?Possible to keep the files and apps during reinstallation?
Thanks for your help!
I need to reinstall Windows 10 on my computer and I’ve heard that it can be done using a USB drive. However, I’m not entirely sure about the steps involved in creating a bootable USB and then using it to reinstall the OS. Could someone please provide a detailed, step-by-step guide on how to reinstall Windows 10 from USB? Here are a few specific questions I have: What tools do I need to create a bootable USB drive?How do I prepare the USB drive for the installation?What are the steps to follow during the installation process?Possible to keep the files and apps during reinstallation? Thanks for your help! Read More