Category: Microsoft
Category Archives: Microsoft
XLOOKUP for multiple lookup ranges
Hello,
I’m trying to populate an interactive calendar with dates that a team member will be working. I have been using the XLOOKUP function to do this and can get it working for a single date. Ideally this needs to be a variable date range as I dont want to have to manually input a new formula into the calendar each time. Can XLOOKUP search multiple ranges? I.e searching to see if the date on the calendar matches either cell $B3:$B4 &:$D3:$D4 and then populating the calendar with the persons name?
current formula is as follows : =XLOOKUP(D8,Sheet1!B3:B23,Sheet1!E3:E23)
Screenshots attached.
Hello, I’m trying to populate an interactive calendar with dates that a team member will be working. I have been using the XLOOKUP function to do this and can get it working for a single date. Ideally this needs to be a variable date range as I dont want to have to manually input a new formula into the calendar each time. Can XLOOKUP search multiple ranges? I.e searching to see if the date on the calendar matches either cell $B3:$B4 &:$D3:$D4 and then populating the calendar with the persons name? current formula is as follows : =XLOOKUP(D8,Sheet1!B3:B23,Sheet1!E3:E23) Screenshots attached. Read More
Automate transpose every 5 rows into 5 columns
Hello,
I want to transpose every 5 rows into 5 columns
From this :
into this :
Is there any way to do it in one go ?
Thank you!
Hello, I want to transpose every 5 rows into 5 columns From this : into this : Is there any way to do it in one go ? Thank you! Read More
Unable to book an exam
Hello together,
I noticed that if anyone is clicking on “book appointment via person-vue a blank page appears:
Buchung über Pearson Vue | Microsoft Learn
my colleagues have the same problem for all exams. I wasnt able to find a support or contact page because they dont work as well.
Hello together,I noticed that if anyone is clicking on “book appointment via person-vue a blank page appears: Buchung über Pearson Vue | Microsoft Learn my colleagues have the same problem for all exams. I wasnt able to find a support or contact page because they dont work as well. Read More
Some of my contacts are not appearing in my Address Book
I have about 400 Gmail contacts that I want to export to Outlook 365 (Win 10). I’ve exported the .CSV from Gmail and ran the import OK. Annoyingly, some entries in Contacts are not showing up in the Address Book. I’ve tried creating a second Contacts folder and copied all contacts from the first folder, ticking the box which says it can be accessed from Address Book, but it makes no difference. What am I doing wrong?
I have about 400 Gmail contacts that I want to export to Outlook 365 (Win 10). I’ve exported the .CSV from Gmail and ran the import OK. Annoyingly, some entries in Contacts are not showing up in the Address Book. I’ve tried creating a second Contacts folder and copied all contacts from the first folder, ticking the box which says it can be accessed from Address Book, but it makes no difference. What am I doing wrong? Read More
Can you share any best practices for cost optimization in Azure?
Azure offers a vast array of cloud services, but managing those services can lead to unexpected costs. The good news is that there are well-defined practices you can implement to optimize your Azure spending and ensure you’re getting the most value. Here’s a breakdown of key strategies to consider:
Eliminate Waste: Shut Down Unused Resources
Azure resources like virtual machines (VMs) that are left idle continue to accrue charges. Utilize Azure Advisor, a built-in service, to identify inactive resources and power them down when not in use.
Rightsize Underutilized Resources
Not all resources require top-of-the-line specifications. Analyze your VM usage with Azure Advisor’s recommendations. You can often scale down to a smaller VM size and save on costs without impacting performance.
Leverage Committed Use Discounts
Azure offers significant savings for predictable workloads through Reserved Instances and Savings Plans. With these options, you prepay for a certain level of compute resources for a set term (one or three years) at a discounted rate compared to pay-as-you-go pricing.
Optimize Storage Costs
Azure Storage provides various tiers – hot, cool, and archive – suited for different data access frequencies. Hot storage is ideal for frequently accessed data, while cool and archive tiers are more cost-effective for less frequently used information.
Embrace Automation for Cost Management
Setting up automated rules can streamline cost optimization. Azure allows you to configure alerts for exceeding spending thresholds and automate VM shutdowns during non-working hours.
Cultivate a Culture of Cost Awareness
Educate your team on cost-saving practices. Encourage responsible resource allocation and promote shutting down unused resources.
Monitor and Refine Continuously
Cloud environments are dynamic. Regularly assess your resource usage and costs. Azure Cost Management tools offer detailed insights to help you identify areas for further optimization.
By implementing these best practices, you can significantly reduce your Azure expenses without compromising performance. Remember, cost optimization is an ongoing process. As your cloud usage evolves, stay vigilant and adapt your strategies to maintain an efficient and cost-effective Azure environment.
Azure offers a vast array of cloud services, but managing those services can lead to unexpected costs. The good news is that there are well-defined practices you can implement to optimize your Azure spending and ensure you’re getting the most value. Here’s a breakdown of key strategies to consider:Eliminate Waste: Shut Down Unused ResourcesAzure resources like virtual machines (VMs) that are left idle continue to accrue charges. Utilize Azure Advisor, a built-in service, to identify inactive resources and power them down when not in use.Rightsize Underutilized ResourcesNot all resources require top-of-the-line specifications. Analyze your VM usage with Azure Advisor’s recommendations. You can often scale down to a smaller VM size and save on costs without impacting performance.Leverage Committed Use DiscountsAzure offers significant savings for predictable workloads through Reserved Instances and Savings Plans. With these options, you prepay for a certain level of compute resources for a set term (one or three years) at a discounted rate compared to pay-as-you-go pricing.Optimize Storage CostsAzure Storage provides various tiers – hot, cool, and archive – suited for different data access frequencies. Hot storage is ideal for frequently accessed data, while cool and archive tiers are more cost-effective for less frequently used information.Embrace Automation for Cost ManagementSetting up automated rules can streamline cost optimization. Azure allows you to configure alerts for exceeding spending thresholds and automate VM shutdowns during non-working hours.Cultivate a Culture of Cost AwarenessEducate your team on cost-saving practices. Encourage responsible resource allocation and promote shutting down unused resources.Monitor and Refine ContinuouslyCloud environments are dynamic. Regularly assess your resource usage and costs. Azure Cost Management tools offer detailed insights to help you identify areas for further optimization.By implementing these best practices, you can significantly reduce your Azure expenses without compromising performance. Remember, cost optimization is an ongoing process. As your cloud usage evolves, stay vigilant and adapt your strategies to maintain an efficient and cost-effective Azure environment. Read More
conditional formating error while converting figures in thousnads
ihave blocked some rows where figures were there
applied conditional format by settugn new rule
selected the last option in pop up
in the formula bar given as” $a$1=”yes”
the set the format to customs, “0.00,”
ihave blocked some rows where figures were there applied conditional format by settugn new ruleselected the last option in pop upin the formula bar given as” $a$1=”yes”the set the format to customs, “0.00,” Read More
OneDrive for Android: Camera Backup keeps uploading screenshots
Hi all,
Every so often when I check OneDrive, I see my Android phone has uploaded screenshots as well as camera photos.
In the Android app, when I check the Camera Backup setting, the “Back up device folders” has the setting “Camera, Screenshots”
However, when I click that value, and go into the “Organise new backups in subfolders” list, the Screenshots folder is _not_ actually selected as one to be uploaded.
If I turn the folder on, then off, OneDrive will temporarily not upload images from my Screenshot folder. But eventually, it decide that again it should do this.
How do I make this behaviour stop permanently?
P.
Hi all,Every so often when I check OneDrive, I see my Android phone has uploaded screenshots as well as camera photos.In the Android app, when I check the Camera Backup setting, the “Back up device folders” has the setting “Camera, Screenshots”However, when I click that value, and go into the “Organise new backups in subfolders” list, the Screenshots folder is _not_ actually selected as one to be uploaded.If I turn the folder on, then off, OneDrive will temporarily not upload images from my Screenshot folder. But eventually, it decide that again it should do this.How do I make this behaviour stop permanently? P. Read More
Intune Configuration for SMB – To Use Security Baselines or Not?
Hi,
What is the best strategy for Intune configuration/deployment for SMB’s?
Is using Security Baselines the best way to manage and secure a SMB? Or would utilizing the more granular settings deployment be the better option.
I am familiar with both, have deployed both and I have gotten different results. But I have yet to find that ‘Sweet Spot’ for total confidence in these deployments.
Would love to get some feedback, suggestions on this.
Thanks in advance.
Hi,What is the best strategy for Intune configuration/deployment for SMB’s?Is using Security Baselines the best way to manage and secure a SMB? Or would utilizing the more granular settings deployment be the better option.I am familiar with both, have deployed both and I have gotten different results. But I have yet to find that ‘Sweet Spot’ for total confidence in these deployments.Would love to get some feedback, suggestions on this.Thanks in advance. Read More
Using SharePoint framework i want make field read-only multiline text
Make read-only field using SharePoint Framework i am using SharePoint field customizer but it’s not working
Help would be great
Thanks
Make read-only field using SharePoint Framework i am using SharePoint field customizer but it’s not working Help would be great Thanks Read More
Power automate flow to automatically populates a sharepoint list with values from other sharepoint l
Good day
I have two lists, one called OutsideInt, and another called Business Department. The information in the OutsideInt is obtained via Power Automate collecting information from responders via Microsoft Forms.
In the OutsideInt list, there is four additional columns, that need to be populated from the Business Department list, called Exe, Exe Email, Bus, Bus Email.
I would like that whenever an item is created in OutsideInt via the form, that an automated flow will automatically get the information from Business Department and populate this to the corresponding columns in OutsideInt.
Good day I have two lists, one called OutsideInt, and another called Business Department. The information in the OutsideInt is obtained via Power Automate collecting information from responders via Microsoft Forms.In the OutsideInt list, there is four additional columns, that need to be populated from the Business Department list, called Exe, Exe Email, Bus, Bus Email. I would like that whenever an item is created in OutsideInt via the form, that an automated flow will automatically get the information from Business Department and populate this to the corresponding columns in OutsideInt. Read More
Is such a post -> Spam?
It has a lot of views, maybe that’s great information, please, help me explain it?
It has a lot of views, maybe that’s great information, please, help me explain it?Microsoft Windows 12 Brand Ambassador “Dolly Chaiwala” Became a trending topic – Microsoft Community Hub Read More
we couldn’t find a camera compatible with window hello face!
I am not able to use Windows Hello Face. I have tried all kinds of troubleshooting, but I am not able to use it. How can I fix it? It is repeatedly giving the error that we could not find a camera compatible with Windows Hello Face! I have also uninstalled the Facial Recognition (Windows Hello Face) optional feature and downloaded it again, but it is still not getting fixed. And my laptop camera is also working properly
I am not able to use Windows Hello Face. I have tried all kinds of troubleshooting, but I am not able to use it. How can I fix it? It is repeatedly giving the error that we could not find a camera compatible with Windows Hello Face! I have also uninstalled the Facial Recognition (Windows Hello Face) optional feature and downloaded it again, but it is still not getting fixed. And my laptop camera is also working properly Read More
Camera with black screen
Hello, I have encountered a black screen issues with the windows camera app on my laptop. I have tried various ways such as reinstalling the app and updating the windows driver but does not work.
The camera is able to detect the faces but does not show any images. May I know how can I fix this issue?
Thank you in advance.
Hello, I have encountered a black screen issues with the windows camera app on my laptop. I have tried various ways such as reinstalling the app and updating the windows driver but does not work. The camera is able to detect the faces but does not show any images. May I know how can I fix this issue? Thank you in advance. Read More
Adding 1 to Every Number in Formula String
Hi All,
I am working on many workbooks and for all of them, I am using conditional formatting for hundreds of cells. Specifically, I am using 7 different cell ranges, and the cells themselves are always one cell apart. For example, this is for one of the ranges (with hundreds more references in this range and in each range):
B$4:AS$4,B$9:AS$9,B$14:AS$14,B$19:AS$19
Is there a formula I can use to add +1 to every number, so I don’t have to do it manually? I can’t find an answer anywhere. Here is what I would need:
B$5:AS$5,B$10:AS$10,B$15:AS$15,B$20:AS$20
Thank you for the help.
Hi All, I am working on many workbooks and for all of them, I am using conditional formatting for hundreds of cells. Specifically, I am using 7 different cell ranges, and the cells themselves are always one cell apart. For example, this is for one of the ranges (with hundreds more references in this range and in each range): B$4:AS$4,B$9:AS$9,B$14:AS$14,B$19:AS$19 Is there a formula I can use to add +1 to every number, so I don’t have to do it manually? I can’t find an answer anywhere. Here is what I would need: B$5:AS$5,B$10:AS$10,B$15:AS$15,B$20:AS$20 Thank you for the help. Read More
Login failed for user ‘sp’. Reason: Password did not match that for the login provided
Please excuse my ignorance of basic SQL Server admin. Any advice much appreciated. I cannot login using passwords. For example:
C:Usersjohn>
C:Usersjohn>sqlcmd -s jw-lat -e
1> create login sp with password=’sp’;
2> go
create login sp with password=’sp’;
1> create user sp for login sp;
2> go
create user sp for login sp;
1> alter server role sysadmin add member [sp];
2> go
alter server role sysadmin add member [sp];
1> exit
C:Usersjohn>
C:Usersjohn>sqlcmd -s jw-lat,1433 -U sp -P ‘sp’
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Login failed for user ‘sp’..
C:Usersjohn>
In the SQL Server log I see this,
Date Sun 21 07 2024 14:26:33
Log SQL Server (Current – Sun 21 07 2024 14:26:00)
Source Logon
Message
Login failed for user ‘sp’. Reason: Password did not match that for the login provided. [CLIENT: <local machine>]
I have tried any number of variations on case and quotes. I must be missing something really basic?
Thankyou for any insight.
Please excuse my ignorance of basic SQL Server admin. Any advice much appreciated. I cannot login using passwords. For example:C:Usersjohn>
C:Usersjohn>sqlcmd -s jw-lat -e
1> create login sp with password=’sp’;
2> go
create login sp with password=’sp’;
1> create user sp for login sp;
2> go
create user sp for login sp;
1> alter server role sysadmin add member [sp];
2> go
alter server role sysadmin add member [sp];
1> exit
C:Usersjohn>
C:Usersjohn>sqlcmd -s jw-lat,1433 -U sp -P ‘sp’
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Login failed for user ‘sp’..
C:Usersjohn>In the SQL Server log I see this,Date Sun 21 07 2024 14:26:33
Log SQL Server (Current – Sun 21 07 2024 14:26:00)
Source Logon
Message
Login failed for user ‘sp’. Reason: Password did not match that for the login provided. [CLIENT: <local machine>]I have tried any number of variations on case and quotes. I must be missing something really basic?Thankyou for any insight. Read More
Latest Threat Intelligence (July 2024)
Latest Threat Intelligence (July 2024)
Microsoft Defender for IoT has released the July 2024 Threat Intelligence package. The package is available for download from the Microsoft Defender for IoT portal (click Updates, then Download file).
Threat Intelligence updates reflect the combined impact of proprietary research and threat intelligence carried out by Microsoft security teams. Each package contains the latest CVEs (Common Vulnerabilities and Exposures), IOCs (Indicators of Compromise), and other indicators applicable to IoT/ICS/OT networks (published during the past month) researched and implemented by Microsoft Threat Intelligence Research – CPS.
The CVE scores are aligned with the National Vulnerability Database (NVD). Starting with the August 2023 threat intelligence updates, CVSSv3 scores are shown if they are relevant; otherwise the CVSSv2 scores are shown.
Guidance
Customers are recommended to update their systems with the latest TI package in order to detect potential exposure risks and vulnerabilities in their networks and on their devices. Threat Intelligence packages are updated every month with the most up-to-date security information available, ensuring that Microsoft Defender for IoT can identify malicious actors and behaviors on devices.
Update your system with the latest TI package
The package is available for download from the Microsoft Defender for IoT portal (click Updates, then Download file), for more information, please review Update threat intelligence data | Microsoft Docs.
MD5 Hash: 323c19d85bc31e035d9154643b99a69c
For cloud connected sensors, Microsoft Defender for IoT can automatically update new threat intelligence packages following their release, click here for more information. Read More
Fastest way to read entire Word text to array
ReDim arr(1 To wdDoc.Paragraphs.Count)
For i = 1 To wdDoc.Paragraphs.Count
arr(i) = wdDoc.Paragraphs(i).Range
Next i
I got above code to read all Word text to a array. It’s very slow. What is the most efficient way? I guess even copy/paste in VBA would be faster, but I think there should be a better way.
Thanks in advance.
ReDim arr(1 To wdDoc.Paragraphs.Count)For i = 1 To wdDoc.Paragraphs.Countarr(i) = wdDoc.Paragraphs(i).RangeNext i I got above code to read all Word text to a array. It’s very slow. What is the most efficient way? I guess even copy/paste in VBA would be faster, but I think there should be a better way. Thanks in advance. Read More
[Mitigated] Azure Lab Services – Maintenance update outage
Hi,
We are experiencing a service outage due to ongoing maintenance since around July 21st, 4 pm PDT. The service is currently not available in any region. We will provide the next update as soon as we have additional progress to share.
Cheers,
Fawad
Microsoft Tech Community – Latest Blogs –Read More
Identity Source
Does anyone know where I can see the source of an identity (i.e. OKTA)?
Does anyone know where I can see the source of an identity (i.e. OKTA)? Read More
“Error using `Update-Help -UICulture zh-CN` in PowerShell v7.4.3.0.”
I am unable to update the Chinese help files using the Update-Help -UICulture zh-CN command in PowerShell version v7.4.3.0. The following error occurs:
Update-Help : Failed to update Help for the modules “ConfigDefender, ConfigDefenderPerformance, PSReadline” with UI culture {zh-CN}: Cannot retrieve the HelpInfo XML file for UI culture zh-CN. Make sure the HelpInfoUri property in the module manifest is valid or check your network connection and then try the command again.At line:1 char:1
+ Update-Help -UICulture zh-CN
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : ResourceUnavailable: (:) [Update-Help], Exception
+ FullyQualifiedErrorId : UnableToRetrieveHelpInfoXml,Microsoft.PowerShell.Commands.UpdateHelpCommand
I have tried the mainstream solutions, such as running the command Update-Help -ErrorAction SilentlyContinue, but it is still not working. Can anyone provide a solution?
I am unable to update the Chinese help files using the Update-Help -UICulture zh-CN command in PowerShell version v7.4.3.0. The following error occurs: Update-Help : Failed to update Help for the modules “ConfigDefender, ConfigDefenderPerformance, PSReadline” with UI culture {zh-CN}: Cannot retrieve the HelpInfo XML file for UI culture zh-CN. Make sure the HelpInfoUri property in the module manifest is valid or check your network connection and then try the command again.At line:1 char:1
+ Update-Help -UICulture zh-CN
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : ResourceUnavailable: (:) [Update-Help], Exception
+ FullyQualifiedErrorId : UnableToRetrieveHelpInfoXml,Microsoft.PowerShell.Commands.UpdateHelpCommandI have tried the mainstream solutions, such as running the command Update-Help -ErrorAction SilentlyContinue, but it is still not working. Can anyone provide a solution? Read More