Tag Archives: microsoft
“selection contains cells with error”
Hello, maybe someone knows the solution ? my user has this strange errors in big SharePoint list, when type any amount. This issue is only for one user, not replicable on other PC. She uses Edge to open it, and this issue started suddenly.
Thank you
Hello, maybe someone knows the solution ? my user has this strange errors in big SharePoint list, when type any amount. This issue is only for one user, not replicable on other PC. She uses Edge to open it, and this issue started suddenly. Thank you Read More
Is there a plan to deprecate MDC Secure score and classic recommendations
With new Risk-based recommendations in place and old recommendations going into classic view, is there a plan to deprecate the MDC Secure score and classic recommendations?
The Secure score of MDC is kind of misleading for business leaders, rather, the new approach of risk-based recommendation is better. If there is no Defender for CSPM then that should also be highlighted
With new Risk-based recommendations in place and old recommendations going into classic view, is there a plan to deprecate the MDC Secure score and classic recommendations?The Secure score of MDC is kind of misleading for business leaders, rather, the new approach of risk-based recommendation is better. If there is no Defender for CSPM then that should also be highlighted Read More
Need to overrule existing meetings in the calendar
My team would like Microsoft Bookings to overrule already existing meetings in the calendar, so that more available timeslots show in the booking page for potential participants. I realise the need is deviating normal use. However, is that possible? if so, where can we find this option? as for us researchers it’s the highest priority over any other meetings in our calendar.
My team would like Microsoft Bookings to overrule already existing meetings in the calendar, so that more available timeslots show in the booking page for potential participants. I realise the need is deviating normal use. However, is that possible? if so, where can we find this option? as for us researchers it’s the highest priority over any other meetings in our calendar.for example I would be available all day, however due to existing meetings nobody can book outside the hours that are shown Read More
How do I copy tasks in a Project Kanban?
How do I copy tasks in a Project Kanban? I want to create a template task and then copy it multiple times and then edit each task.
How do I copy tasks in a Project Kanban? I want to create a template task and then copy it multiple times and then edit each task. Read More
Quicklinks Webpart Image Misalignment and Scaling
Hi there,
We have a lot of Quicklinks on a SharePoint Modern Hub Site and I have thematically grouped them by colour to make the user experience cleaner (e.g. all the IT Quicklinks are grouped together in blue).
Ideally, I would like to edit the groups of buttons themselves because our corporate colour is red and all red buttons are quite intense. Because I can’t edit the colour of the buttons themselves (as they inherit the theme palette), I’ve created individual image buttons and uploaded them. In the image attached, you can see a SharePoint button (spend request) and an image upload (Wiki).
I am having two problems:
1. When I select to fit the image to button, it actually creates an image that is larger than the original button. Therefore, the blue image buttons are larger than the red SharePoint buttons. This is causing alignment issues and means that the dynamic resizing of the page for different displays don’t match. I have read through the Microsoft pages for image sizes and matched those. I’ve also tried multiple variations increasing the height and/ or width (I have 14 versions of the same button) but I’m still not seeing the size represented correctly.
2. There is a thin red line of pixels below each button when the scaling of the page is anything different to 100%. This is only present on the Safari browser but, as many of our users have Safari on their Mac devices and mobile phones (it offers a more secure and integrated experience), we do not want them shifting to Google Chrome.
Hi there,We have a lot of Quicklinks on a SharePoint Modern Hub Site and I have thematically grouped them by colour to make the user experience cleaner (e.g. all the IT Quicklinks are grouped together in blue).Ideally, I would like to edit the groups of buttons themselves because our corporate colour is red and all red buttons are quite intense. Because I can’t edit the colour of the buttons themselves (as they inherit the theme palette), I’ve created individual image buttons and uploaded them. In the image attached, you can see a SharePoint button (spend request) and an image upload (Wiki).I am having two problems:1. When I select to fit the image to button, it actually creates an image that is larger than the original button. Therefore, the blue image buttons are larger than the red SharePoint buttons. This is causing alignment issues and means that the dynamic resizing of the page for different displays don’t match. I have read through the Microsoft pages for image sizes and matched those. I’ve also tried multiple variations increasing the height and/ or width (I have 14 versions of the same button) but I’m still not seeing the size represented correctly.2. There is a thin red line of pixels below each button when the scaling of the page is anything different to 100%. This is only present on the Safari browser but, as many of our users have Safari on their Mac devices and mobile phones (it offers a more secure and integrated experience), we do not want them shifting to Google Chrome. Read More
Getting Error while loading SharePoint site particular folder
Hello
Please i need your help on this issue.
We are getting Error while loading SharePoint site particular folder
Hello Please i need your help on this issue. We are getting Error while loading SharePoint site particular folder Read More
Issue with inviting people to Teams meeting
Hi. We have recently created an enterprise Azure account with Entra licences and are piloting MS Teams, with a view to rolling this out to all staff next month. Azure is synched with our on-prem AD. Currently we have asked out ICT Unit to install Teams (though some are on leave right now).
Our AD users’ Display Names are usually saved in the format “Surname, Forename” and their AD Description is saved in the format “Forename_Surname”. (No, I don’t know why, either!)
When I go to invite users to a Teams meeting, and begin typing a forename – e.g., Maria – it will bring back two results that I can click on:
Surname1, Maria – with their Description and Job Title (taken from AD) on the line below;a (random?) string of letters, numbers and dashes, e.g., ene34k56-3lkj9-kc34-23431m345m66 – with their Description on the line below (Job Title is not present, but is recorded in AD)
Entering a more common name in the invite field, e.g., John, brings back 11 results (correct), but again they’re a mixture of Surname, Forename on the first line with correct Description and Job Title on the second line; or a random string of letters/numbers with correct name on the second line, and no Job Title.
It’s also bringing back administrator accounts, which do not have associated mailboxes and have not been set up on Teams.
I can’t roll out Teams on a wider basis while this is happening. Any help appreciated.
Hi. We have recently created an enterprise Azure account with Entra licences and are piloting MS Teams, with a view to rolling this out to all staff next month. Azure is synched with our on-prem AD. Currently we have asked out ICT Unit to install Teams (though some are on leave right now). Our AD users’ Display Names are usually saved in the format “Surname, Forename” and their AD Description is saved in the format “Forename_Surname”. (No, I don’t know why, either!) When I go to invite users to a Teams meeting, and begin typing a forename – e.g., Maria – it will bring back two results that I can click on: Surname1, Maria – with their Description and Job Title (taken from AD) on the line below;a (random?) string of letters, numbers and dashes, e.g., ene34k56-3lkj9-kc34-23431m345m66 – with their Description on the line below (Job Title is not present, but is recorded in AD) Entering a more common name in the invite field, e.g., John, brings back 11 results (correct), but again they’re a mixture of Surname, Forename on the first line with correct Description and Job Title on the second line; or a random string of letters/numbers with correct name on the second line, and no Job Title. It’s also bringing back administrator accounts, which do not have associated mailboxes and have not been set up on Teams. I can’t roll out Teams on a wider basis while this is happening. Any help appreciated. Read More
Title: Folders Not Refreshing Automatically After Installing Update KB5032190
I typically manage numerous images on a weekly basis, organizing them in folders displayed in medium and large thumbnail views. By default, all folders are sorted alphabetically. Before the installation of the KB5032190 update, folders would refresh automatically, eliminating the need to constantly press F5 whenever I made edits or duplicates. Prior to KB5032190, if I held down the CTRL key while dragging to duplicate an image, the duplicate would automatically be placed in front of the original. However, after installing KB5032190, duplicates are now placed at the end of the folder, requiring me to manually refresh the folder by hitting F5 to reorder them how I desire. This issue also presents itself when editing and saving images, as the edited image is pushed to the end of the folder until I manually refresh it using the F5 key. Despite researching online for several days and trying various solutions such as rebuilding the thumbnail cache and system repairs, the only effective resolution was to uninstall KB5032190. I am reluctant to disable Windows updates or block this patch indefinitely, and instead, I am seeking a viable solution or recommendation to address this persistent issue.
I typically manage numerous images on a weekly basis, organizing them in folders displayed in medium and large thumbnail views. By default, all folders are sorted alphabetically. Before the installation of the KB5032190 update, folders would refresh automatically, eliminating the need to constantly press F5 whenever I made edits or duplicates. Prior to KB5032190, if I held down the CTRL key while dragging to duplicate an image, the duplicate would automatically be placed in front of the original. However, after installing KB5032190, duplicates are now placed at the end of the folder, requiring me to manually refresh the folder by hitting F5 to reorder them how I desire. This issue also presents itself when editing and saving images, as the edited image is pushed to the end of the folder until I manually refresh it using the F5 key. Despite researching online for several days and trying various solutions such as rebuilding the thumbnail cache and system repairs, the only effective resolution was to uninstall KB5032190. I am reluctant to disable Windows updates or block this patch indefinitely, and instead, I am seeking a viable solution or recommendation to address this persistent issue. Read More
How to Turn Off Windows Hello Notifications
Hey there, just got my hands on a new webcam that’s Windows Hello compatible. After setting up Windows Hello, I can now breeze through logins without the hassle of passwords or pins.
I was wondering, is it feasible to eliminate the need for facial recognition confirmation with each login? If the system recognizes me, why the extra step of clicking OK each time? It seems redundant.
Wouldn’t it be smoother if the system automatically proceeded once it identified my face, without requiring the additional click? Is there a way to set this up?
Hey there, just got my hands on a new webcam that’s Windows Hello compatible. After setting up Windows Hello, I can now breeze through logins without the hassle of passwords or pins. I was wondering, is it feasible to eliminate the need for facial recognition confirmation with each login? If the system recognizes me, why the extra step of clicking OK each time? It seems redundant. Wouldn’t it be smoother if the system automatically proceeded once it identified my face, without requiring the additional click? Is there a way to set this up? Read More
Macro not activating
Hi, I’m a VBA beginner and I’m trying to set up a macro to auto-sort the contents of the sheet “ranked masterlist” when the database in “deviation masterlist” (which the ranked masterlist references) is updated. I’ve managed to cobble this code together from what I’ve seen online, but when I edit one of the cells in “deviation masterlist” at B1:B447, nothing happens. I know the sorting code works because I can trigger it with a button press, but presumably there’s a syntax issue in how I’ve added the condition at the start. If anyone could point to what I’m doing wrong, it would be much appreciated.
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, ActiveWorkbook.Worksheets(“deviation masterlist”).Range(“C2:C455”)) Is Nothing Then
ActiveWorkbook.Worksheets(“ranked masterlist”).Sort.SortFields.Clear
ActiveWorkbook.Worksheets(“ranked masterlist”).Sort.SortFields.Add2 Key:= _
Range(“B1:B447”), SortOn:=xlSortOnValues, Order:=xlDescending, DataOption _
:=xlSortNormal
ActiveWorkbook.Worksheets(“ranked masterlist”).Sort.SortFields.Add2 Key:= _
Range(“F1:F447”), SortOn:=xlSortOnValues, Order:=xlDescending, DataOption _
:=xlSortTextAsNumbers
With ActiveWorkbook.Worksheets(“ranked masterlist”).Sort
.SetRange Range(“B1:G447”)
.Header = xlGuess
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
End If
End Sub
Hi, I’m a VBA beginner and I’m trying to set up a macro to auto-sort the contents of the sheet “ranked masterlist” when the database in “deviation masterlist” (which the ranked masterlist references) is updated. I’ve managed to cobble this code together from what I’ve seen online, but when I edit one of the cells in “deviation masterlist” at B1:B447, nothing happens. I know the sorting code works because I can trigger it with a button press, but presumably there’s a syntax issue in how I’ve added the condition at the start. If anyone could point to what I’m doing wrong, it would be much appreciated. Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, ActiveWorkbook.Worksheets(“deviation masterlist”).Range(“C2:C455”)) Is Nothing Then
ActiveWorkbook.Worksheets(“ranked masterlist”).Sort.SortFields.Clear
ActiveWorkbook.Worksheets(“ranked masterlist”).Sort.SortFields.Add2 Key:= _
Range(“B1:B447”), SortOn:=xlSortOnValues, Order:=xlDescending, DataOption _
:=xlSortNormal
ActiveWorkbook.Worksheets(“ranked masterlist”).Sort.SortFields.Add2 Key:= _
Range(“F1:F447”), SortOn:=xlSortOnValues, Order:=xlDescending, DataOption _
:=xlSortTextAsNumbers
With ActiveWorkbook.Worksheets(“ranked masterlist”).Sort
.SetRange Range(“B1:G447”)
.Header = xlGuess
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
End If
End Sub Read More
Taskbar widgets button has been relocated unexpectedly.
I recently discovered a significant change on my computer’s taskbar. The widget button, typically located between the start button and quick access icons, has mysteriously shifted to the right side next to the clock and system tray. Despite checking the settings and adjusting alignment options, the widget button remains stubbornly misplaced.
I attempted to drag and drop it back to its original position without success. How can I rectify this unexpected relocation?
I recently discovered a significant change on my computer’s taskbar. The widget button, typically located between the start button and quick access icons, has mysteriously shifted to the right side next to the clock and system tray. Despite checking the settings and adjusting alignment options, the widget button remains stubbornly misplaced. I attempted to drag and drop it back to its original position without success. How can I rectify this unexpected relocation? Read More
Help with Recalling New Features in Windows 11
Hello,
Are you concerned about your privacy and customization settings in Windows 11 Pro? Windows Recall, a feature that captures screenshots and records keylogging entries every 5 seconds, might be causing some unease. Is there a way to turn off this intrusive functionality?
Additionally, the constant battle of customizing your Windows 11 computer, such as toggling settings like disabling personalized ads, only to have them reset mysteriously during future Windows updates, can be frustrating. How can you break this cycle and ensure that your preferred customizations remain unchanged even after system updates?
I would be happy to help guide you on how to safeguard your privacy and maintain your customization preferences amid these challenges.
Hello, Are you concerned about your privacy and customization settings in Windows 11 Pro? Windows Recall, a feature that captures screenshots and records keylogging entries every 5 seconds, might be causing some unease. Is there a way to turn off this intrusive functionality? Additionally, the constant battle of customizing your Windows 11 computer, such as toggling settings like disabling personalized ads, only to have them reset mysteriously during future Windows updates, can be frustrating. How can you break this cycle and ensure that your preferred customizations remain unchanged even after system updates? I would be happy to help guide you on how to safeguard your privacy and maintain your customization preferences amid these challenges. Read More
Fix: Unable to log in with Microsoft Account
I own a high-performance PC running on the W11 Pro operating system, which has three user accounts. Two of these accounts are local, while the third one is linked to a Microsoft (outlook.com) account. Recently, when I attempted to switch to the Microsoft account, I encountered a frustrating issue – I could not enter the password correctly. Even using the onscreen keyboard did not help as the characters typed were not appearing in the password field. Despite rebooting the system, the problem persisted.
Interestingly, both local accounts were functioning without any issues. To clarify, no characters were showing up in the password box when I attempted to type. I could only navigate around using the tab key and press enter for options like ‘forgot password’.
However, after some troubleshooting, I was able to resolve the issue by selecting the ‘forgot password’ option. By providing the rescue email address, I successfully completed the steps, canceled out, and was able to log into the MS account.
The system had recently undergone some changes, including the addition of Veracrypt encryption and switching from a wireless to a wired mouse. Apart from these alterations, there were no other significant modifications made.
I own a high-performance PC running on the W11 Pro operating system, which has three user accounts. Two of these accounts are local, while the third one is linked to a Microsoft (outlook.com) account. Recently, when I attempted to switch to the Microsoft account, I encountered a frustrating issue – I could not enter the password correctly. Even using the onscreen keyboard did not help as the characters typed were not appearing in the password field. Despite rebooting the system, the problem persisted. Interestingly, both local accounts were functioning without any issues. To clarify, no characters were showing up in the password box when I attempted to type. I could only navigate around using the tab key and press enter for options like ‘forgot password’. However, after some troubleshooting, I was able to resolve the issue by selecting the ‘forgot password’ option. By providing the rescue email address, I successfully completed the steps, canceled out, and was able to log into the MS account. The system had recently undergone some changes, including the addition of Veracrypt encryption and switching from a wireless to a wired mouse. Apart from these alterations, there were no other significant modifications made. Read More
How to find all labeled Documents deleted by a specific person
Hi there,
I try to create a Powershell AuditLog Search which finds me all labeled documents deleted by a specific person.
After a person has been dismissed, the aim is to find the sensitive documents that this person deleted shortly beforehand.
My script has no output at all and in the moment I am clueless what the reason could be. I made it simpler than my acutal question is:
$daysAgo = 30; $startDate = (Get-Date).AddDays(-$daysAgo)
$results = Search-UnifiedAuditLog -StartDate $startDate -EndDate (Get-Date) -RecordType SharePoint -Operations FileDeleted -ResultSize 5000 |
Where-Object {
$_.CreationTime -gt $startDate
} |
Select-Object CreationTime, UserIds, Operations, AuditData
$results | Export-Csv -Path “PATH.csv” -NoTypeInformation
Does anybody see my error? Thanks in advance :crossed_fingers:
Hi there, I try to create a Powershell AuditLog Search which finds me all labeled documents deleted by a specific person. After a person has been dismissed, the aim is to find the sensitive documents that this person deleted shortly beforehand. My script has no output at all and in the moment I am clueless what the reason could be. I made it simpler than my acutal question is: $daysAgo = 30; $startDate = (Get-Date).AddDays(-$daysAgo)$results = Search-UnifiedAuditLog -StartDate $startDate -EndDate (Get-Date) -RecordType SharePoint -Operations FileDeleted -ResultSize 5000 |Where-Object {$_.CreationTime -gt $startDate} |Select-Object CreationTime, UserIds, Operations, AuditData$results | Export-Csv -Path “PATH.csv” -NoTypeInformation Does anybody see my error? Thanks in advance :crossed_fingers: Read More
There was an issue with your Windows Hello PIN. Please try again later.
Here is the revised version of the content with a significant change:
“I’ve been using my PIN for a long time without any issues, but suddenly I received a message saying that I need to update my PIN for my organization. However, this is my personal computer and not associated with any organization. When I go to the sign-in options and try to set up a new Windows Hello PIN, I encounter an error message saying ‘Something went wrong. Try again later.’ I tried removing the PIN, but now the ‘Add’ button is inaccessible. Since this is my personal device with no group policies, I am puzzled about what could have caused this issue. I would appreciate any assistance in resolving this so I can reinstate my PIN.”
Alternatively, for your situation: “Out of the blue, my facial recognition and PIN, which have been working flawlessly for over two years, suddenly stopped functioning. After receiving a code from Microsoft sent to my recovery email, I entered it only to encounter the same error mentioned in this forum thread’s title. By clicking ‘Skip,’ I could bypass the issue and access my account.”
Here is the revised version of the content with a significant change: “I’ve been using my PIN for a long time without any issues, but suddenly I received a message saying that I need to update my PIN for my organization. However, this is my personal computer and not associated with any organization. When I go to the sign-in options and try to set up a new Windows Hello PIN, I encounter an error message saying ‘Something went wrong. Try again later.’ I tried removing the PIN, but now the ‘Add’ button is inaccessible. Since this is my personal device with no group policies, I am puzzled about what could have caused this issue. I would appreciate any assistance in resolving this so I can reinstate my PIN.” Alternatively, for your situation: “Out of the blue, my facial recognition and PIN, which have been working flawlessly for over two years, suddenly stopped functioning. After receiving a code from Microsoft sent to my recovery email, I entered it only to encounter the same error mentioned in this forum thread’s title. By clicking ‘Skip,’ I could bypass the issue and access my account.” Read More
Excel scripting in JS : enhance getRange adress format resolution
Hi !
Just stumbled over a thing that I think could be interesting to be added in the Excel Javascript API, especially in the ranges’ selection with addresses.
For a script I’m writing to parse some data in a worksheet in Excel 365 on desktop, I need to select a column starting a certain cell (basically to ignore headers).
When testing the Worksheet getRange(adress) method, I realized that I can either select a specific set of cells (like using the adress “A2:A1235”) or a complete column or line (i.e. with adress “A:A” or “2:2”), but I cannot select either a column or a row from or up to an offset :
“A2:A” to select column A from row 2 to end of column or “B2:2” to select the line from column B is not valid according to the js console.
I don’t know if this is just that I’m using the wrong way to format the address for what I want to do (in this case, the API doc needs to be clarified in my opinion), but if it is not originally planned, I think expanding the address format to support offset in both ways (with CL:C and C:CL formats for columns with an offset, and CL:L and L:CL for rows with an offset) could be a neat feature.
Best regards
Hi ! Just stumbled over a thing that I think could be interesting to be added in the Excel Javascript API, especially in the ranges’ selection with addresses. For a script I’m writing to parse some data in a worksheet in Excel 365 on desktop, I need to select a column starting a certain cell (basically to ignore headers). When testing the Worksheet getRange(adress) method, I realized that I can either select a specific set of cells (like using the adress “A2:A1235”) or a complete column or line (i.e. with adress “A:A” or “2:2″), but I cannot select either a column or a row from or up to an offset :”A2:A” to select column A from row 2 to end of column or “B2:2” to select the line from column B is not valid according to the js console. I don’t know if this is just that I’m using the wrong way to format the address for what I want to do (in this case, the API doc needs to be clarified in my opinion), but if it is not originally planned, I think expanding the address format to support offset in both ways (with CL:C and C:CL formats for columns with an offset, and CL:L and L:CL for rows with an offset) could be a neat feature. Best regards Read More
Share a List view as an embed on a different SharePoint site
I have the following case:
Site A has a List with lots of different views
Site B is shared with my customer
I would like my customer to be able to see one of those views on Site B, but I don’t want to share Site A with them.
Is that possible?
I have the following case: Site A has a List with lots of different viewsSite B is shared with my customer I would like my customer to be able to see one of those views on Site B, but I don’t want to share Site A with them. Is that possible? Read More
PC Heather Check app Warning message, how to fix?
I am on Windows 11 but this app says my computer is no qualified, lol
I am on Windows 11 but this app says my computer is no qualified, lol Read More
Improving Time Sync in Windows 11
My Windows 11 computers are configured to automatically synchronize with time.gov. I utilize the Your Universe in Motion application for syncing my timepieces. On several occasions, I have observed discrepancies of over a minute between the system time on Windows and the web link. However, when I initiate a manual sync, both times show the correct time. I am curious about the reason behind why Windows 11 does not consistently maintain accurate time synchronization.
My Windows 11 computers are configured to automatically synchronize with time.gov. I utilize the Your Universe in Motion application for syncing my timepieces. On several occasions, I have observed discrepancies of over a minute between the system time on Windows and the web link. However, when I initiate a manual sync, both times show the correct time. I am curious about the reason behind why Windows 11 does not consistently maintain accurate time synchronization. Read More