converting date and time as text into a usable date / time format in excel
Want to convert into usable date/time format. Have seen =DATEVALUE(TRIM(MID(SUBSTITUTE(A2,",",REPT(" ",100)),100,100))) used to produce date, but did not include time - I need time code to measure duration between 2 entries
Is there a way to disable the script confirmation popup the appears everytime I click on a button?
I create a simple file and I was trying to automate some processes and I notice that every time I click on the Script button it shows me a popup on the right side that says script run status, its annoying to see that everytime I click on the button. How…
Knowledge check keeps spinning, will not complete no matter which answers are chosen
The knowledge check here: https://learn.microsoft.com/en-us/training/modules/describe-security-capabilities-of-azure-sentinel/5-knowledge-check will not complete. I've tried on mobile and on my desktop computer. In Edge and Chrome. The answers are…
No tengo acceso a mi outlook autenticator en mi dispositivo móvil.
No puedo ingresar acceder a mi aplicacion de atenticacion con outlook. Quisiera que por favor me suguieran que porcesos serguir.
Microsoft Power BI Data Analyst certification(PL-300)
PL-300.PNG Unable to see view certification details for PL-300 (Microsoft Power BI Data Analyst). Instead of that it is showing as view details on provider site.
Importar datos - Opción desaparecida de Excel y Outlook - Microsoft Office Profesional Plus 2019
Hasta ahora no me había percatado que en OUTLOOK ha desaparecido la opción de IMPORTAR DE OTROS PROGRAMAS O ARCHIVO, los archivos de ACCESS y en EXCEL ha no está la opción de OBTENER DATOS desde un documento PDF
How to move a Sharepoint List item to another list when an action is complete?
I am trying to figure out how to move items between from a main sharepoint list to a specific sharepoint list when an action is done. I have 6 sharepoint lists for separate programs. I would like to create an item on a 7th sharepoint list and when a…
How to export managed metadata from subfolders and documents to csv
I have a document library and at the top level we have a number of folders for each year i.e. 2024, 2023, 2022, 2021 etc. Against these yearly folders we have a Content Type of "Yearly Folder". Under each yearly folder we have a huge list of…
Issue when Webpart with a custom toolbar is loaded after SharePoint 2019 September 2024 CU installation
Hi, After installing the SharePoint 2019 September 10th Cumulative Update (this one), our custom webpart toolbar property appears to be causing an issue when attempting to render the webpart control. The exception we encounter is the…
Files from network locations not appearing anymore in Recent/Pinned
In Excel, I no longer see files I've opened from network locations in the recent files list, and the pinned workbooks from network locations are missing. The drive is still mapped and I can access the files by navigating there. I've tried opening and…
Files from network locations not appearing anymore in Recent/Pinned
In Excel, I no longer see files I've opened from network locations in the recent files list, and the pinned workbooks from network locations are missing. The drive is still mapped and I can access the files by navigating there. I've tried opening and…
Issues configuring copilot with generative answers on Sharepoint site
Hi, I have a copilot that I can't get to read the documents from sharepoint using Manual Authentication. Here are my details, any insight is much appreciated.
Client does not have permissions to send as this sender
Hi All, I am using an Exchange 2016 Hybrid environment with an internal relay. When I test using the syntax below, I receive the following error. For authentication, I am using a service account that is created as a remote mailbox on-premises and synced…
Should a quorum folder be automatically created ?
Hi. I'm testing a DRP plan. I restored from the backup tool: 1 domain controller. 1 file server. 5 Exchange servers in the DAG. Exchange 2016 I read this thread:…
Issue when Webpart with a custom toolbar is loaded after SharePoint 2019 September 2024 CU installation
Hi, We have encountered an issue after installing the SharePoint 2019 September 2024 Cumulative Upgrade (this one), where a webpart control is unable to load due to the following exception: [ArgumentException: The serialized data is invalid.] at…
Custom Manifest-Addin not visible after loading
I am currently working on a custom outlook addin generated with the yeoman generator. I have done this for word already and there I didn't have any problems. In Outlook it took quiet a while and a Microsoft 365 Subscription to load the addin but now it…
I am unable to submit answers for a knowledge check in the sentinel module.
The submit button just keep circling when attempting to submit my answers for a knowledge check in tte sentinel module. I have tried refreshing the page, logging out and back in and evennchanging devices to no avail. This question is related to the…
In New Outlook - how do I know whether I'm replying to latest email in the thread
In New Outlook - how do I know whether I'm replying to latest email in the thread
How to fix "Username & Password" pop-up on Microsoft Outlook
I have Exchange 2019 Onpremise configured. Client are connected with outlook. Everytime when using outlook, a square pop-up always rises and ask for username and password. Even if you enter those informations, it still showing the popup. How can i solve…
Your account has been lockedWe've detected and removed content in your account that violates our Microsoft Services Agreement and have locked your account.
abhisheknweng@outlook.com Your account has been locked We've detected and removed content in your account that violates our Microsoft Services Agreement and have locked your account. Unlocking your account To unlock your account, you'll need some…