Category: Microsoft
Category Archives: Microsoft
Office stuck on loading profile unless you kill background office product
Hello all,
According to MS, this bug was fixed back in 2019 (see below) but my org is having issues with Outlook getting stuck at the “loading profile” stage. I am aware of the workaround (closing background 365 processes) but I was hoping there was a more permanent solution to minimize calls about this issue.
Troubleshooting Attempts:
Reboot (works but doesn’t solve the problem)
Repair Outlook/365 (works, but not every time)
Closing Background 365/Office Processes (been the current solution with a constant success rate)
Not happening to all users.
Hello all,According to MS, this bug was fixed back in 2019 (see below) but my org is having issues with Outlook getting stuck at the “loading profile” stage. I am aware of the workaround (closing background 365 processes) but I was hoping there was a more permanent solution to minimize calls about this issue. Troubleshooting Attempts:Reboot (works but doesn’t solve the problem)Repair Outlook/365 (works, but not every time)Closing Background 365/Office Processes (been the current solution with a constant success rate)Not happening to all users. Read More
Signature template in Exchange Online
Hi ya’ll. I’m trying to move from Zoho to Exchange, and I’m having trouble figuring out how to configure an org wide signature template like I can in Zoho Mail. The signature uses variables that we use to insert someone’s name, email, extension, etc. in the signature. Is this available in Exchange Online, and if so, how would this be accomplished?
Hi ya’ll. I’m trying to move from Zoho to Exchange, and I’m having trouble figuring out how to configure an org wide signature template like I can in Zoho Mail. The signature uses variables that we use to insert someone’s name, email, extension, etc. in the signature. Is this available in Exchange Online, and if so, how would this be accomplished? Read More
Another endless cycle of employment verification rejection
I have been going at this for the better part of two weeks. The same as everyone else. Generic responses saying the documents I submitted do not match the accepted document types. Ironically, I select the document type from the drop down list and provide exactly what is asked for. Here is where I am at:
Went through the entire process and uploaded documents 3 times. Still rejected.Opened a support ticket 2404170040008375. Ticket took a week to be closed and the only response provided was: The application to join the program was rejected because it failed Microsoft standards review. At this point, we are unable to provide any further details. We are closing this ticket as restricted internally.Started the verification process again. This time I changed my operating as company name to my numbered corporation name. Still rejected. Sent a screenshot and a URL showing my company website with all the requested information on it as identified in the document types. This too was rejected.
Sadly I provided the proof of purchase for my domain. They wouldn’t accept it because I bought it under my personal name (newsflash, I registered the business after I bought the domain). I also cannot update my whois record to include my company name. It is a .ca registration and for reasons that I cannot understand half of the words in my company name are restricted. Words such as solutions, ontario and inc. I have sent articles of incorporation, government documents, everything but my DNA. Still rejected.
I am very willing to work with Microsoft to get this sorted out, but I cannot unless they tell me what is failing! Please help me find the path forward. Somebody has to know what it is!
And SHAME on you Microsoft. This has been a problem since last year according to all the posts in this forum. Fix it!
I have been going at this for the better part of two weeks. The same as everyone else. Generic responses saying the documents I submitted do not match the accepted document types. Ironically, I select the document type from the drop down list and provide exactly what is asked for. Here is where I am at: Went through the entire process and uploaded documents 3 times. Still rejected.Opened a support ticket 2404170040008375. Ticket took a week to be closed and the only response provided was: The application to join the program was rejected because it failed Microsoft standards review. At this point, we are unable to provide any further details. We are closing this ticket as restricted internally.Started the verification process again. This time I changed my operating as company name to my numbered corporation name. Still rejected. Sent a screenshot and a URL showing my company website with all the requested information on it as identified in the document types. This too was rejected. Sadly I provided the proof of purchase for my domain. They wouldn’t accept it because I bought it under my personal name (newsflash, I registered the business after I bought the domain). I also cannot update my whois record to include my company name. It is a .ca registration and for reasons that I cannot understand half of the words in my company name are restricted. Words such as solutions, ontario and inc. I have sent articles of incorporation, government documents, everything but my DNA. Still rejected. I am very willing to work with Microsoft to get this sorted out, but I cannot unless they tell me what is failing! Please help me find the path forward. Somebody has to know what it is! And SHAME on you Microsoft. This has been a problem since last year according to all the posts in this forum. Fix it! Read More
somebody pls give me 100000 reward binge points
anybody in the whole wide world. pls give me a 20000microsoft reward points pleeeasssee.
someone scammed me and other people hacked me because i had 700 points while i was saving
for a robox robux gift card and fortnite coins now i am broke pls give back my pointss
anybody in the whole wide world. pls give me a 20000microsoft reward points pleeeasssee. someone scammed me and other people hacked me because i had 700 points while i was saving for a robox robux gift card and fortnite coins now i am broke pls give back my pointss Read More
Key announcements for AKS from KubeCon Europe 2024
At KubeCon Europe 2024, we showed how Azure and Kubernetes can help you build and deploy intelligent applications. Even if you couldn’t visit us at the Microsoft booth or attend the conference sessions, you can read about all the exciting ways we’re making Azure Kubernetes Service (AKS) the best destination for all things cloud-native—including the latest AI and machine learning (ML) applications. With enhancements to security, performance, networking, observability, and more, AKS provides even more platform-as-a-service benefits on top of a smoother onboarding experience for a great end-to-end developer experience.
Powering AI, ML, and compute-intensive workloads
Principal PM Lead for AKS Jorge Palma gave the keynote address, where he explored what AI can do for your platform and how to balance cost and security. Open source tools can give you an advantage, and the new AI toolchain operator (KAITO) add-on for AKS is now in preview. KAITO simplifies the experience of training and inferencing for open-source large language models (LLMs). Using the Karpenter node autoprovisioning functionality, KAITO helps you run AI workloads more cost-effectively by provisioning graphical processing units (GPUs) right when you need them. In other GPU news, AKS now supports Windows GPUs, enabling you to run compute-intensive workloads on Windows nodepools.
As the number of Kubernetes clusters grows from hundreds to thousands, you need a way to efficiently manage your platform. We continue to work with the open-source community to extend fleet workload orchestration. With Azure Kubernetes Fleet Manager, you can now schedule workloads to clusters based on new heuristics such as cost and availability of resources. You can also customize cluster-specific resources by targeting groups of clusters through resource override.
We’re proud to work with the open-source community on these enhancements. We also contributed to OpenTelemetry on another big milestone: HTTP semantic conventions declared stable.
Making Kubernetes easier to adopt
Misconfigurations are the bedbugs of Kubernetes deployments. To make life easier for dev teams, we added safety guardrails to AKS based on Azure Policy controls. You can now configure Deployment safeguards (preview) that apply Kubernetes best practices and notify you of misconfigurations in your AKS cluster. You can even enforce compliance and deny deployments that don’t follow best practices.
If you’re a Windows developer, you can now take advantage of Windows Gen 2 VMs and custom kubelet configuration. With these features, you can expect your Windows workloads to run on AKS with better performance, security, and compatibility. Gen2 VMs on Windows are supported for WS2022 only.
We’ve also made it easier to track the everyday costs associated with running Kubernetes clusters. The cost analysis add-on for AKS is now generally available. You can use Azure portal to view costs with Kubernetes-specific levels of granularity, such as by namespace, pod, and cluster in addition to Azure asset categories.
Improving security and networking
We announced a host of new security features at KubeCon Europe 2024, starting with Trusted launch (preview). It improves the security of Gen 2 VMs by protecting against advanced and persistent attack techniques.
In addition, the security improvements in the latest Kubernetes 1.29 release (Mandala) are now available to preview in AKS. You can check out ReadWriteOncePod, PersistentVolume access mode, CSI Node Expand Secret feature, and more.
Diving deep into network management, we added Azure CNI static block IP allocation for AKS (preview). Now Azure CNI can dynamically allocate pod IPs from a subnet separate from the subnet hosting the AKS cluster. That means better IP utilization, performance, scaling, and policy support.
In related CNI news for Linux users, AKS now supports dual stack networking. Azure CNI Overlay allows nodes and pods to have both IPv4 and IPv6 addresses, enhancing connectivity and application compatibility.
AKS also provides more control over a cluster’s network security group (NSG). You can now directly configure allowed host ports in your node pool settings—you specify the allowed host ports on your node pools and add these pools to an Application Security Group. Also, nodes in a node pool can now receive their own dedicated public IP addresses. You can use instance level public IP tags to choose how your traffic routes between Azure and the Internet. And if your services require direct access to a node’s public IP without an intermediary like a load balancer, host ports can now be automatically assigned for pod workloads.
Adding more scalability and observability
We’re always looking for ways to empower developers to do more, and now AKS supports more scalability, performance, and observability in the control plane. In the Standard tier, you now have the performance you need to run larger workloads—anything from batch processing jobs and simulations to ML and multitenanted clusters. Standard tier supports up to a maximum of 5,000 nodes and 100,000 pods per cluster.
If you want to track all those workloads using Prometheus metrics, now you can. Azure Monitor managed service for Prometheus enables you to collect and analyze metrics at scale based on the Prometheus project from the Cloud Native Computing Foundation. This service debuted last year in 26 regions and is now available in 13 additional public Azure regions.
AKS supports Kubernetes Logs metadata as well. You can query objects using labels and selectors and perform bulk actions on specific subsets, like consumption or updates.
For services that use a load balancer, you can now switch the inbound pool type in AKS for greater efficiency in provisioning VMs. This improvement is particularly beneficial for clusters with large numbers of nodes.
Managing storage volumes with Azure Container Storage
Last year at KubeCon North America, we released the preview of Azure Container Storage, a fully managed, cost-efficient volume orchestration service built natively for Kubernetes. This year, we have announced notable enhancements that improve costs and simplify tedious tasks, such as manually managing volumes.
Azure Container Storage can help you avoid scaling bottlenecks and other challenges that come with running stateful container applications—including the cost of running persistent storage. Check out the overview.
Learn more
For more information about working with AKS:
Get started with Azure Kubernetes Service
Watch the recordings from our Azure Day with Kubernetes event in Paris
Get a copy of Kubernetes Best Practices, Second Edition
Microsoft Tech Community – Latest Blogs –Read More
New bookings redirects people who sign in with a personal account to LIVE.COM and give error
When I send out my bookings page to the public, and people who get it are forced to select guest or sign in – if they sign in with a personal microsoft account, they are re-directed to LIVE.COM and it displays the error message that they don’t have access “bookings with me”.
i understand that personal microsoft accounts can’t have bookings with the personal account, but I’m using a work account, sending out the public for them to create a booking with me. Why is this redirecting them after sign-in to LIVE.COM instead of landing them on my public bookings page.
I know they could know to sign is as guest, but then the process requires them to provide an email, and then requires them to verify that email with a code before making the booking. (because they aren’t logged in as anyone).
Please have someone investigate that redirect to LIVE.COM – that’s dumb.
When I send out my bookings page to the public, and people who get it are forced to select guest or sign in – if they sign in with a personal microsoft account, they are re-directed to LIVE.COM and it displays the error message that they don’t have access “bookings with me”. i understand that personal microsoft accounts can’t have bookings with the personal account, but I’m using a work account, sending out the public for them to create a booking with me. Why is this redirecting them after sign-in to LIVE.COM instead of landing them on my public bookings page. I know they could know to sign is as guest, but then the process requires them to provide an email, and then requires them to verify that email with a code before making the booking. (because they aren’t logged in as anyone). Please have someone investigate that redirect to LIVE.COM – that’s dumb. Read More
Changing default TCP window size using registry key
Using this registry DWORD value – TcpWindowSize in HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesTcpipParameters to change the default TCP Window Size does not seem to improve the perfromance of the throughput. It seems this reg key doesn’t work any more.
Using this registry DWORD value – TcpWindowSize in HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesTcpipParameters to change the default TCP Window Size does not seem to improve the perfromance of the throughput. It seems this reg key doesn’t work any more.
https://learn.microsoft.com/en-us/troubleshoot/windows-server/networking/description-tcp-features#tcp-window-size Read More
Allow only specific domain to email a distribution group
I’d like to allow only a specific external sender domain to send email to our distribution group (DG) in M365. (The DG is actually a mail-enabled security group synced from AD.) I see that a mail-flow rule doesn’t process until after the DG is expanded, so can’t match the DG as the recipient. I see that the DG has an attribute dLMemSubmitPerms to specify who’s permitted to send to the group, but I think that is only for objects in AD and wouldn’t be able to use an external domain? When I try to modify dLMemSubmitPerms I get an error anyway.
So how can this be done?
I’d like to allow only a specific external sender domain to send email to our distribution group (DG) in M365. (The DG is actually a mail-enabled security group synced from AD.) I see that a mail-flow rule doesn’t process until after the DG is expanded, so can’t match the DG as the recipient. I see that the DG has an attribute dLMemSubmitPerms to specify who’s permitted to send to the group, but I think that is only for objects in AD and wouldn’t be able to use an external domain? When I try to modify dLMemSubmitPerms I get an error anyway.So how can this be done? Read More
Authentication with API based messaging extension
Hey Everyone!
We have created API based messaging extension with Open API specification file. Currently we have uploaded the custom app as API based messaging extension on Teams. Without authentication, I’m able to run this custom app on M365 copilot as well as run in personal app messaging extension. However, when I implement authentication and enable auth type as “MicrosoftEntra” and setup my AAD accordingly, I could generate authentication token from my personal app messaging extension. But M365 copilot is not able to generate a token for my open API when this plugin is enabled in M365 copilot. Could you please help me understand the issue and what needs to be done here?
we have referred to below links. The suggestions given does not work for M365 auth.
1. https://learn.microsoft.com/en-us/microsoftteams/platform/messaging-extensions/build-api-based-message-extension?tabs=token-v2
2. https://learn.microsoft.com/en-us/microsoftteams/platform/messaging-extensions/api-based-overview
Hey Everyone!
We have created API based messaging extension with Open API specification file. Currently we have uploaded the custom app as API based messaging extension on Teams. Without authentication, I’m able to run this custom app on M365 copilot as well as run in personal app messaging extension. However, when I implement authentication and enable auth type as “MicrosoftEntra” and setup my AAD accordingly, I could generate authentication token from my personal app messaging extension. But M365 copilot is not able to generate a token for my open API when this plugin is enabled in M365 copilot. Could you please help me understand the issue and what needs to be done here?we have referred to below links. The suggestions given does not work for M365 auth.1. https://learn.microsoft.com/en-us/microsoftteams/platform/messaging-extensions/build-api-based-message-extension?tabs=token-v22. https://learn.microsoft.com/en-us/microsoftteams/platform/messaging-extensions/api-based-overview Read More
Can we please get a fix for muting individual tabs?
Currently if you have more than a handful of tabs, the mute tab button on each individual tab stops working. For me, when I have 12+ tabs on my 1080p display. There’s no reason for behavior-there is more than enough physical space to press the mute button. This functionality works fine on Chrome, you can have plenty of tabs, but this is still a problem on Edge and has been for years.
Chrome is going to push a new garbage UI update soon, so I (and many others) are looking for a new browser. This mute functionality is a dealbreaker, if there is a way this can be fixed it would be wonderful.
Currently if you have more than a handful of tabs, the mute tab button on each individual tab stops working. For me, when I have 12+ tabs on my 1080p display. There’s no reason for behavior-there is more than enough physical space to press the mute button. This functionality works fine on Chrome, you can have plenty of tabs, but this is still a problem on Edge and has been for years. Chrome is going to push a new garbage UI update soon, so I (and many others) are looking for a new browser. This mute functionality is a dealbreaker, if there is a way this can be fixed it would be wonderful. Read More
How does maximum-on-demand-scan-threads on MDE Linux affect performance?
Hello. I’m interested in achieving the best performance for on-demand/custom scans. Some of the benchmarks I’ve been seeing are very confusing and I was hoping someone could help clarify.
I have two Linux servers (16 CPU cores each) running MDE. Both servers have an NFS share mounted. There is a folder containing 1859 files that I want to scan.
On the first Linux server, scanning with max 2 threads took just under 16 minutes:
$ sudo mdatp config maximum-on-demand-scan-threads –value 2
Configuration property updated.
$ time mdatp scan custom –path /storage/files
Scan has finished
1859 file(s) scanned
0 threat(s) detected
real 15m57.667s
user 0m0.124s
sys 0m0.111s
Then I bumped the max threads to 16, which reduced the overall time to just over 2 minutes. It sounded great at first, but I reduced back to 2 threads immediately and re-scanned, which took under 2 minutes. To me, this means the drastic time change is not a result of the number of threads, but likely that MDE is caching results.
$ sudo mdatp config maximum-on-demand-scan-threads –value 16
Configuration property updated.
$ time mdatp scan custom –path /storage/files
Scan has finished
1859 file(s) scanned
0 threat(s) detected
real 2m9.889s
user 0m0.030s
sys 0m0.031s
$ sudo mdatp config maximum-on-demand-scan-threads –value 2
Configuration property updated.
$ time mdatp scan custom –path /storage/files
Scan has finished
1859 file(s) scanned
0 threat(s) detected
real 1m54.150s
user 0m0.040s
sys 0m0.030s
Does anyone know if MDE in fact caches results? If so, are they cached locally or on the cloud side? Is there any way to clear the cache? To check if they are cached in the cloud, I ran the same scan from the second Linux server using 16 threads and it took 19 minutes. That suggests the cache is local, if it exists at all.
Some other questions I have:
* maximum-on-demand-scan-threads controls the maximum – is there a way to find out how many are/were used? Aside from the caching issue, scanning with max 2 and max 16 seem to take about the same amount of time.
* Does changing maximum-on-demand-scan-threads take effect immediately? I haven’t seen documentation that suggests it only takes effect after restarting the wdavdaemon services or rebooting, etc.
Side note: The Linux servers do not run auditd. There are no firewall rules blocking network connections (cloud protection is enabled).
Hello. I’m interested in achieving the best performance for on-demand/custom scans. Some of the benchmarks I’ve been seeing are very confusing and I was hoping someone could help clarify. I have two Linux servers (16 CPU cores each) running MDE. Both servers have an NFS share mounted. There is a folder containing 1859 files that I want to scan. On the first Linux server, scanning with max 2 threads took just under 16 minutes: $ sudo mdatp config maximum-on-demand-scan-threads –value 2
Configuration property updated.
$ time mdatp scan custom –path /storage/files
Scan has finished
1859 file(s) scanned
0 threat(s) detected
real 15m57.667s
user 0m0.124s
sys 0m0.111s Then I bumped the max threads to 16, which reduced the overall time to just over 2 minutes. It sounded great at first, but I reduced back to 2 threads immediately and re-scanned, which took under 2 minutes. To me, this means the drastic time change is not a result of the number of threads, but likely that MDE is caching results. $ sudo mdatp config maximum-on-demand-scan-threads –value 16
Configuration property updated.
$ time mdatp scan custom –path /storage/files
Scan has finished
1859 file(s) scanned
0 threat(s) detected
real 2m9.889s
user 0m0.030s
sys 0m0.031s
$ sudo mdatp config maximum-on-demand-scan-threads –value 2
Configuration property updated.
$ time mdatp scan custom –path /storage/files
Scan has finished
1859 file(s) scanned
0 threat(s) detected
real 1m54.150s
user 0m0.040s
sys 0m0.030s Does anyone know if MDE in fact caches results? If so, are they cached locally or on the cloud side? Is there any way to clear the cache? To check if they are cached in the cloud, I ran the same scan from the second Linux server using 16 threads and it took 19 minutes. That suggests the cache is local, if it exists at all. Some other questions I have: * maximum-on-demand-scan-threads controls the maximum – is there a way to find out how many are/were used? Aside from the caching issue, scanning with max 2 and max 16 seem to take about the same amount of time. * Does changing maximum-on-demand-scan-threads take effect immediately? I haven’t seen documentation that suggests it only takes effect after restarting the wdavdaemon services or rebooting, etc. Side note: The Linux servers do not run auditd. There are no firewall rules blocking network connections (cloud protection is enabled). Read More
How to share one plan only
Hi,
I have created a group for all my projects and this is private. Each projects has a plan created within the group. I am the only member. However, I would like to find a way to share only some of the plans when i go on holiday so my manager can view the progress of those projects. But today I tried to add him as member but it got added to the group and he could see and amend all of my plans (projects).
How can i do to only share one plan (project) to him? do i have to create another group and call it shared and copy the plans i want to shre into it and then invite him in that group? the only problem with that solution, it creates a duplication of data.
is there any other way to only share one plan but not all plans within a group?
thanks
Hi, I have created a group for all my projects and this is private. Each projects has a plan created within the group. I am the only member. However, I would like to find a way to share only some of the plans when i go on holiday so my manager can view the progress of those projects. But today I tried to add him as member but it got added to the group and he could see and amend all of my plans (projects). How can i do to only share one plan (project) to him? do i have to create another group and call it shared and copy the plans i want to shre into it and then invite him in that group? the only problem with that solution, it creates a duplication of data. is there any other way to only share one plan but not all plans within a group? thanks Read More
How to configure cipher suites for STARTTLS?
I configured the available cipher suites for an Exchange 2013 server as described here in the best practice document by putting them into the appropriate registry key:
HKLM:SYSTEMCurrentControlSetControlCryptographyConfigurationLocalSSL0010002
But when looking at a packet capture of an outgoing SMTP session of that server which used STARTTLS, I observed that it was offering a completely different set of ciphers. Is that registry key not being used for STARTTLS by Exchange Server and if so, where do the ciphers for that have to be configured instead?
I configured the available cipher suites for an Exchange 2013 server as described here in the best practice document by putting them into the appropriate registry key:HKLM:SYSTEMCurrentControlSetControlCryptographyConfigurationLocalSSL0010002But when looking at a packet capture of an outgoing SMTP session of that server which used STARTTLS, I observed that it was offering a completely different set of ciphers. Is that registry key not being used for STARTTLS by Exchange Server and if so, where do the ciphers for that have to be configured instead? Read More
Can VBA dynamically insert data in rows on one worksheet based on the number rows w. data on another
Windows 10
Excel 2019
Is possible for VBA dynamically insert data in rows on one worksheet based on the number rows on another worksheet in the same workbook?
I have a workbook with two worksheets named “Title Data” and “Track Data”.
Both worksheets have headers.
The number of rows with data in worksheet “Track Data” can vary, new data maybe added, and some may be deleted.
The VBA code below pulls selected data from “Track Data” in to “Title Data” .
I have to manually specify the number of rows which I have set at 50000 in code as seen in the snippit…
Range(“A2:I2”).Select
Selection.AutoFill Destination:=Range(“A2:I50000”), Type:=xlFillDefault
At the moment there is only 33,105 rows with data so I see no point in adding more rows of formulas than is needed as the code takes a while to run as it is.
Can the above code snippit be dynamic where the VBA, when it is run, looks in the “Track Data” worksheet and counts the number of rows with data and then copies the formulas into “Title Data” and only fills the forumalas down to match the number of rows with data in “Track Data” ?
So if there are 10,000 rows in “Track Data” with data, the VBA the copies the formulas down 10,000 rows in “Title Data” and if there are 90,000 rows then it adds 90,000 rows of formulas.
I may be thinking rubbish but if I do not ask then I will not know the answer as this is beyond my knowledge.
Thank you everyone.
Sub PullTitlesDataTest2()
With Application
.ScreenUpdating = False
.Calculation = xlCalculationManual
.EnableAnimations = False
End With
‘ Starting with cell A2 through to cell I2, and down to row 40,000, this inserts the forumlas to
‘ pull the data from the worksheet “Track Data*
Range(“A2”).Select
ActiveCell.FormulaR1C1 = “=IF(ISBLANK(‘Track Data’!RC),””””,’Track Data’!RC)”
Range(“B2”).Select
ActiveCell.FormulaR1C1 = “=IF(ISBLANK(‘Track Data’!RC[-1]),””””,’Track Data’!RC)”
Range(“C2”).Select
ActiveCell.FormulaR1C1 = “=IF(ISBLANK(‘Track Data’!RC[-2]),””””,’Track Data’!RC[6])”
Range(“D2”).Select
ActiveCell.FormulaR1C1 = “=IF(ISBLANK(‘Track Data’!RC[-3]),””””,’Track Data’!RC[6])”
Range(“E2”).Select
ActiveCell.FormulaR1C1 = “=IF(ISBLANK(‘Track Data’!RC[-4]),””””,’Track Data’!RC)”
Range(“F2”).Select
ActiveCell.FormulaR1C1 = “=IF(AND(RC[-5]=R[1]C[-5],RC[-4]=R[1]C[-4],RC[-3]=R[1]C[-3],RC[-2]=R[1]C[-2]),””””,TEXTJOIN(“”+””,,CHOOSE({1,2},IF(COUNTIFS(R2C[-1]:RC[-1],1,R2C[-4]:RC[-4],RC[-4]),””M””,””””),IF(COUNTIFS(R2C[-1]:RC[-1],2,R2C[-4]:RC[-4],RC[-4]),””S””,””””),2)))”
Range(“G2”).Select
ActiveCell.FormulaR1C1 = “=IF(ISBLANK(‘Track Data’!RC[-6]),””””,’Track Data’!RC[-1])”
Range(“H2”).Select
ActiveCell.FormulaR1C1 = “=IF(ISBLANK(‘Track Data’!RC[-7]),””””,’Track Data’!RC[-1])”
Range(“I2”).Select
ActiveCell.FormulaR1C1 = “=IF(ISBLANK(‘Track Data’!RC[-8]),””””,IF(‘Track Data’!RC[-1]=””.wav””,””Wav””,IF(‘Track Data’!RC[-1]=””.flac””,””Flac””,IF(‘Track Data’!RC[-1]=””.aif””,””Aif””,IF(‘Track Data’!RC[-1]=””.mp3″”,””MP3″”,IF(‘Track Data’!RC[-1]=””.SD2″”,””SD2″”,””UNKNOWN TYPE””))))))”
Range(“A2:I2”).Select
Selection.AutoFill Destination:=Range(“A2:I40000”), Type:=xlFillDefault
Range(“A2:I40000”).Select
Application.GoTo Reference:=”R2C1″
With Application
.ScreenUpdating = True
.Calculation = xlCalculationAutomatic
.EnableAnimations = True
End With
End Sub
Windows 10Excel 2019Is possible for VBA dynamically insert data in rows on one worksheet based on the number rows on another worksheet in the same workbook? I have a workbook with two worksheets named “Title Data” and “Track Data”.Both worksheets have headers. The number of rows with data in worksheet “Track Data” can vary, new data maybe added, and some may be deleted. The VBA code below pulls selected data from “Track Data” in to “Title Data” . I have to manually specify the number of rows which I have set at 50000 in code as seen in the snippit… Range(“A2:I2”).Select
Selection.AutoFill Destination:=Range(“A2:I50000”), Type:=xlFillDefault At the moment there is only 33,105 rows with data so I see no point in adding more rows of formulas than is needed as the code takes a while to run as it is. Can the above code snippit be dynamic where the VBA, when it is run, looks in the “Track Data” worksheet and counts the number of rows with data and then copies the formulas into “Title Data” and only fills the forumalas down to match the number of rows with data in “Track Data” ? So if there are 10,000 rows in “Track Data” with data, the VBA the copies the formulas down 10,000 rows in “Title Data” and if there are 90,000 rows then it adds 90,000 rows of formulas. I may be thinking rubbish but if I do not ask then I will not know the answer as this is beyond my knowledge. Thank you everyone. Sub PullTitlesDataTest2()
With Application
.ScreenUpdating = False
.Calculation = xlCalculationManual
.EnableAnimations = False
End With
‘ Starting with cell A2 through to cell I2, and down to row 40,000, this inserts the forumlas to
‘ pull the data from the worksheet “Track Data*
Range(“A2”).Select
ActiveCell.FormulaR1C1 = “=IF(ISBLANK(‘Track Data’!RC),””””,’Track Data’!RC)”
Range(“B2”).Select
ActiveCell.FormulaR1C1 = “=IF(ISBLANK(‘Track Data’!RC[-1]),””””,’Track Data’!RC)”
Range(“C2”).Select
ActiveCell.FormulaR1C1 = “=IF(ISBLANK(‘Track Data’!RC[-2]),””””,’Track Data’!RC[6])”
Range(“D2”).Select
ActiveCell.FormulaR1C1 = “=IF(ISBLANK(‘Track Data’!RC[-3]),””””,’Track Data’!RC[6])”
Range(“E2”).Select
ActiveCell.FormulaR1C1 = “=IF(ISBLANK(‘Track Data’!RC[-4]),””””,’Track Data’!RC)”
Range(“F2”).Select
ActiveCell.FormulaR1C1 = “=IF(AND(RC[-5]=R[1]C[-5],RC[-4]=R[1]C[-4],RC[-3]=R[1]C[-3],RC[-2]=R[1]C[-2]),””””,TEXTJOIN(“”+””,,CHOOSE({1,2},IF(COUNTIFS(R2C[-1]:RC[-1],1,R2C[-4]:RC[-4],RC[-4]),””M””,””””),IF(COUNTIFS(R2C[-1]:RC[-1],2,R2C[-4]:RC[-4],RC[-4]),””S””,””””),2)))”
Range(“G2”).Select
ActiveCell.FormulaR1C1 = “=IF(ISBLANK(‘Track Data’!RC[-6]),””””,’Track Data’!RC[-1])”
Range(“H2”).Select
ActiveCell.FormulaR1C1 = “=IF(ISBLANK(‘Track Data’!RC[-7]),””””,’Track Data’!RC[-1])”
Range(“I2”).Select
ActiveCell.FormulaR1C1 = “=IF(ISBLANK(‘Track Data’!RC[-8]),””””,IF(‘Track Data’!RC[-1]=””.wav””,””Wav””,IF(‘Track Data’!RC[-1]=””.flac””,””Flac””,IF(‘Track Data’!RC[-1]=””.aif””,””Aif””,IF(‘Track Data’!RC[-1]=””.mp3″”,””MP3″”,IF(‘Track Data’!RC[-1]=””.SD2″”,””SD2″”,””UNKNOWN TYPE””))))))”
Range(“A2:I2”).Select
Selection.AutoFill Destination:=Range(“A2:I40000”), Type:=xlFillDefault
Range(“A2:I40000”).Select
Application.GoTo Reference:=”R2C1″
With Application
.ScreenUpdating = True
.Calculation = xlCalculationAutomatic
.EnableAnimations = True
End With
End Sub Read More
Access Europe – Using VBA to create a class based on a table – Wed 1 May
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will then demonstrate VBA code to create class modules from tables and use the class created to populate/navigate/update a simple unbound form.
An example database will be provided containing all the code used for this presentation.
I hope you will join us on May 1st for this session.
For more details about the topic and speaker together with connection details for the meeting, please visit https://isladogs.co.uk/aeu-27/ or https://accessusergroups.org/europe/event/access-europe-2024-05-01/
For local start times, please check https://www.worldtimebuddy.com
The meeting will again be held on Zoom. When the time comes, you can connect using Join Zoom Meeting.
If you are asked, use: Meeting ID: 924 3129 5683 ; Passcode: 661210
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.Adolph will then demonstrate VBA code to create class modules from tables and use the class created to populate/navigate/update a simple unbound form.An example database will be provided containing all the code used for this presentation.
I hope you will join us on May 1st for this session.
For more details about the topic and speaker together with connection details for the meeting, please visit https://isladogs.co.uk/aeu-27/ or https://accessusergroups.org/europe/event/access-europe-2024-05-01/For local start times, please check https://www.worldtimebuddy.comThe meeting will again be held on Zoom. When the time comes, you can connect using Join Zoom Meeting.If you are asked, use: Meeting ID: 924 3129 5683 ; Passcode: 661210
Set User Default Credential Provider for Lock Screen
I’m using Windows 10 Enterprise 22 H2 with Intune and MECM (Co-Managed). We enforce that our users enrol for Windows Hello for business. They can use PIN or Biometric. This all works fine but when the user session locks (idle time etc.) it defaults to username/password credential provider even if the user signed into the desktop console session with a PIN.
I’m aware there is a system wide policy to set the default credential provider here https://learn.microsoft.com/en-us/windows/client-management/mdm/policy-csp-admx-credentialproviders#defaultcredentialprovider but I am wondering if there is a method to do this per user or have the lock screen default to the credential used for the user sigin in?
I’m using Windows 10 Enterprise 22 H2 with Intune and MECM (Co-Managed). We enforce that our users enrol for Windows Hello for business. They can use PIN or Biometric. This all works fine but when the user session locks (idle time etc.) it defaults to username/password credential provider even if the user signed into the desktop console session with a PIN. I’m aware there is a system wide policy to set the default credential provider here https://learn.microsoft.com/en-us/windows/client-management/mdm/policy-csp-admx-credentialproviders#defaultcredentialprovider but I am wondering if there is a method to do this per user or have the lock screen default to the credential used for the user sigin in? Read More
Referencing an excel spreasheet
I appreciate all help on this issue, I have been struggling with a solution.
I have a column of notes and I’ve updated these notes (via calculated column, in SharePoint) to bring me the concise value that needs to be presented – which is a name.
I then need to reference this value with an excel table which is a roster.
The issue is that the names (via calculated column) are not concise and I need to still locate them through my roster.
This is a great example of when there is no issues:
SharePoint value – Michael Pignatello
Excel value – Michael Pignatello
When I use this flow design:
I am outputted a corresponding value from excel, then, from this I will update my SharePoint item.
Example with issues:
SharePoint value: Linda L. Brooks
Excel value: Linda Brooks
I am being brought back no value from excel as it cannot find a match
Please let me know if you have any questions or concerns. Thank you so much for your assistance.
I appreciate all help on this issue, I have been struggling with a solution. I have a column of notes and I’ve updated these notes (via calculated column, in SharePoint) to bring me the concise value that needs to be presented – which is a name.I then need to reference this value with an excel table which is a roster. The issue is that the names (via calculated column) are not concise and I need to still locate them through my roster. This is a great example of when there is no issues:SharePoint value – Michael PignatelloExcel value – Michael PignatelloWhen I use this flow design: I am outputted a corresponding value from excel, then, from this I will update my SharePoint item.Example with issues:SharePoint value: Linda L. BrooksExcel value: Linda BrooksI am being brought back no value from excel as it cannot find a matchPlease let me know if you have any questions or concerns. Thank you so much for your assistance. Read More
Private Teams not sending chat to external teams
I got a new laptop that has Teams (private) on it. I have tried sending a chat to my work email, but the chat won’t show up. I get an email (work) saying to join teams to see the chat. When I click the join button, it brings me to my work teams but no chat is there. If I send a chat from work to personal account, I see a message come in from ‘Unknown User’. If I click on it, I get a message to either block or accept the user. If I click accept, I see an error saying something went wrong and to try again – it never accepts.
How do I get this to send/receive correctly?
I got a new laptop that has Teams (private) on it. I have tried sending a chat to my work email, but the chat won’t show up. I get an email (work) saying to join teams to see the chat. When I click the join button, it brings me to my work teams but no chat is there. If I send a chat from work to personal account, I see a message come in from ‘Unknown User’. If I click on it, I get a message to either block or accept the user. If I click accept, I see an error saying something went wrong and to try again – it never accepts. How do I get this to send/receive correctly? Read More
Querying for config options that aren’t reported by “mdatp health”
Hello. Is there a way to query for existing config options that are not reported by “mdatp health”? For example, maximum-on-demand-scan-threads is not reported by “mdatp health.”
The “mdatp config” command only lets you change the value, but doesn’t provide a way to determine its current value. For example:
$ mdatp config maximum-on-demand-scan-threads
Configure maximum number of threads used in on-demand scans:
–value arg Numerical value between 1 and 64
There appears to be a way to brute force it, by supplying all possible options until the command fails because the new setting is the same as the current setting:
$ sudo mdatp config maximum-on-demand-scan-threads –value 16
Configuration property updated.
$ sudo mdatp config maximum-on-demand-scan-threads –value 16
Configuration not updated
New setting value is the same as the current value
Is there any better way to learn the current value?
Hello. Is there a way to query for existing config options that are not reported by “mdatp health”? For example, maximum-on-demand-scan-threads is not reported by “mdatp health.” The “mdatp config” command only lets you change the value, but doesn’t provide a way to determine its current value. For example: $ mdatp config maximum-on-demand-scan-threads
Configure maximum number of threads used in on-demand scans:
–value arg Numerical value between 1 and 64 There appears to be a way to brute force it, by supplying all possible options until the command fails because the new setting is the same as the current setting: $ sudo mdatp config maximum-on-demand-scan-threads –value 16
Configuration property updated.
$ sudo mdatp config maximum-on-demand-scan-threads –value 16
Configuration not updated
New setting value is the same as the current value Is there any better way to learn the current value? Read More
Can’t use the datedif function
Hello, I’m trying to get average age from date of birth in an Excel sheet (Microsoft 365) and the function to be used is datedif but nothing works, I always get this message. Help!
Hello, I’m trying to get average age from date of birth in an Excel sheet (Microsoft 365) and the function to be used is datedif but nothing works, I always get this message. Help! Read More