Category: Microsoft
Category Archives: Microsoft
Cell Style Keeps Reappearing after being Deleted
I’m using Excel under a M365 Home subscription (Version 2408 Build 16.0.17928.20114 64-bit)
The Problem:
Even in brand new, blank workbooks, whenever I delete the default cell styles for “Hyperlink” and “Followed Hyperlink,” these cell styles will reappear and apply themselves on their own the next time a hyperlink is created or followed in the workbook. This occurs whether the hyperlink is created via VBA, cell formula, or the “insert hyperlink” wizard/dialogue.
What I’ve Tried:
1. I have turned off the “AutoFormat As You Type” option to automatically replace “Internet and Network paths with hyperlinks;” the problem persists
2. I have deleted all cell styles (other than the “normal” cell style, which cannot be deleted) in the active workbook and my PERSONAL.xlsb workbook; the problem persists
3. I have used VBA to delete the cell styles (as compared to just right clicking the cell style and selecting “delete”); the problem persists
The Question:
Any idea how to prevent Excel from automatically re-adding the “Hyperlink” and “Followed Hyperlink” cell styles after they’ve been deleted? I want hyperlinks to exhibit NO automatic formatting whatsoever.
I’m using Excel under a M365 Home subscription (Version 2408 Build 16.0.17928.20114 64-bit) The Problem:Even in brand new, blank workbooks, whenever I delete the default cell styles for “Hyperlink” and “Followed Hyperlink,” these cell styles will reappear and apply themselves on their own the next time a hyperlink is created or followed in the workbook. This occurs whether the hyperlink is created via VBA, cell formula, or the “insert hyperlink” wizard/dialogue. What I’ve Tried:1. I have turned off the “AutoFormat As You Type” option to automatically replace “Internet and Network paths with hyperlinks;” the problem persists2. I have deleted all cell styles (other than the “normal” cell style, which cannot be deleted) in the active workbook and my PERSONAL.xlsb workbook; the problem persists3. I have used VBA to delete the cell styles (as compared to just right clicking the cell style and selecting “delete”); the problem persists The Question:Any idea how to prevent Excel from automatically re-adding the “Hyperlink” and “Followed Hyperlink” cell styles after they’ve been deleted? I want hyperlinks to exhibit NO automatic formatting whatsoever. Read More
Microsoft Defender It seriously affected my app launch
My application was written using WPF and published as a standalone project. When my application was launched, Microsoft Defender scanned over 170 files, which caused a delay of up to 9s in my application launch time. I don’t know how to optimize it. Is there anyone who can help me?My process name is op.exe
The fast startup case can only respond quickly in less time if the cache is still available, but this cache is often released and I can’t seem to control it
Here are the logs captured using the Defender Performance Analyzer
My application was written using WPF and published as a standalone project. When my application was launched, Microsoft Defender scanned over 170 files, which caused a delay of up to 9s in my application launch time. I don’t know how to optimize it. Is there anyone who can help me?My process name is op.exe The fast startup case can only respond quickly in less time if the cache is still available, but this cache is often released and I can’t seem to control it Here are the logs captured using the Defender Performance Analyzerhttps://internal-api-drive-stream.feishu.cn/space/api/box/stream/download/all/TtZOb49AEoHJXuxrRqTc9k6Jn0c/?mount_node_token=FI9yddhrTokZthxKYg3cnkgjnaf&mount_point=docx_file Read More
Trying to use a spill range as a reference for FILTER that uses INDEX
Hi all! 👋😊
I am trying to find a solution that will let me use the values in a spill range to query a table and return related values from another column. I attempted to do this using this formula: FILTER(INDEX(Table1,,7),INDEX(Table1,,9)=$F3#,””) – where $F3# is the spill range, its values are in column 9 of Table1 and the required value is in column 7 of the same table. The formula results in an error and I was unable to resolve it to a working state.
Instead, I went for a clunky but simple query that references a bunch of rows where the spill will occur. It fetches the values that I need but is not dynamic… ideally the solution would expand and contract with the spill range. I’m sure it’s possible, but just beyond the reach of my current skill set or knowledge so created a sample workbook with dummy data, hoping it might help someone suggest a more elegant solution 🤞
Thanks in advance, Andy!
Hi all! 👋😊 I am trying to find a solution that will let me use the values in a spill range to query a table and return related values from another column. I attempted to do this using this formula: FILTER(INDEX(Table1,,7),INDEX(Table1,,9)=$F3#,””) – where $F3# is the spill range, its values are in column 9 of Table1 and the required value is in column 7 of the same table. The formula results in an error and I was unable to resolve it to a working state. Instead, I went for a clunky but simple query that references a bunch of rows where the spill will occur. It fetches the values that I need but is not dynamic… ideally the solution would expand and contract with the spill range. I’m sure it’s possible, but just beyond the reach of my current skill set or knowledge so created a sample workbook with dummy data, hoping it might help someone suggest a more elegant solution 🤞 Thanks in advance, Andy! Read More
How to rotate video view by 90 or 180 degrees before joining a Teams Meeting
Dear all,
We are currently working on an Electron application that integrates Microsoft Teams using Azure Communication Services. We are facing an issue with webcams that are physically installed rotated by 90 or 180 degrees. so we need to rotate the video view before joining a Teams call.
Does anyone know if there’s a video settings API in ACS or another method to rotate the video before we call callAgent.join method in ACS to join a Teams meeting? any code snippets or resources would be greatly appreciated.
Thank you in advance for your help!
Sincerely,
James from Shared Studios
Dear all,We are currently working on an Electron application that integrates Microsoft Teams using Azure Communication Services. We are facing an issue with webcams that are physically installed rotated by 90 or 180 degrees. so we need to rotate the video view before joining a Teams call.Does anyone know if there’s a video settings API in ACS or another method to rotate the video before we call callAgent.join method in ACS to join a Teams meeting? any code snippets or resources would be greatly appreciated.Thank you in advance for your help!Sincerely,James from Shared Studios Read More
Difficulties with inserting a table int oWord
insert a table, click Insert > Table and move the cursor over the grid until you highlight the number of columns and rows you want. This does not work on my computer anymore. Any suggestions? I’m working on a Mac with MS 365 OS Sonoma
insert a table, click Insert > Table and move the cursor over the grid until you highlight the number of columns and rows you want. This does not work on my computer anymore. Any suggestions? I’m working on a Mac with MS 365 OS Sonoma Read More
Excel formula for adding correct exchange rate to correct cell
Hello,
May I ask for help with this please.
I am running a web store, and in columns A-C (marked as 1) you can see parts of the sales report (see screenshot).
In column D, I wish to automatically insert the correct currency exchange rate for the Purchase Date (column B) and for the currency that was used to pay the order (column C).
Columns F-H and J-L (marked as 2 and 3) contains the exchange rates that should be used for Euro and USD.
So to get the correct currency exchange rates into the different rows of column D, the formula needs to:
-check that the order date (column B) is the same as the date in column F or J.
-check that the order currency (column C) is the same as the currency in column G or K.
For example:
-In cell D2, the correct currency exchange rate to be inserted is 10,35498 (from cell L10), because the order date (column B) is 2024-09-11 and the currency (column C) is USD.
Thank you!
Hello, May I ask for help with this please. I am running a web store, and in columns A-C (marked as 1) you can see parts of the sales report (see screenshot). In column D, I wish to automatically insert the correct currency exchange rate for the Purchase Date (column B) and for the currency that was used to pay the order (column C). Columns F-H and J-L (marked as 2 and 3) contains the exchange rates that should be used for Euro and USD. So to get the correct currency exchange rates into the different rows of column D, the formula needs to:-check that the order date (column B) is the same as the date in column F or J.-check that the order currency (column C) is the same as the currency in column G or K. For example:-In cell D2, the correct currency exchange rate to be inserted is 10,35498 (from cell L10), because the order date (column B) is 2024-09-11 and the currency (column C) is USD. Thank you! Read More
How do I find my windows 11 product key?
I recently needed to find my Windows 11 product key because I wanted to reinstall the system, but I didn’t know where to find Windows 11 product key. I’ve seen some tutorials before, but the operation was a bit complicated and I didn’t know the specific steps. Does anyone have any simple methods or tools that can help me quickly find the Windows 11 product key? If anyone has encountered a similar problem, please share your experience, thank you!
I recently needed to find my Windows 11 product key because I wanted to reinstall the system, but I didn’t know where to find Windows 11 product key. I’ve seen some tutorials before, but the operation was a bit complicated and I didn’t know the specific steps. Does anyone have any simple methods or tools that can help me quickly find the Windows 11 product key? If anyone has encountered a similar problem, please share your experience, thank you! Read More
Is a complete wipe really necessary?
Insider build expiring very soon, but updates constantly fail to install, is a complete wipe really necessary?
Insider build expiring very soon, but updates constantly fail to install, is a complete wipe really necessary? Read More
I can’t exit Windows Insider Program
What should i do if I can’t exit Windows Insider Program?
What should i do if I can’t exit Windows Insider Program? Read More
Edge browser takes 400MB RAM with only one tab opening!
Is this a normal? I can’t believe the fact but the task manager will not lie as you can see from the screenshot. Why this happens?
Is this a normal? I can’t believe the fact but the task manager will not lie as you can see from the screenshot. Why this happens? Read More
Can anyone recommend a safe Spotif.y music Downloader for my PC Windows 11?
I’m looking for a safe Spotif.y music downloader recently. I want to download my favorite songs to MP3 format and put them on my Windows 11 computer. I’ve tried some online tools, but they don’t seem very reliable, and some are full of ads. So I want to ask everyone, have you used a safe and simple Spotif.y music downloader? Can you recommend one? I hope the operation is not too complicated and can download songs on S.potify stably.
I’m looking for a safe Spotif.y music downloader recently. I want to download my favorite songs to MP3 format and put them on my Windows 11 computer. I’ve tried some online tools, but they don’t seem very reliable, and some are full of ads. So I want to ask everyone, have you used a safe and simple Spotif.y music downloader? Can you recommend one? I hope the operation is not too complicated and can download songs on S.potify stably. Read More
Switched of electricity, now PC won’t start.
Had to turn of the electricity to disconnect some plug sockets for painting. Turned electricity back on but now the pc shows this:
Had to turn of the electricity to disconnect some plug sockets for painting. Turned electricity back on but now the pc shows this: Read More
Microsoft office outlook cannot connect to onprem exchange server
Hi,
In my company, we are using on-prem Exchange 2019 for the mail server and we published our main website on the same domain as the primary email address. For instance, email address removed for privacy reasons is our email address format and our website address is example.com. Everything was working fine until we developed our website, after that from the internet whenever I tried to add an account to Microsoft Office Outlook I kept receiving “Something went wrong and Outlook couldn’t set up your account”. After so much effort and searching I’ve found out the reason is that Outlook sends a query to example.com which is my primary domain and the new website sends some response that causes the error and when I removed the DNS record from the internet everything went back to normal.
Now I do not know how to resolve this issue so I can have my website while outlook works correctly.
Please help me
Hi,In my company, we are using on-prem Exchange 2019 for the mail server and we published our main website on the same domain as the primary email address. For instance, email address removed for privacy reasons is our email address format and our website address is example.com. Everything was working fine until we developed our website, after that from the internet whenever I tried to add an account to Microsoft Office Outlook I kept receiving “Something went wrong and Outlook couldn’t set up your account”. After so much effort and searching I’ve found out the reason is that Outlook sends a query to example.com which is my primary domain and the new website sends some response that causes the error and when I removed the DNS record from the internet everything went back to normal.Now I do not know how to resolve this issue so I can have my website while outlook works correctly.Please help me Read More
Onedrive – why multiple folders in Explorer
OK I know many folks don’t like OneDrive, but I have 2 PC’s and a laptop, and I want files and emails to be available on either device.
Now that I found out how to stop my desktop being copied between the units that all have different display size and resolution, OneDrive basically lets me do that.
However, it presents an annoying feature whereby there are 2 different branches with folders on my primary PC.
There is a one drive folder – in John -Personal and John Chapman, the problem is I then see multiple downloads, document, picture folders etc, which confuses me.
How do I simplify this – I create Word, Excel and PowerPoint files and use outlook for 2 email addresses – those are the files I want available on either of the 3 devices I use.
Is this duplication or just a view selection that I don’t know how to control?
Did I describe my problem clearly? It’s hard to show full detail without showing more folder content.
Thanks.
OK I know many folks don’t like OneDrive, but I have 2 PC’s and a laptop, and I want files and emails to be available on either device. Now that I found out how to stop my desktop being copied between the units that all have different display size and resolution, OneDrive basically lets me do that.However, it presents an annoying feature whereby there are 2 different branches with folders on my primary PC. There is a one drive folder – in John -Personal and John Chapman, the problem is I then see multiple downloads, document, picture folders etc, which confuses me.How do I simplify this – I create Word, Excel and PowerPoint files and use outlook for 2 email addresses – those are the files I want available on either of the 3 devices I use.Is this duplication or just a view selection that I don’t know how to control? Did I describe my problem clearly? It’s hard to show full detail without showing more folder content.Thanks. Read More
Snipping tool is absolutely under rated
It’s really good, I use it all the time!!! Do you agree with me?
It’s really good, I use it all the time!!! Do you agree with me? Read More
What’s the safest X T-witter video downloader for Windows 11 PC?
I am an elementary school teacher. I have been looking for some educational videos on T-witter recently. I want to download them for my children to watch in class. But the problem I have is that I don’t know what tool can be used to download these videos safely. I use Windows 11 and have tried some download tools, but many of them have annoying ads and even make me worry about security risks. I need a safe, stable and easy-to-use tool that can help me download X T.witter videos quickly.
Does anyone have any good recommendations? I just want to find a convenient and safe way. After all, it is content for children to watch, and safety is the most important thing!
I am an elementary school teacher. I have been looking for some educational videos on T-witter recently. I want to download them for my children to watch in class. But the problem I have is that I don’t know what tool can be used to download these videos safely. I use Windows 11 and have tried some download tools, but many of them have annoying ads and even make me worry about security risks. I need a safe, stable and easy-to-use tool that can help me download X T.witter videos quickly. Does anyone have any good recommendations? I just want to find a convenient and safe way. After all, it is content for children to watch, and safety is the most important thing! Read More
MSIX issue while uploading in Microsoft partner
Hi Gérard ,
Thank you for your response. We are facing two issues while uploading the MSIX app to the Microsoft Store:
1. If I create the MSIX using the publisher ID provided in the “Product Identity” created by the Microsoft Partner Center, the upload process is successful. However, the MSIX fails to install or launch, showing a publisher and certificate-related issue.
2. If I create the MSIX using our company’s publisher details, the MSIX installs and launches successfully. However, it does not upload to the Apps and Games section, displaying a publisher and certificate-related issue.
Could you please assist with resolving these issues?
Best Regards,
Avinash Kumar Paswan
Software Development
(+91)7905134594
Hi Gérard , Thank you for your response. We are facing two issues while uploading the MSIX app to the Microsoft Store: 1. If I create the MSIX using the publisher ID provided in the “Product Identity” created by the Microsoft Partner Center, the upload process is successful. However, the MSIX fails to install or launch, showing a publisher and certificate-related issue. 2. If I create the MSIX using our company’s publisher details, the MSIX installs and launches successfully. However, it does not upload to the Apps and Games section, displaying a publisher and certificate-related issue. Could you please assist with resolving these issues?Best Regards, Avinash Kumar Paswan Software Development (+91)7905134594 Read More
Some keyboard shortcuts not working on iPadOS
Previously I created a thread on this on Azure Virtual Desktop Feedback and I was recommended to put it here.
I’m using the official Remote Desktop client from the App Store to connect to a windows 10 PC.
When using an external keyboard, most keyboard but some can work. Shortcuts not working include Alt+F4, Ctrl+/ (though Ctrl+A, Ctrl+S works), Ctrl+F5, to name a few.
Can replicate with multiple iPads, PCs and external keyboards.
Previously I created a thread on this on Azure Virtual Desktop Feedback and I was recommended to put it here. I’m using the official Remote Desktop client from the App Store to connect to a windows 10 PC.When using an external keyboard, most keyboard but some can work. Shortcuts not working include Alt+F4, Ctrl+/ (though Ctrl+A, Ctrl+S works), Ctrl+F5, to name a few.Can replicate with multiple iPads, PCs and external keyboards. Read More
