Tag Archives: microsoft
Dynamic Arrays – Extend the last logical row value in a 2D array
One more for experts. Again, with my new found knowledge I still was not quite able to make this work.
Simple balance sheet values that I need to extend into the forecasts as is. i.e. the last actual value in the row of that block – BUT, the block has several rows each for a different entity and I have an option for have staggered actuals based on the data loaded. i.e. if Entity A has values to 30th Sep 2024 then this is the latest value to carry forward for Entity A. But entity B may only have actuals up to 31st August so I need to take the value for August to carry forward.
I prefer to use flags for the logic. Sample attached
Appreciate the help
One more for experts. Again, with my new found knowledge I still was not quite able to make this work. Simple balance sheet values that I need to extend into the forecasts as is. i.e. the last actual value in the row of that block – BUT, the block has several rows each for a different entity and I have an option for have staggered actuals based on the data loaded. i.e. if Entity A has values to 30th Sep 2024 then this is the latest value to carry forward for Entity A. But entity B may only have actuals up to 31st August so I need to take the value for August to carry forward.I prefer to use flags for the logic. Sample attached Appreciate the help Read More
Dernière mise à jour
Bonsoir depuis les dernières mise à jour de Windows 11 que j’ ai effectué mon pc redémarre seul.et avant de s’éteindre il affiche l’écran bleu de Windows et ensuite il se teint avant de se rallumer et s’éteindre encore après quelques minutes. Aidé moi SVP j’ai un projet à terminer et des examens à préparer mais je n’ y arrive pas à cause de cette anomalie
Merci
Bonsoir depuis les dernières mise à jour de Windows 11 que j’ ai effectué mon pc redémarre seul.et avant de s’éteindre il affiche l’écran bleu de Windows et ensuite il se teint avant de se rallumer et s’éteindre encore après quelques minutes. Aidé moi SVP j’ai un projet à terminer et des examens à préparer mais je n’ y arrive pas à cause de cette anomalie Merci Read More
List is not keeping the correct time entered
I have a List that was working fine until the recent time change today. I have several Time Date columns where users enter the Date and Time for a particular Flight, like ETD, Actuak ETD and a Ready time.
I am using a Powerapps form that they enter the info to and when it is submitted, the list is subtracting an hour off of the time that was entered on the form, for instance if a user enters 1300 on the powerapps form, the list is showing, in that column 1200. it started this morning.
I changed the computer timezone to mountain, thinking that would help compensate, since we are pacific, but that did not work. We did not have this issue with the spring forward. Lost as to what to add to my code or what i could do as a work around as those times for us are important, I work for an airline and we track these time.
Thank you
I have a List that was working fine until the recent time change today. I have several Time Date columns where users enter the Date and Time for a particular Flight, like ETD, Actuak ETD and a Ready time.I am using a Powerapps form that they enter the info to and when it is submitted, the list is subtracting an hour off of the time that was entered on the form, for instance if a user enters 1300 on the powerapps form, the list is showing, in that column 1200. it started this morning.I changed the computer timezone to mountain, thinking that would help compensate, since we are pacific, but that did not work. We did not have this issue with the spring forward. Lost as to what to add to my code or what i could do as a work around as those times for us are important, I work for an airline and we track these time. Thank you Read More
फोनपे में गलत ट्रांजेक्शन कैसे रिफंड करें?
फ़ोनपे से पैसे कट जाने पर, ये कदम उठाए जा सकते ग्राहक सहायता से संपर्क(9088^566√267) है फ़ोनपे ऐप में जाकर, “ट्रांज़ैक्शन” या “इतिहास” सेक्शन में जाएं. असफल लेन-देन चुनें. “वापस लें” या “वापस लेने के लिए अनुरोध करें” विकल्प चुनें. अगर रिफ़ंड नहीं मिलता, तो अपने बैंक से संपर्क करें.
फ़ोनपे से पैसे कट जाने पर, ये कदम उठाए जा सकते ग्राहक सहायता से संपर्क(9088^566√267) है फ़ोनपे ऐप में जाकर, “ट्रांज़ैक्शन” या “इतिहास” सेक्शन में जाएं. असफल लेन-देन चुनें. “वापस लें” या “वापस लेने के लिए अनुरोध करें” विकल्प चुनें. अगर रिफ़ंड नहीं मिलता, तो अपने बैंक से संपर्क करें. Read More
फोनपे गलत ट्रांजेक्शन रिफंड मनी?
किसी गलत लेनदेन के लिए फोनपे से पैसे वापस करने के लिए, आपको तुरंत के फोनपे ग्राहक सहायता से संपर्क करना चाहिए: (08016×727√970) और उपलब्ध) रिपोर्ट करें,
किसी गलत लेनदेन के लिए फोनपे से पैसे वापस करने के लिए, आपको तुरंत के फोनपे ग्राहक सहायता से संपर्क करना चाहिए: (08016×727√970) और उपलब्ध) रिपोर्ट करें, Read More
Windows Server 2025 is generally available as of Nov 1!!
Sweet! Build 26100.1742 is the final, ‘RTM’. Available for download now on M365 Admin Center website (formerly VLSC) and other official download locations.
Windows Server 2025 known issues and notifications | Microsoft Learn
Windows Server release information | Microsoft Learn
What’s new in Windows Server 2025 | Microsoft Learn
Happy downloading, installing…in-place upgrading! 😉
– Michael
Sweet! Build 26100.1742 is the final, ‘RTM’. Available for download now on M365 Admin Center website (formerly VLSC) and other official download locations. Windows Server 2025 known issues and notifications | Microsoft Learn Windows Server release information | Microsoft Learn What’s new in Windows Server 2025 | Microsoft Learn Happy downloading, installing…in-place upgrading! 😉 – Michael Read More
Looking for Security Insights on Premium APK Files
Files Hello Microsoft Tech Community,
I hope you’re all doing well. I’m currently diving into research on security factors tied to premium APK files, with a specific focus on apps like Spotify Premium APK. I’d greatly appreciate the community’s expertise on best practices for assessing the security risks of downloading and using these premium APK files.
In particular, I’m looking to understand ways to detect potential malware, guard against vulnerabilities, and ensure secure usage within a Windows environment.
Any advice on tools, methods, or industry standards for evaluating APK file integrity and security would be incredibly helpful. Thank you in advance for sharing your knowledge!
Files Hello Microsoft Tech Community, I hope you’re all doing well. I’m currently diving into research on security factors tied to premium APK files, with a specific focus on apps like Spotify Premium APK. I’d greatly appreciate the community’s expertise on best practices for assessing the security risks of downloading and using these premium APK files.In particular, I’m looking to understand ways to detect potential malware, guard against vulnerabilities, and ensure secure usage within a Windows environment.Any advice on tools, methods, or industry standards for evaluating APK file integrity and security would be incredibly helpful. Thank you in advance for sharing your knowledge! Read More
मैं कुकू एफएम से शिकायत कैसे करूं?ch
को मुख्य रूप से रिफंड, अकाउंट, भुगतान और शुल्क के लिए कॉल करते हैं। से संपर्क करने के लिए सबसे अच्छा ईमेल email address removed for privacy reasons है।,(09088-566×267)% ग्राहक अपनी समस्याओं और चिंताओं को संबोधित करने के लिए इस ईमेल पते का उपयोग करते हैं
को मुख्य रूप से रिफंड, अकाउंट, भुगतान और शुल्क के लिए कॉल करते हैं। से संपर्क करने के लिए सबसे अच्छा ईमेल email address removed for privacy reasons है।,(09088-566×267)% ग्राहक अपनी समस्याओं और चिंताओं को संबोधित करने के लिए इस ईमेल पते का उपयोग करते हैं Read More
मैं फोनपे पर गलत ट्रांजेक्शन कैसे रिफंड करूं?fh
किसी गलत लेनदेन के लिए फोनपे से पैसे वापस करने के लिए, आपको तुरंत के फोनपे ग्राहक सहायता से संपर्क करना चाहिए: (08016×727√970) और उपलब्ध) रिपोर्ट करें …
किसी गलत लेनदेन के लिए फोनपे से पैसे वापस करने के लिए, आपको तुरंत के फोनपे ग्राहक सहायता से संपर्क करना चाहिए: (08016×727√970) और उपलब्ध) रिपोर्ट करें … Read More
Teams application hosted media bot not calling webhook
I have setup a media bot as per the instructions mentioned in PsiBot. The TCP address has been added in the firewall. Necessary API permissions in App Registration has been provided. Currently, testing on local computer using ngrok and followed the instructions mentioned in the link above.
Issues:
- In an online teams meeting an App is added to the meeting and a call to JoinCallAsync api for bot to join the call occurs, which is successful. But after that nothing happens. The bot is not added in the meeting.
- The call to webhook (api/calling) should be called which is not happening.
Please guide what should be done to add the bot to the meeting to fetch the audio of participants.
1. Ngrok points TCP to: Forwarding tcp://0.tcp.in.ngrok.io:12345 -> localhost:8445
In domain added the below record: CNAME 0.local.bot mapped to 0.tcp.in.ngrok.io
Created certificate using openssl for *.local.bot.example.com and added in the Microsoft Management Control under Personal Certificates. The program has accepted this certificate i.e. no exception occurred.
2. Added all the ports, domains, endpoints, application id in the appsettings of the project.
3. Set supportsCalling to true in manifest file
How can the issue be traced? Please guide.
I have setup a media bot as per the instructions mentioned in PsiBot. The TCP address has been added in the firewall. Necessary API permissions in App Registration has been provided. Currently, testing on local computer using ngrok and followed the instructions mentioned in the link above.Issues:In an online teams meeting an App is added to the meeting and a call to JoinCallAsync api for bot to join the call occurs, which is successful. But after that nothing happens. The bot is not added in the meeting.The call to webhook (api/calling) should be called which is not happening. Please guide what should be done to add the bot to the meeting to fetch the audio of participants.1. Ngrok points TCP to: Forwarding tcp://0.tcp.in.ngrok.io:12345 -> localhost:8445In domain added the below record: CNAME 0.local.bot mapped to 0.tcp.in.ngrok.ioCreated certificate using openssl for *.local.bot.example.com and added in the Microsoft Management Control under Personal Certificates. The program has accepted this certificate i.e. no exception occurred.2. Added all the ports, domains, endpoints, application id in the appsettings of the project.3. Set supportsCalling to true in manifest fileHow can the issue be traced? Please guide. Read More
Formulas and Functions
Hi, I have a formula =’Child 40′ !$V$38. I need to copy formula down for another 40 cells but change the child number each time in sequence keeping same cell reference, I’m stuck on how to do it.
Hi, I have a formula =’Child 40′ !$V$38. I need to copy formula down for another 40 cells but change the child number each time in sequence keeping same cell reference, I’m stuck on how to do it. Read More
Excel Solver Question
Hi. I am working on hypothetical problem relating to optimizing expected return on investments subject to constraints. I cannot figure out how to put the linear programming model I developed into the excel format so that I can use excel solver to find the optimal solution. Would appreciate any help I could get in figuring this out. Do I need to solve for the expected return, the mean, the standard deviation, as well as have a covariance matrix? I have attached the question below, it is part B that I cannot figure out how to input into excel solver.
Hi. I am working on hypothetical problem relating to optimizing expected return on investments subject to constraints. I cannot figure out how to put the linear programming model I developed into the excel format so that I can use excel solver to find the optimal solution. Would appreciate any help I could get in figuring this out. Do I need to solve for the expected return, the mean, the standard deviation, as well as have a covariance matrix? I have attached the question below, it is part B that I cannot figure out how to input into excel solver. Read More
Will the Microsoft License email for a staff member override Board member emails in different domain
My organization’s Board of Directors uses Vieth (CPanel) for our email domain and server. We are hiring a new Executive Director and want to purchase Microsofit 365 for nonprofits to provide her with everything to be successful, including the same email domain as the Board. I’ve heard that if I switch the email domain into Microsoft, then no emails will go into the original email provider. Does this only happen to the individual email that was moved over to Microsoft, or to all of them?
Our ideal situation:
– email address removed for privacy reasons is on Microsoft 365 with Outlook and sends/receives emails
– email address removed for privacy reasons is on Vieth (CPanel) and sends/receives emails
I want to avoid a situation the discontinues the ability for our Board members to continue using the original domain if it is overridden by the Microsoft one.
I hope this was clear! I appreciate and reassurance or guidance. Thank you in advance!
My organization’s Board of Directors uses Vieth (CPanel) for our email domain and server. We are hiring a new Executive Director and want to purchase Microsofit 365 for nonprofits to provide her with everything to be successful, including the same email domain as the Board. I’ve heard that if I switch the email domain into Microsoft, then no emails will go into the original email provider. Does this only happen to the individual email that was moved over to Microsoft, or to all of them? Our ideal situation:- email address removed for privacy reasons is on Microsoft 365 with Outlook and sends/receives emails- email address removed for privacy reasons is on Vieth (CPanel) and sends/receives emails I want to avoid a situation the discontinues the ability for our Board members to continue using the original domain if it is overridden by the Microsoft one. I hope this was clear! I appreciate and reassurance or guidance. Thank you in advance! Read More
Retiring / Deleting Entra ID Joined device will make it unaccessible
Hi community,
am I alone with this issue? I’m currently testing some Intune functions with a testing device and account. I just found out that deleting or retiring an intune device (AD joined, no local backup account) from the web interface will make it unusable after restart. It will ask for the password of the AD user and won’t even accept the correct password.
Is this issue known? Is there a workaround to gain access to the data? In a prod environment with bitlocker enabled this is a nightmare.
Hi community,am I alone with this issue? I’m currently testing some Intune functions with a testing device and account. I just found out that deleting or retiring an intune device (AD joined, no local backup account) from the web interface will make it unusable after restart. It will ask for the password of the AD user and won’t even accept the correct password. Is this issue known? Is there a workaround to gain access to the data? In a prod environment with bitlocker enabled this is a nightmare. Read More
Follow-up: Microsoft Word – Getting rid of unused fields in equations (small dotted squares)
Dear All,
This is a follow-up from post https://techcommunity.microsoft.com/t5/microsoft-365/microsoft-word-getting-rid-of-unused-fields-in-equations-small/m-p/4269588#M54220
(which I believe is not seen anymore since a first solution was proposed))
Apparently due to an Apr 2024 bug in Word, “placeholder” boxes in Word equations are displaying when printed or converted to PDF when they did not used to. I’m trying to get a working macro to detect such empty fields and delete them (or at least, populate them with an empty space ” ” so that the small dotted squares don’t show anymore).
I’m trying to have a working macro, unfortunately without success yet.
Equations are indeed detected, if I display them I see their fields (all in 1 MsgBox).
Now, the eq itself will not be “empty”, some of of the eq fields might be.
I cannot find a way to go through each field of each equation, and then delete (or assign ” “) to each empty field.
Your opinion and help on this would be most welcome!
Thank you!
Sub SearchEmptyFields() Dim eq As OMath 'Trying to define a range to go through eq fields Dim r As Range For Each eq In ActiveDocument.OMaths 'This displays all fields of the current eq MsgBox ("Found: " & eq.Range.Text) 'Trying to get through each field of the current eq... without success 'For Each r In eq.Rang."element???" ' MsgBox ("Range: " & eq.Range.element.Text) ' Do a "delete" or put field value to " " 'Next r Exit Sub Next eq
Dear All, This is a follow-up from post https://techcommunity.microsoft.com/t5/microsoft-365/microsoft-word-getting-rid-of-unused-fields-in-equations-small/m-p/4269588#M54220(which I believe is not seen anymore since a first solution was proposed)) Apparently due to an Apr 2024 bug in Word, “placeholder” boxes in Word equations are displaying when printed or converted to PDF when they did not used to. I’m trying to get a working macro to detect such empty fields and delete them (or at least, populate them with an empty space ” ” so that the small dotted squares don’t show anymore). I’m trying to have a working macro, unfortunately without success yet.Equations are indeed detected, if I display them I see their fields (all in 1 MsgBox).Now, the eq itself will not be “empty”, some of of the eq fields might be.I cannot find a way to go through each field of each equation, and then delete (or assign ” “) to each empty field. Your opinion and help on this would be most welcome! Thank you! Sub SearchEmptyFields()
Dim eq As OMath
‘Trying to define a range to go through eq fields
Dim r As Range
For Each eq In ActiveDocument.OMaths
‘This displays all fields of the current eq
MsgBox (“Found: ” & eq.Range.Text)
‘Trying to get through each field of the current eq… without success
‘For Each r In eq.Rang.”element???”
‘ MsgBox (“Range: ” & eq.Range.element.Text)
‘ Do a “delete” or put field value to ” “
‘Next r
Exit Sub
Next eq Read More
I need a function to return last date of update
Hi
I need a function to do this case:
in the attached file, based on the values of cells range A3:L19 and the values of cells range A1:L1; if there is data (P OR Number value from (1 to 5)) in the range (A3:L18) or the values of range A1:A18 are equal to (True), I need a function to return the last date of update which is a value from the range (B2:B18) in this case; it should be the last date of update 16/10/2024
Thanks.
HiI need a function to do this case:in the attached file, based on the values of cells range A3:L19 and the values of cells range A1:L1; if there is data (P OR Number value from (1 to 5)) in the range (A3:L18) or the values of range A1:A18 are equal to (True), I need a function to return the last date of update which is a value from the range (B2:B18) in this case; it should be the last date of update 16/10/2024Thanks. Read More
गूगल पे से गलत पेमेंट हो जाए तो क्या करें?
गूगल पे से गलत पेमेंट हो जाए तो क्या करें?
गूगल पे से गलत पेमेंट हो जाए तो क्या करें? – आप गूगल पे हेल्पलाइन नंबर ( +91 O9339-176-804 (भाषा: हिंदी और अंग्रेजी) पर भी कॉल कर सकते हैं।… ,,,
गूगल पे से गलत पेमेंट हो जाए तो क्या करें?गूगल पे से गलत पेमेंट हो जाए तो क्या करें? – आप गूगल पे हेल्पलाइन नंबर ( +91 O9339-176-804 (भाषा: हिंदी और अंग्रेजी) पर भी कॉल कर सकते हैं।… ,,, Read More
Excel Column Sorting Question
Is there a way to prevent certain columns from sorting on a sheet?
I have 5 columns of data – 1500 lines in A, their attributes are in columns B-E, listed in a header row (1), i.e., size, shape, color, etc.
I can filter all columns, just fine. Then, I added a ‘cheetsheet’ of text to remind me of what the attributes are for each column (B-E). I added this text in column G (leaving column F empty) with the hope that when I sort (filter) any other columns (A-E), the text in G would be unaffected.
Can I (easily) separate G from the filers and sorting in columns A-E?
Is there a way to prevent certain columns from sorting on a sheet?I have 5 columns of data – 1500 lines in A, their attributes are in columns B-E, listed in a header row (1), i.e., size, shape, color, etc. I can filter all columns, just fine. Then, I added a ‘cheetsheet’ of text to remind me of what the attributes are for each column (B-E). I added this text in column G (leaving column F empty) with the hope that when I sort (filter) any other columns (A-E), the text in G would be unaffected. Can I (easily) separate G from the filers and sorting in columns A-E? Read More
How do I permanently store module?
Hi everyone, I’m new to powershell, I would like to know how to automatically load the modules I load with import-module in each instance; if I load the modules with import-module, when I close the instance I lose the module. I would like to know how to permanently load, for example, the KPI module in the $Env:PsModulePath variable. Obviously the question is answered to all the modules that I always want to keep in section even when I start the computer. I hope for an answer
Hi everyone, I’m new to powershell, I would like to know how to automatically load the modules I load with import-module in each instance; if I load the modules with import-module, when I close the instance I lose the module. I would like to know how to permanently load, for example, the KPI module in the $Env:PsModulePath variable. Obviously the question is answered to all the modules that I always want to keep in section even when I start the computer. I hope for an answer Read More
Error Handling in a Macro
I have written a Workbook_Open() script which runs on startup and checks for the presence or absence of a named TextBox, The code that follows this check depends upon whether or not the TexBox exists.
The problem is, I get Error 1004 when I try to delete it and its not there, and the IfError statement does not handle this situation. I have not tried the condition of selecting it when its not there, but I assume I would get the same result.
Is there any other way to determing the presence or absence of a TextBox using a macro?
I have written a Workbook_Open() script which runs on startup and checks for the presence or absence of a named TextBox, The code that follows this check depends upon whether or not the TexBox exists.The problem is, I get Error 1004 when I try to delete it and its not there, and the IfError statement does not handle this situation. I have not tried the condition of selecting it when its not there, but I assume I would get the same result.Is there any other way to determing the presence or absence of a TextBox using a macro? Read More