Category: Microsoft
Category Archives: Microsoft
SPO List View/Edit Items Created by User – Can I Change the User?
We have an existing Excel sheet with many entries and need to make it a shared list in SPO. Each user should only be able to view or edit their own entries. The problem is the list will be pre-populated (by uploading the Excel file). Is there a way for me to set the viewing/editing rights of each entry to a particular user? I looked at the permissions for test entries added by two different users and did not see a difference in their permissions. How can I initially assign entries to users? Is it possible?
We have an existing Excel sheet with many entries and need to make it a shared list in SPO. Each user should only be able to view or edit their own entries. The problem is the list will be pre-populated (by uploading the Excel file). Is there a way for me to set the viewing/editing rights of each entry to a particular user? I looked at the permissions for test entries added by two different users and did not see a difference in their permissions. How can I initially assign entries to users? Is it possible? Read More
Help with Formula
I require help with this formula. I want Excel to highlight row 8 in red if cells C9 through C16 have more than one occurrence of numbers 1, 2, 3, or 5 input (refer to the color chart in the attached image). Currently, the row only highlights the day of the week if it is the same number in the column. I need the row to be highlighted with any combination of 1, 2, 3, or 5 if they appear in the same row. This is for tracking scheduling purposes and will indicate if there are multiple individuals on vacation, sick, or leaving early. Please see the example attached. Columns F and G should be highlighted, but the formula does not recognize them unless it is the same number in a column.
=OR(COUNTIF(C9:C16,1)>1,COUNTIF(C9:C16,2)>1,COUNTIF(C9:C16,3)>1)
I require help with this formula. I want Excel to highlight row 8 in red if cells C9 through C16 have more than one occurrence of numbers 1, 2, 3, or 5 input (refer to the color chart in the attached image). Currently, the row only highlights the day of the week if it is the same number in the column. I need the row to be highlighted with any combination of 1, 2, 3, or 5 if they appear in the same row. This is for tracking scheduling purposes and will indicate if there are multiple individuals on vacation, sick, or leaving early. Please see the example attached. Columns F and G should be highlighted, but the formula does not recognize them unless it is the same number in a column. =OR(COUNTIF(C9:C16,1)>1,COUNTIF(C9:C16,2)>1,COUNTIF(C9:C16,3)>1) Read More
Change the percentage scale of an OKR in Viva Goals
Our OKR is measured as a percentage that’s automated daily via a Kusto query. We would like to change the scale of the OKR in Viva Goals so that the Y axis goes from 80% to 100% instead of 0% to 100%. Is this possible, if so how? And can it be done without losing data/history?
Our OKR is measured as a percentage that’s automated daily via a Kusto query. We would like to change the scale of the OKR in Viva Goals so that the Y axis goes from 80% to 100% instead of 0% to 100%. Is this possible, if so how? And can it be done without losing data/history?
Read More
How do you set “Bookings with me” private meeting links that don’t expire?
As a time-saver, I am a huge fan of templates. Copy/Paste/Send. Unfortunately, unlike the company Bookings page meeting links, the “Bookings with me” links expire, even when it is not a single-use link.
How can I prevent link expiration? I can’t find any documentation on this.
Thanks.
As a time-saver, I am a huge fan of templates. Copy/Paste/Send. Unfortunately, unlike the company Bookings page meeting links, the “Bookings with me” links expire, even when it is not a single-use link. How can I prevent link expiration? I can’t find any documentation on this. Thanks. Read More
Multiple Language Invitations
We are migrating next month with our first Viva-Glint pulse administration slated for September.
One of the questions I haven’t been able to solve for so far is the lack of external links or multiple languages being included in survey invites.
We are multi-national and survey in 20 languages. In the past we would send out English invitations with a top banner of links to internal translations in the other 19 languages. It is my understanding that these links will no longer be possible.
The suggestions we have received are to send out invites in the local languages based on country code, but we have a lot of international movement and don’t want to guess at what language people might want.
I’m curious to hear how other companies that have already gone through migration are navigating this change. I feel like this is a big obstacle and may impact our response rate.
Thanks!
We are migrating next month with our first Viva-Glint pulse administration slated for September.One of the questions I haven’t been able to solve for so far is the lack of external links or multiple languages being included in survey invites.We are multi-national and survey in 20 languages. In the past we would send out English invitations with a top banner of links to internal translations in the other 19 languages. It is my understanding that these links will no longer be possible. The suggestions we have received are to send out invites in the local languages based on country code, but we have a lot of international movement and don’t want to guess at what language people might want. I’m curious to hear how other companies that have already gone through migration are navigating this change. I feel like this is a big obstacle and may impact our response rate.Thanks! Read More
Windows 10 is hopeless omy laptop
My laptop crashed recently and there was no way back. I bought a secondhand laptop with more RAM and I had Windows 10 installed by a professional. I cannot get Windows 10 to run properly. If I try to search Google it does nothing unless I keep emptying the cache all the time. If I play a Microsoft game like Solitaire it keeps freezing when I try to access the game. It’s really annoying. The laptop with less RAM had no problems. Is there anything I can do?
My laptop crashed recently and there was no way back. I bought a secondhand laptop with more RAM and I had Windows 10 installed by a professional. I cannot get Windows 10 to run properly. If I try to search Google it does nothing unless I keep emptying the cache all the time. If I play a Microsoft game like Solitaire it keeps freezing when I try to access the game. It’s really annoying. The laptop with less RAM had no problems. Is there anything I can do? Read More
can’t restore from ios backup after enrolling onto intunes
Hi,
i have had to restore an ios device and enroll back onto intunes. this is done via apple configurator to apple business manager and subsequently onto intunes via enrollment tokens. the problem is i want to restore the device from a previous backup which then resets the device all over. and the intune data from that backup is not valid as the device was deleted on intunes during that period. it seems easy but this is proving difficult. i have followed these steps however these options are working for me Back up and restore iOS/iPadOS – Microsoft Intune | Microsoft Learn
i tried downloading company portal and logging in – it finds my details and devices however when it goes to sync with intunes to confirm device settings – it just hangs. there is ‘some’ communication as i can see the device in the device overview screen. but it says ‘not evaluated’ any help appreciated. thank you in advance
Hi,i have had to restore an ios device and enroll back onto intunes. this is done via apple configurator to apple business manager and subsequently onto intunes via enrollment tokens. the problem is i want to restore the device from a previous backup which then resets the device all over. and the intune data from that backup is not valid as the device was deleted on intunes during that period. it seems easy but this is proving difficult. i have followed these steps however these options are working for me Back up and restore iOS/iPadOS – Microsoft Intune | Microsoft Learni tried downloading company portal and logging in – it finds my details and devices however when it goes to sync with intunes to confirm device settings – it just hangs. there is ‘some’ communication as i can see the device in the device overview screen. but it says ‘not evaluated’ any help appreciated. thank you in advance Read More
Windows server
Hello community , I am trying to mount a windows server iso file onto a virtual machine yet always seems to softlock during booting. Has anyone been experiencing a similar issue?
Hello community , I am trying to mount a windows server iso file onto a virtual machine yet always seems to softlock during booting. Has anyone been experiencing a similar issue? Read More
Embed Code including Plus sign
<iframe width=”856
” height=”480
” src=”https://apps.powerapps.com/play/e/ … &BRG=P+BRG” title=”Pride Plus BRG”></iframe>
Above is the code I’m trying to use to embed a PowerApp into a SharePoint page. It works perfectly on every other option/acronym I try. It would “seem” that the plus (+) symbol is the issue. However, AI continues to tell me I can use the Plus (+) sign in an embed code.
Can someone help me clarify and/or correct this? Is there some way I can adapt so I can use a Plus(+) symbol within an embed code.
Thank you in advance.
<iframe width=”856″ height=”480″ src=”https://apps.powerapps.com/play/e/ … &BRG=P+BRG” title=”Pride Plus BRG”></iframe>Above is the code I’m trying to use to embed a PowerApp into a SharePoint page. It works perfectly on every other option/acronym I try. It would “seem” that the plus (+) symbol is the issue. However, AI continues to tell me I can use the Plus (+) sign in an embed code. Can someone help me clarify and/or correct this? Is there some way I can adapt so I can use a Plus(+) symbol within an embed code. Thank you in advance. Read More
Two datasets in one histogram
Hi,
I have a problem. I have tried for a time to get this right aaaand it does not work, although I have tried a numbered on YT videos they have not worked. Basically I want to have multiple datasets displayed in a histogram, basically a double bar histogram. I have a screenshot of my problem, O1 and P1 are the datasets with the data in the column respectively. If I ad the “explanation” only “Min V” is shown and not “Max V” with separate bars included in, for example, orange. N1 is Sector, basically every sector have a “Min V” and a “Max V”, I want the values for every sector separated in 4 bars, both for “Min V” and “Max V” where the amount of sectors are counted on the Y-axis.
Is there anyone who knows what I can to?? Please show my, preferable with a video alternative if it is possible!!
Hi, I have a problem. I have tried for a time to get this right aaaand it does not work, although I have tried a numbered on YT videos they have not worked. Basically I want to have multiple datasets displayed in a histogram, basically a double bar histogram. I have a screenshot of my problem, O1 and P1 are the datasets with the data in the column respectively. If I ad the “explanation” only “Min V” is shown and not “Max V” with separate bars included in, for example, orange. N1 is Sector, basically every sector have a “Min V” and a “Max V”, I want the values for every sector separated in 4 bars, both for “Min V” and “Max V” where the amount of sectors are counted on the Y-axis. Is there anyone who knows what I can to?? Please show my, preferable with a video alternative if it is possible!! Read More
Need Powershell script to remove versioning from SharePoint Doc Library with over 500,000 items
We have recently been “recalculated” by Microsoft forcing us to purchase 1 Tb more space which is extremely expensive. We must be using at least 300Gb or so of versioning but cannot find a script that’s reliable, works with MFA and will work with over 500,000 files.
Is there anything recent that is reliable and works?
We have recently been “recalculated” by Microsoft forcing us to purchase 1 Tb more space which is extremely expensive. We must be using at least 300Gb or so of versioning but cannot find a script that’s reliable, works with MFA and will work with over 500,000 files. Is there anything recent that is reliable and works? Read More
Bookings confirmation email shows 24 hours difference than actual appointment
Customer A got an email confirmation that shows an appointment on May 22 at 10:00 am PDT
Customer A shows up on the staff member’s calendar (and Bookings interface calendar) on May 21 at 10:00 am PDT
Customer B booked an appointment for May 22 at 10:00 am PDT
Customer B shows up on the staff member’s calendar (and Bookings interface calendar) for May 22 at 10:00 am PDT
Time is Pacific time on the time zone settings, but the “always show slots in business time zone” is not checked
Calendar events effect availability is checked for the staff member
Use Default scheduling policy (on service) is not selected
Bookable when staff are free is set on the service
Only 1 staff member is listed and available for the service that both customers selected
It is unknown what day Customer A actually selected
Both customers are using email addresses that are the same custom domain through Google workspace
Is there a setting I’m missing somewhere or is this just a fluke?
Customer A got an email confirmation that shows an appointment on May 22 at 10:00 am PDTCustomer A shows up on the staff member’s calendar (and Bookings interface calendar) on May 21 at 10:00 am PDTCustomer B booked an appointment for May 22 at 10:00 am PDTCustomer B shows up on the staff member’s calendar (and Bookings interface calendar) for May 22 at 10:00 am PDT Time is Pacific time on the time zone settings, but the “always show slots in business time zone” is not checkedCalendar events effect availability is checked for the staff memberUse Default scheduling policy (on service) is not selectedBookable when staff are free is set on the serviceOnly 1 staff member is listed and available for the service that both customers selectedIt is unknown what day Customer A actually selectedBoth customers are using email addresses that are the same custom domain through Google workspaceIs there a setting I’m missing somewhere or is this just a fluke? Read More
Smart Research with Copilot for Microsoft 365 – HLS Copilot Snacks
How Copilot can help you find, organize, and cite relevant sources for your projects
Copilot for Microsoft 365 is a powerful tool that can assist you with conducting research for your academic or professional projects. Copilot can help you find reliable and relevant sources from various databases, websites, and journals, and suggest the best ones for your topic. Copilot can also help you organize your sources in a logical and coherent way, and generate citations and references in the style of your choice. Copilot can also help you avoid plagiarism and ensure that your research is original and ethical. With Copilot, you can save time and effort, and focus on writing high-quality and well-researched documents.
In this HLS Copilot Snack, I show how easy it is to conduct research into a given topic leveraging Copilot from within Microsoft Teams.
To see all HLS Copilot Snacks video click here.
Resources:
Copilot in Microsoft Teams help & learning (cloud.microsoft)
Introducing the new Microsoft Copilot experience in Teams – Microsoft Community Hub
Microsoft Copilot for Microsoft 365 documentation | Microsoft Learn
Prompt used: What are the biggest announcements to come out of the Microsoft Build 2024 Conference?
To see all HLS Copilot Snacks video click here.
Thanks for visiting – Michael Gannotti LinkedIn
Microsoft Tech Community – Latest Blogs –Read More
Windows Hardware Compatibility Program – Guidance for Windows 11, version 24H2 Release
To facilitate the release of Windows 11, version 24H2, and Windows Server 2025, the Windows Hardware Compatibility Program is set to accept submissions. The submission package must fulfill the prerequisites to guarantee compatibility between the operating system and the Hardware Lab Kit (HLK).
New Agreement – Please review and take action on the latest agreement update to avoid service interruption following the effective date of the new agreement.
Windows Hardware Compatibility Requirements – https://aka.ms/whcp
Submission Pre-requisites
OS and HLK minimum acceptable build:
Windows 11, version 24H2 (Build 26100 or greater)
Windows Server 2025 (Build 26100 or greater)
Playlist – https://aka.ms/hlkplaylist
The table below illustrates the required playlists for testing each processor architecture:
Target Architecture
Required Playlist(s)
Client (ARM64) 1
HLK Version 24H2 CompatPlaylist x64 ARM64.xml
HLK Version 24H2 CompatPlaylist ARM64_x86_on_ARM64.xml
HLK Version 24H2 CompatPlaylist ARM64_x64_on_ARM64.xml
Client (X64)
HLK Version 24H2 CompatPlaylist x64 ARM64.xml
Server (X64, ARM64)
HLK Version 24H2 CompatPlaylist x64 ARM64 SERVER.xml
1 For Client system-level x64 and ARM64 submission, the only playlist required is the HLK Version 24H2 CompatPlaylist x64 ARM64.xml
Please refer to the HLK Getting Started Guide for details on HLK client setup and playlist use.
Deferment of Partner Dev Center SBOM Validation
The WHCP requirement, for partner SBOM submissions alongside driver packages submitted to HDC, will be deferred at HDC. Partners will be given notice as soon as there is a set enforcement date during a future release, along with guidance on how to meet any new requirements.
WHCP continues to support a secure supply chain throughout our signing process. That said, the EO on Cyber Security is a call to action from the U.S. Government, so we continue to encourage that our partners seek to enable a secure supply chain as stated in the NIST guidance.
Device.DevFund.StaticTools Requirement
The Device.DevFund.StaticTools requirement applies to Windows 11 Client x64 and Windows Server x64.
Helpful information about how to use CodeQL and generate DVL files is available here – CodeQL and the Static Tools Logo Test – Windows drivers | Microsoft Learn
Microsoft Tech Community – Latest Blogs –Read More
Remove Ad for Copilot Pro from Word iPad toolbar
Recently this icon appeared on my toolbar in Word 365 on iPad. It’s an ad for purchasing Copilot Pro, and it is in the first position on the top-right toolbar. Not only that but it obscures the center toolbar, and I can find no setting or method to get rid of it.
The toolbar is not the place for ads on a paid product–especially not ones that cover up the actual software functions–and I have no interest in Copilot Pro. There needs to be a setting to remove this ad.
Recently this icon appeared on my toolbar in Word 365 on iPad. It’s an ad for purchasing Copilot Pro, and it is in the first position on the top-right toolbar. Not only that but it obscures the center toolbar, and I can find no setting or method to get rid of it.The toolbar is not the place for ads on a paid product–especially not ones that cover up the actual software functions–and I have no interest in Copilot Pro. There needs to be a setting to remove this ad. Read More
Excel Read Only mode. Use another account to activate Microsoft 365
I am using Office 365 on Mac.
When I open Excel, it opens spreadsheets in Read Only mode.
There is an Activate button at the top of the spreadsheet.
When I click Activate, a messages displays:
“Your account <account name> can view documents but it doesn’t allow editing on a. a Mac. To edit, user another account to activate Microsoft 365.”
I have tried logging in with other users, but same message.
Company IT Support told me the only way to resolve the issue is to reset my laptop entirely which will lose all of my work.
Is there any other way to resolve this read only issue?
Thanks.
I am using Office 365 on Mac. When I open Excel, it opens spreadsheets in Read Only mode. There is an Activate button at the top of the spreadsheet. When I click Activate, a messages displays:”Your account <account name> can view documents but it doesn’t allow editing on a. a Mac. To edit, user another account to activate Microsoft 365.” I have tried logging in with other users, but same message. Company IT Support told me the only way to resolve the issue is to reset my laptop entirely which will lose all of my work. Is there any other way to resolve this read only issue? Thanks. Read More
Search and delete
I have two sheets. With cell A company names, cell B email addresses and cell C the status.
In sheet 1 I have a complete list of 9000 rows. in sheet 2 I have a list of 1000 rows with the status “Approached”
So I have already approached these companies. I now want All company names, email addresses in Sheet 2 to be deleted in Sheet 1, how can I do this?
I have two sheets. With cell A company names, cell B email addresses and cell C the status.In sheet 1 I have a complete list of 9000 rows. in sheet 2 I have a list of 1000 rows with the status “Approached” So I have already approached these companies. I now want All company names, email addresses in Sheet 2 to be deleted in Sheet 1, how can I do this? Read More
Learnings from a Microsoft customer’s Azure OpenAI implementation
Check out this blog that explores how the testing of various Azure OpenAI use cases led one innovative company to realize increased productivity and cost-savings across the business.
Learnings from a Microsoft customer’s Azure OpenAI implementation | Microsoft
Enseignements tirés de la mise en œuvre d’Azure OpenAIpar un client de Microsoft | Microsoft
Aprendizajesde la implementaciónde Azure OpenAI de un clientede Microsoft | Microsoft
Aprendizados da implementação do Azure OpenAI de um cliente da Microsoft | Microsoft
Check out this blog that explores how the testing of various Azure OpenAI use cases led one innovative company to realize increased productivity and cost-savings across the business.
Learnings from a Microsoft customer’s Azure OpenAI implementation | Microsoft
Enseignements tirés de la mise en œuvre d’Azure OpenAIpar un client de Microsoft | Microsoft
Aprendizajesde la implementaciónde Azure OpenAI de un clientede Microsoft | Microsoft
Aprendizados da implementação do Azure OpenAI de um cliente da Microsoft | Microsoft Read More
General Availability of Kubernetes Event-Driven Autoscaler (KEDA) in Azure Portal
Kubernetes Event-Driven Autoscaler (KEDA) is an open-source, lightweight component that allows users to autoscale container workloads on events in external scalers. KEDA extends the functionality of the native Kubernetes Horizontal Pod Autoscaler (HPA) with a wide variety of scalers and scale-to-zero capabilities, thus allowing user applications to meet demand in a more sustainable and cost-efficient manner.
Today, we are excited to announce that the Azure Portal now supports KEDA scaling on memory, CPU, cron and Azure Service Bus scalers. Users will be able to easily create scaled objects and monitor their scaled objects and jobs all within the Portal interface, and for Azure Service Bus, Portal will handle the deployment and configuration of workload identity. This will streamline the creation and management of KEDA resources through the Portal interface.
What is KEDA and why use it?
KEDA is a Kubernetes-based event-driven autoscaler that can scale applications in Kubernetes based on metrics from external scalers. KEDA also supports scaling workloads to zero when there are no events to process and scaling them back up when events occur. This way, users can optimize their resource utilization and reduce their costs.
KEDA works by creating custom resources in Kubernetes that define the scaling logic and the external scaler to use. KEDA then creates an HPA for each ScaledObject and monitors the metrics from the external scaler to adjust the number of pods accordingly. KEDA also supports scaling on metrics from the Kubernetes metrics server, such as memory and CPU usage.
How to use KEDA in the Azure Portal
Azure Portal, a web-based interface that allows users to manage their Azure resources and services, now supports creating KEDA ScaledObjects and monitoring ScaledObjects and ScaledJobs in just a few clicks. Users can also view the status and current metrics of their KEDA resources, as well as all KEDA events and warnings.
To scale with KEDA through the Azure Portal, users need to have a Kubernetes cluster with the AKS KEDA add-on enabled, as well as an Azure subscription. Users can then follow these steps:
Navigate to the Workloads tab, select a workload, and select “Scale” from the top menu, or select the “Application scaling” tab from the left menu.
Enable the AKS KEDA add-on if not already enabled.
Click on the “Create” button to create a new ScaledObject.
Fill in the required fields, such as the name, namespace, workload type, workload name, and trigger details. Please note that the autoscaling of Kubernetes system deployments is not recommended and thus disabled through the Portal experience.
Click on the “Create” button to deploy the KEDA resource.
For the Azure Service Bus scaler, Portal will automatically create and assign a managed identity to the workload and grant it the necessary permissions to access the Service Bus namespace and queue or topic.
Go back to the “Application scaling” tab and select the resource to view its details, such as the current and desired metric and current replicas.
Conclusion
KEDA in the Azure Portal makes it easy and convenient for users to create and monitor KEDA resources that scale container workloads on events in Kubernetes. Users can now enjoy the benefits of KEDA and Azure Portal to run their event-driven applications in a scalable and cost-effective way.
Microsoft Tech Community – Latest Blogs –Read More
How to Resolve QuickBooks Error 80070057 Can’t Access Company File
I am encountering an issue with QuickBooks where I cannot access my company file. The error code displayed is 80070057. I’ve tried a few troubleshooting steps, but the problem persists. Can you please assist me in resolving this issue?
I am encountering an issue with QuickBooks where I cannot access my company file. The error code displayed is 80070057. I’ve tried a few troubleshooting steps, but the problem persists. Can you please assist me in resolving this issue? Read More
