Tag Archives: microsoft
Credential Manager for Outlook :
I have an outlook email address and account. Recently there was some sort of muddle, due, apparently, to having tried to access it from a laptop which I seldom use. I received a message from Microsoft suggesting that I should change my password.
That was done, and things worked ok until a new version of Thunderbird was installed. This refused to accept the new password, and will not connect with Outlook.com unless there is a new message.
I need to find what passwords are stored in Windows Credentials Manager.
Yes, there are ‘help’ pages which explain how to do it, but none of them seem to work.
I have an outlook email address and account. Recently there was some sort of muddle, due, apparently, to having tried to access it from a laptop which I seldom use. I received a message from Microsoft suggesting that I should change my password.That was done, and things worked ok until a new version of Thunderbird was installed. This refused to accept the new password, and will not connect with Outlook.com unless there is a new message. I need to find what passwords are stored in Windows Credentials Manager.Yes, there are ‘help’ pages which explain how to do it, but none of them seem to work. Read More
Help in grouping function desired output
Every RuleID has different Ruleperiod, RuleDate and Rulestatus. I want the following desired output as per below calculation.
I want to display those row only which has Rulestatus-‘Active’. Every group/RuleID has only one row of Rulestatus-‘Active’.
Calculation of RuleDate_Max : This will be the max(RuleDate).
Calculation of Ruleperiod_Left: Max(Ruleperiod)-Ruleperiod (which has Rulestatus-‘Active’). Example for RuleID-AA: 14-11=3
Calculation of RuleDate_Left_Round_Month: Max(RuleDate)-RuleDate (which has Rulestatus-‘Active’). Example for RuleID-AA: ‘2023-03-06’-‘2022-11-03’=4 months in round. Month number should be in round month.
Create table #Classic (RuleID char(10), Ruleperiod int, RuleDate datetime, Rulestatus char(10))
Insert into #Classic values (‘AA’,10, ‘2022-10-01′,’UnActive’)
Insert into #Classic values (‘AA’,11, ‘2022-11-03′,’Active’)
Insert into #Classic values (‘AA’,12, ‘2022-12-04′,’UnActive’)
Insert into #Classic values (‘AA’,13, ‘2023-01-02′,’UnActive’)
Insert into #Classic values (‘AA’,14, ‘2023-03-06′,’UnActive’)
Insert into #Classic values (‘CC’,22, ‘2023-10-02′,’UnActive’)
Insert into #Classic values (‘CC’,23, ‘2023-11-02′,’Active’)
Insert into #Classic values (‘CC’,24, ‘2023-12-03′,’UnActive’)
Insert into #Classic values (‘CC’,25, ‘2024-01-04′,’UnActive’)
Insert into #Classic values (‘DD’,22, ‘2023-10-02′,’UnActive’)
Insert into #Classic values (‘DD’,23, ‘2023-10-20′,’UnActive’)
Insert into #Classic values (‘DD’,24, ‘2023-11-01′,’Active’)
Insert into #Classic values (‘DD’,25, ‘2023-11-15′,’UnActive’)
Insert into #Classic values (‘DD’,26, ‘2023-11-28′,’UnActive’)
Desired output:
—————–
RuleID Ruleperiod RuleDate_of_Active RuleDate_Max Ruleperiod_Left RuleDate_Left_Round_Month
AA 11 2022-11-03 2023-03-06 3 4
CC 23 2023-11-02 2024-01-04 2 2
DD 24 2023-11-01 2023-11-28 2 0
Every RuleID has different Ruleperiod, RuleDate and Rulestatus. I want the following desired output as per below calculation.I want to display those row only which has Rulestatus-‘Active’. Every group/RuleID has only one row of Rulestatus-‘Active’.Calculation of RuleDate_Max : This will be the max(RuleDate).Calculation of Ruleperiod_Left: Max(Ruleperiod)-Ruleperiod (which has Rulestatus-‘Active’). Example for RuleID-AA: 14-11=3Calculation of RuleDate_Left_Round_Month: Max(RuleDate)-RuleDate (which has Rulestatus-‘Active’). Example for RuleID-AA: ‘2023-03-06’-‘2022-11-03’=4 months in round. Month number should be in round month.Create table #Classic (RuleID char(10), Ruleperiod int, RuleDate datetime, Rulestatus char(10))Insert into #Classic values (‘AA’,10, ‘2022-10-01′,’UnActive’)Insert into #Classic values (‘AA’,11, ‘2022-11-03′,’Active’)Insert into #Classic values (‘AA’,12, ‘2022-12-04′,’UnActive’)Insert into #Classic values (‘AA’,13, ‘2023-01-02′,’UnActive’)Insert into #Classic values (‘AA’,14, ‘2023-03-06′,’UnActive’) Insert into #Classic values (‘CC’,22, ‘2023-10-02′,’UnActive’)Insert into #Classic values (‘CC’,23, ‘2023-11-02′,’Active’)Insert into #Classic values (‘CC’,24, ‘2023-12-03′,’UnActive’)Insert into #Classic values (‘CC’,25, ‘2024-01-04′,’UnActive’) Insert into #Classic values (‘DD’,22, ‘2023-10-02′,’UnActive’)Insert into #Classic values (‘DD’,23, ‘2023-10-20′,’UnActive’)Insert into #Classic values (‘DD’,24, ‘2023-11-01′,’Active’)Insert into #Classic values (‘DD’,25, ‘2023-11-15′,’UnActive’)Insert into #Classic values (‘DD’,26, ‘2023-11-28′,’UnActive’)Desired output:—————–RuleID Ruleperiod RuleDate_of_Active RuleDate_Max Ruleperiod_Left RuleDate_Left_Round_MonthAA 11 2022-11-03 2023-03-06 3 4CC 23 2023-11-02 2024-01-04 2 2DD 24 2023-11-01 2023-11-28 2 0 Read More
Why does MS Teams struggle with 200 users?
At work we used Microsoft 365 for Business. As a consequence, we also use Microsoft Teams for Business (I think that’s the correct name). I work as a software engineer. The IT group is about 200 people, which includes all the developers, IT Admins, DBAs, etc. For a couple years we’ve been using MS Teams for our group’s meetings. We also use MS Teams for agency wide meetings, which normally brings in 500+ people.
However, for a while now (I don’t know how long, because the IT group doesn’t share that information) when we’ve had meetings involving all of IT, sometimes people loose connection and get dropped. They reconnect to rejoin the meeting, but it has become a problem. So much so that the agency is considering dropping MS Teams entirely, in favor of Zoom.
Personally, I like MS Teams more than Zoom, but clearly this issue must be resolved. I had thought that Microsoft had made MS Teams capable handling thousands of simultaneous users in a meeting. So, what gives? Why is MS Teams behaving so poorly?
At work we used Microsoft 365 for Business. As a consequence, we also use Microsoft Teams for Business (I think that’s the correct name). I work as a software engineer. The IT group is about 200 people, which includes all the developers, IT Admins, DBAs, etc. For a couple years we’ve been using MS Teams for our group’s meetings. We also use MS Teams for agency wide meetings, which normally brings in 500+ people. However, for a while now (I don’t know how long, because the IT group doesn’t share that information) when we’ve had meetings involving all of IT, sometimes people loose connection and get dropped. They reconnect to rejoin the meeting, but it has become a problem. So much so that the agency is considering dropping MS Teams entirely, in favor of Zoom. Personally, I like MS Teams more than Zoom, but clearly this issue must be resolved. I had thought that Microsoft had made MS Teams capable handling thousands of simultaneous users in a meeting. So, what gives? Why is MS Teams behaving so poorly? Read More
日をまたぐ睡眠時間の計算方法
睡眠時間を簡便に計算する方法について、助けていただきたく存じます。
例えば、
1/1 22:00 に就寝し 1/2 6:00 に起床した場合、睡眠時間は8時間ですが
単なる足し算引き算や、セルの書式設定（分類で [h]:mm;@を入力）では、
正しい答えが出てきません。
簡便な方法はあるはずだと思うので、ご協力よろしくお願いします。
睡眠時間を簡便に計算する方法について、助けていただきたく存じます。例えば、1/1 22:00 に就寝し 1/2 6:00 に起床した場合、睡眠時間は8時間ですが単なる足し算引き算や、セルの書式設定（分類で [h]:mm;@を入力）では、正しい答えが出てきません。簡便な方法はあるはずだと思うので、ご協力よろしくお願いします。 Read More
Sum formula across sheets with matching column
Platform: Excel 365
I need Columns A, B, C and E to match in both October and November sheets. If they match, then October column L is added to November column J, the result is shown in November column L. If there is no match, November column J = November column L.
I‘ve attached screen shot of a mocked up template, I can‘t share the real one due to it being a work document with protected info. But the months cover the span of the year and as clients get added to or taken away from the list, I need a way to accurately, and automatically calculate the year-to-date total spent.
Thank you! This is well beyond my Excel skills
Platform: Excel 365I need Columns A, B, C and E to match in both October and November sheets. If they match, then October column L is added to November column J, the result is shown in November column L. If there is no match, November column J = November column L. I’ve attached screen shot of a mocked up template, I can’t share the real one due to it being a work document with protected info. But the months cover the span of the year and as clients get added to or taken away from the list, I need a way to accurately, and automatically calculate the year-to-date total spent. Thank you! This is well beyond my Excel skills Read More
Auto-restart numbering for custom styles
Greetings word experts,
Thanks for reading this.
I have created custom styles for use in a script document.
I’ve created a “Chapter” style which is based on heading 1, and a “Topic” style which is based on heading 2. Both are set to use numbering with the text “Chapter x” and “Topic x” respectively where “x” is the auto number. This way, if I decide to move chapters or topics around the document my numbering remains correct and is updated automatically.
My challenge is having the topic number auto-restart to 1 for each new chapter.
Currently, when I start a new chapter and then start a new topic, the topic numbering continues from the last chapter.
I can correct it manually for each chapter, but I’m wondering if there is a way for an auto-restart after encountering a ‘higher level’ heading as part of the style definition.
Your help will be appreciated, and have a great day!
Greetings word experts,Thanks for reading this.I have created custom styles for use in a script document. I’ve created a “Chapter” style which is based on heading 1, and a “Topic” style which is based on heading 2. Both are set to use numbering with the text “Chapter x” and “Topic x” respectively where “x” is the auto number. This way, if I decide to move chapters or topics around the document my numbering remains correct and is updated automatically. My challenge is having the topic number auto-restart to 1 for each new chapter.Currently, when I start a new chapter and then start a new topic, the topic numbering continues from the last chapter.I can correct it manually for each chapter, but I’m wondering if there is a way for an auto-restart after encountering a ‘higher level’ heading as part of the style definition.Your help will be appreciated, and have a great day! Read More
DataSource.Error: Anulada la solicitud: No se puede crear un canal seguro SSL/TLS. Detalles:
Hola apreciada comunidad, tengo inconvenietes con mi excel es la primera vez que uso esta funcion con de obtener datos desde la web con excel 2016 y me sale el siguiente erro
DataSource.Error: Anulada la solicitud: No se puede crear un canal seguro SSL/TLS.
Detalles: url
que puedo hacer no encuentro ninguna solucion gracias
Hola apreciada comunidad, tengo inconvenietes con mi excel es la primera vez que uso esta funcion con de obtener datos desde la web con excel 2016 y me sale el siguiente erro DataSource.Error: Anulada la solicitud: No se puede crear un canal seguro SSL/TLS.Detalles: url que puedo hacer no encuentro ninguna solucion gracias Read More
How to color a cell based on value
Need help coloring the cells b:2-B:10 red or green based on their value relative higher or lower to cells D:4-D:7.
Need help coloring the cells b:2-B:10 red or green based on their value relative higher or lower to cells D:4-D:7. Read More
Get command status from Active Directory Domain machines
We need to get the status of few commands from a domain environment of around 400 machines. All may be windows 10 and windows 11 machines. Need to run this activity couple of times in a day.
This may required few Power Shell commands with admin credentials OR we may run this from GPO. But I don’t know where can we save the status result from machines
(Power Shell script running is disabled via GPO so we may need to run PowerShell commands directly)
Commands status result are required (windows 10/11):
– Last Windows update status
– Bit Locker installed and configured status
– Total Local Admin users
– LAPs is installed on not on machine
We need to get the status of few commands from a domain environment of around 400 machines. All may be windows 10 and windows 11 machines. Need to run this activity couple of times in a day. This may required few Power Shell commands with admin credentials OR we may run this from GPO. But I don’t know where can we save the status result from machines(Power Shell script running is disabled via GPO so we may need to run PowerShell commands directly) Commands status result are required (windows 10/11):- Last Windows update status- Bit Locker installed and configured status- Total Local Admin users- LAPs is installed on not on machine Read More
Macros are not executed via inserted button
Can someone help me with the following problem:
I want to execute a macro via a button. I have created the macro via a recording and it can also be started from the macro overview. If I now assign macros to a button via “Right-click > Assign macro …” and then click on the button, the macro is not executed. What could I have forgotten here?
Thank you for any help!
Can someone help me with the following problem:I want to execute a macro via a button. I have created the macro via a recording and it can also be started from the macro overview. If I now assign macros to a button via “Right-click > Assign macro …” and then click on the button, the macro is not executed. What could I have forgotten here?Thank you for any help! Read More
How to see Google Tasks in Outllook?
How to see Google Tasks in Outlook us I see Outlook items and SUBtask is not seen inside Outlook 2007 Pro version. Is it supported inside a new version?
How to see Google Tasks in Outlook us I see Outlook items and SUBtask is not seen inside Outlook 2007 Pro version. Is it supported inside a new version? Read More
Windows 11 Insider Update not working
Ive reinstalled Windows because of another Update Issue thats been about 2-3 weeks ago and since then i had no new Updates of Windows 11 I cannot click the Update Button but it still says it last checked Today
Im sorry for the Screenshots in German
Ive reinstalled Windows because of another Update Issue thats been about 2-3 weeks ago and since then i had no new Updates of Windows 11 I cannot click the Update Button but it still says it last checked Today Im sorry for the Screenshots in German Read More
2024 – Outlook redirecting me to its home page when I’m elsewhere, including Chrome
No matter what I’m doing; creating an email, responding to one, working in Chrome, sometimes I’ll get redirected to my Outlook home page on my computer (not the URL). I don’t have the “new look” option on. Anyone know how I can fix this?
Thank you in advance!
No matter what I’m doing; creating an email, responding to one, working in Chrome, sometimes I’ll get redirected to my Outlook home page on my computer (not the URL). I don’t have the “new look” option on. Anyone know how I can fix this?Thank you in advance! Read More
Verification emails not being received
Hi,
My verification emails from CDkeys.com and Ubisoft are not being received to my Hotmail (now outlook) account.
nothing in Junk, ubisoft.com and cdkeys.com are whitelisted and mailbox isnt full
please help
Hi,My verification emails from CDkeys.com and Ubisoft are not being received to my Hotmail (now outlook) account.nothing in Junk, ubisoft.com and cdkeys.com are whitelisted and mailbox isnt full please help Read More
Transpose columns to rows between two files with Tanspose formula
I have type the formula
=TRANSPOSE([MT_Line.Flow.csv]MT_Line.Flow!$JR$2:$JR$37)
“File name and sheet name is the same in the origin file”
I feel that Excel works with that formula but the data is not showed, please help!
I have type the formula =TRANSPOSE([MT_Line.Flow.csv]MT_Line.Flow!$JR$2:$JR$37) “File name and sheet name is the same in the origin file” I feel that Excel works with that formula but the data is not showed, please help! Read More
how to enabled developer mode on window 11pro
i need help with enabling my laptop to a developer mode in the settings can anyone assist me on this??
i need help with enabling my laptop to a developer mode in the settings can anyone assist me on this?? Read More
Analyse data in office365 online
Analyse data function is not showing in office 365 online , please help
Analyse data function is not showing in office 365 online , please help Read More
Help using Word equation editor
I have been unable to do two separate things that i consider quite essential for advanced mathematics.
I am unable to find any way of implementing a block matrix. That is a big matrix that is dividied into submatrices by vertical and horizontal lines within the matrix
I can’t find a way to cancel equation terms to zero with an arrow striking through them. Similar to the cancelto command in Latex
Any suggestions are welcome. Thank you!
Question 1
Question 2
I have been unable to do two separate things that i consider quite essential for advanced mathematics.I am unable to find any way of implementing a block matrix. That is a big matrix that is dividied into submatrices by vertical and horizontal lines within the matrixI can’t find a way to cancel equation terms to zero with an arrow striking through them. Similar to the cancelto command in LatexAny suggestions are welcome. Thank you! Question 1 Question 2 Read More
fingerprint and facial recognition is unavailable
when i am using windows 10 i am able to use my fingerprint and facial recognition lock. after updating to windows 11 insider i am not able to use this. can you solve this problem
when i am using windows 10 i am able to use my fingerprint and facial recognition lock. after updating to windows 11 insider i am not able to use this. can you solve this problem Read More
