Category: Microsoft
Category Archives: Microsoft
COUNTIF
Hi,
I am using tge COUNTIF function to count cells in a range with a ‘tick’ symbol. I would like to show the result as the cells counted is % of total cells in the range. Could someone please assist with the relevant syntax?
Thankyou
Hi,I am using tge COUNTIF function to count cells in a range with a ‘tick’ symbol. I would like to show the result as the cells counted is % of total cells in the range. Could someone please assist with the relevant syntax?Thankyou Read More
Spreadsheet can not be insert or delete or clear content
I have a daily updated spreadsheet recent found can not do insert row or column, can not delete cell and clear content, and can not do auto calculate, all these without pop up a prompt, just no reaction, but if copy and paste the formula then press enter the calculation still work, these are really bothers me. I am sure this spreadsheet is not locked or with maximum rows or columns
I have a daily updated spreadsheet recent found can not do insert row or column, can not delete cell and clear content, and can not do auto calculate, all these without pop up a prompt, just no reaction, but if copy and paste the formula then press enter the calculation still work, these are really bothers me. I am sure this spreadsheet is not locked or with maximum rows or columns Read More
Dev Channel update to 127.0.2651.8 is live.
Hello Insiders! We released 127.0.2651.8 to the Dev channel! Mac also released with a version bump 128.0.2650.0!
The release includes numerous fixes. For more details on the changes, check out the highlights below.
An even faster Microsoft Edge – Microsoft Edge Blog (windows.com)
Added Features:
Introduced a ‘Learn More’ feature within the translation settings toggle.
Improved Reliability:
Fixed an issue causing a crash when a local tab group was deleted.
Resolved an issue that caused the browser to crash when the Fullscreen button was clicked on a YouTube video.
Fixed an issue that caused the browser to crash when submitting feedback.
Changed Behavior:
Resolved an issue where restarting the browser caused grouped tabs to be displayed as URLs instead of their respective tab names.
Resolved an issue that caused a workspace to open with all tab groups unfolded, despite being closed in the previous session.
Resolved an issue to ensure the expanded or collapsed state of a tab group is saved within a workspace.
Fixed an issue where changing the tab orientation would leave the menu open but remove the active state from the Tab action menu button.
Fixed an issue where the tab key did not allow for the selection of an item or folder downwards in the favorites hub.
Mac: The problem where hovering over the Copilot icon caused all app icons to become unresponsive has been fixed on mac.
iOS:
Resolved an issue where the user interface for the search results displayed through the search function was inaccurate on iOS.
Resolved an issue resulting in the Read Aloud toolbar not displaying all its content fully on iOS.
Android:
The issue of a toolbar appearing on the New Tab Page (NTP) on Android has been resolved.
The issue where two translation columns appeared after using the ‘Find on page’ feature following a translation has been resolved.
See an issue that you think might be a bug? Remember to send that directly through the in-app feedback by heading to the … menu > Help and feedback > Send feedback and include diagnostics so the team can investigate.
Thanks again for sending us feedback and helping us improve our Insider builds.
~Gouri
Hello Insiders! We released 127.0.2651.8 to the Dev channel! Mac also released with a version bump 128.0.2650.0!
The release includes numerous fixes. For more details on the changes, check out the highlights below.
An even faster Microsoft Edge – Microsoft Edge Blog (windows.com)
Added Features:
Introduced a ‘Learn More’ feature within the translation settings toggle.
Improved Reliability:
Fixed an issue causing a crash when a local tab group was deleted.
Resolved an issue that caused the browser to crash when the Fullscreen button was clicked on a YouTube video.
Fixed an issue that caused the browser to crash when submitting feedback.
Changed Behavior:
Resolved an issue where restarting the browser caused grouped tabs to be displayed as URLs instead of their respective tab names.
Resolved an issue that caused a workspace to open with all tab groups unfolded, despite being closed in the previous session.
Resolved an issue to ensure the expanded or collapsed state of a tab group is saved within a workspace.
Fixed an issue where changing the tab orientation would leave the menu open but remove the active state from the Tab action menu button.
Fixed an issue where the tab key did not allow for the selection of an item or folder downwards in the favorites hub.
Mac: The problem where hovering over the Copilot icon caused all app icons to become unresponsive has been fixed on mac.
iOS:
Resolved an issue where the user interface for the search results displayed through the search function was inaccurate on iOS.
Resolved an issue resulting in the Read Aloud toolbar not displaying all its content fully on iOS.
Android:
The issue of a toolbar appearing on the New Tab Page (NTP) on Android has been resolved.
The issue where two translation columns appeared after using the ‘Find on page’ feature following a translation has been resolved.
See an issue that you think might be a bug? Remember to send that directly through the in-app feedback by heading to the … menu > Help and feedback > Send feedback and include diagnostics so the team can investigate.
Thanks again for sending us feedback and helping us improve our Insider builds.
~Gouri Read More
Não consigo resgatar recompensas.
Não estou conseguindo resgatar no Microsoft Rewards, aparece uma mensagem quando vou fazer o resgate para adicionar um número de telefone e sou redirecionado para os Alias da conta. Lá eu coloco meu número corretamente porém recebo uma mensagem que diz “Tente outro método de verificação” e embaixo diz “Esse método de verificação não está funcionando no momento. Tente outro método” mas ja está assim desde abril desse ano!
Não estou conseguindo resgatar no Microsoft Rewards, aparece uma mensagem quando vou fazer o resgate para adicionar um número de telefone e sou redirecionado para os Alias da conta. Lá eu coloco meu número corretamente porém recebo uma mensagem que diz “Tente outro método de verificação” e embaixo diz “Esse método de verificação não está funcionando no momento. Tente outro método” mas ja está assim desde abril desse ano! Read More
How to track when status change?
Hello,
I have a column set to display “New” when a new request comes in. Another user will then update the status to either “Pending,” “Cancelled,” or “Confirmed.” I want to track how long it takes for the status to change ex. from “New” to “Confirmed.” The goal is generate a report for auditing purpose.
Thank you!!
Hello, I would like to know if there is a way to track when a status is changed on SharePoint. For example:I have a column set to display “New” when a new request comes in. Another user will then update the status to either “Pending,” “Cancelled,” or “Confirmed.” I want to track how long it takes for the status to change ex. from “New” to “Confirmed.” The goal is generate a report for auditing purpose. Thank you!! Read More
OneDrive app bug
There are bugs in OneDrive Mac App (24.111.0602). The first bug is I cannot scroll the files sync on OneDrive App located at the status bar (upper right hand corner). The second bug is when I click the preference icon nothing happens.
There are bugs in OneDrive Mac App (24.111.0602). The first bug is I cannot scroll the files sync on OneDrive App located at the status bar (upper right hand corner). The second bug is when I click the preference icon nothing happens. Read More
Internal Emails Being Quarantined?
Hi everyone,
One client org has internal emails being caught in the Microsoft Defender Quarantine on O365. They also have external emails being caught there and it seems that these days we cannot even whitelist email addresses any longer, we have to submit them to Microsoft so Microsoft can EVENTUALLY improve the filter?
Client is going crazy as many important vendor emails are getting caught and they just want to change from Microsoft somewhere else which I’m trying to not recommend.
It does suck, understandably to have your email domain hosted on O365 for a dozen+ years and to have the Spam filter act as if it’s brand new sometimes on a yearly basis however. It’s very inconvenient for productivity reasons as lots of false-positives start happening over and over as if the filter is brand new now and then.
I have tried to set the quarantine to “send an email daily” to user so they can handle their own quarantine, that hasn’t worked, no email arrives. So I have given the users the link to login to their quarnatine to try to release/report false-positive’s to Microsoft meanwhile.
Any suggestions to improve this?
Thanks.
Hi everyone, One client org has internal emails being caught in the Microsoft Defender Quarantine on O365. They also have external emails being caught there and it seems that these days we cannot even whitelist email addresses any longer, we have to submit them to Microsoft so Microsoft can EVENTUALLY improve the filter? Client is going crazy as many important vendor emails are getting caught and they just want to change from Microsoft somewhere else which I’m trying to not recommend. It does suck, understandably to have your email domain hosted on O365 for a dozen+ years and to have the Spam filter act as if it’s brand new sometimes on a yearly basis however. It’s very inconvenient for productivity reasons as lots of false-positives start happening over and over as if the filter is brand new now and then. I have tried to set the quarantine to “send an email daily” to user so they can handle their own quarantine, that hasn’t worked, no email arrives. So I have given the users the link to login to their quarnatine to try to release/report false-positive’s to Microsoft meanwhile. Any suggestions to improve this? Thanks. Read More
Create a shared mailbox for unlicensed global admin user
Hi,
I have created an unlicensed user to be a global admin because paying for a license would be a waste of money since it is meant to manage only. However, I noticed that Microsoft frequently sends communications to this user (e.g., billing emails, or if I submit a tech support ticket, etc.). Therefore, I decided that this user needs a corresponding mailbox to receive all these emails, and then delegate access to this inbox to appropriate users.
Unfortunately, this process has turned out to be quite challenging. I can create a new shared mailbox, which creates an unlicensed user, but it is not allowing me to change or reassign the names and put the two together. The new Exchange admin center is not letting me create a mailbox there, and when I try modifying the SMTP address, it gives an error related to Azure Directory and does not change anything.
I hope someone can help me accomplish adding a shared mailbox to an existing unlicensed user.
Thank you.
Hi, I have created an unlicensed user to be a global admin because paying for a license would be a waste of money since it is meant to manage only. However, I noticed that Microsoft frequently sends communications to this user (e.g., billing emails, or if I submit a tech support ticket, etc.). Therefore, I decided that this user needs a corresponding mailbox to receive all these emails, and then delegate access to this inbox to appropriate users. Unfortunately, this process has turned out to be quite challenging. I can create a new shared mailbox, which creates an unlicensed user, but it is not allowing me to change or reassign the names and put the two together. The new Exchange admin center is not letting me create a mailbox there, and when I try modifying the SMTP address, it gives an error related to Azure Directory and does not change anything. I hope someone can help me accomplish adding a shared mailbox to an existing unlicensed user. Thank you. Read More
Is Microsoft trying to get people scammed? New Outlook is insideous.
The new outlook was forced on me a couple of days ago. I’ve got some decent gripes with it but the biggest issue I have is it seems to be funneling less astute users to getting scammed.
The first issue is the ads. Each account has an AD at the top of the list of messages that could easily be mistaken as an email. I originally felt I was okay ignoring them – it’s just part of the deal. But, the ad I saw and clicked on today was 100% a scam site and preys on people that are susceptible to fraudulent endorsements of famous people. In this case it was Trudeau (Canadian Prime Minister) endorsing a way to get thousands of tax dollars back. It is the same template I’ve seen with other notable names (Bill Gates, Warren Buffet, Elon Musk, etc…). Here is the link for those who may be sceptical. It is 100% bs: https://profgenpro.click/landers/pensupca_zeno/?domain=cdn.dripvoice.com&clickid=003f4wha8hevrdc1&uclick=wha8q5vr&uclickhash=wha8q5vr-wha8hevr-g63y-0-ciq5-b7xo-b78p-bcbb7c
Secondly, hovering over hyperlinks in the new outlook doesn’t display the actual URL anymore. It is the #1 thing I ALWAYS do when I see an email mentioning a bank transaction, package delivery, or anything that might seem relevant.
What on earth are these people thinking!
The new outlook was forced on me a couple of days ago. I’ve got some decent gripes with it but the biggest issue I have is it seems to be funneling less astute users to getting scammed.The first issue is the ads. Each account has an AD at the top of the list of messages that could easily be mistaken as an email. I originally felt I was okay ignoring them – it’s just part of the deal. But, the ad I saw and clicked on today was 100% a scam site and preys on people that are susceptible to fraudulent endorsements of famous people. In this case it was Trudeau (Canadian Prime Minister) endorsing a way to get thousands of tax dollars back. It is the same template I’ve seen with other notable names (Bill Gates, Warren Buffet, Elon Musk, etc…). Here is the link for those who may be sceptical. It is 100% bs: https://profgenpro.click/landers/pensupca_zeno/?domain=cdn.dripvoice.com&clickid=003f4wha8hevrdc1&uclick=wha8q5vr&uclickhash=wha8q5vr-wha8hevr-g63y-0-ciq5-b7xo-b78p-bcbb7cSecondly, hovering over hyperlinks in the new outlook doesn’t display the actual URL anymore. It is the #1 thing I ALWAYS do when I see an email mentioning a bank transaction, package delivery, or anything that might seem relevant. What on earth are these people thinking! Read More
How to produce a value for every nth value
I am trying to create a schedule for going to the gym. I go to the gym every day except Monday. So Tuesday I would do chest, Wednesday Arms, Thursday Legs and then it resets with chest on Friday, arms on Saturday. I have a list a dates scheduled out for 3 months starting from 6/21/24. How do I dynamically make it so every time the date is Tuesday-Sunday, it will automatically reset to chest or arms or legs in order while skipping Mondays for the next two months.
I am trying to create a schedule for going to the gym. I go to the gym every day except Monday. So Tuesday I would do chest, Wednesday Arms, Thursday Legs and then it resets with chest on Friday, arms on Saturday. I have a list a dates scheduled out for 3 months starting from 6/21/24. How do I dynamically make it so every time the date is Tuesday-Sunday, it will automatically reset to chest or arms or legs in order while skipping Mondays for the next two months. Read More
Unable to receive email from the rooms /Resources.
Hello
Please i need your help on this issue.
We are Unable to receive email from the teams rooms /Resources.
Hello Please i need your help on this issue. We are Unable to receive email from the teams rooms /Resources. Read More
Use budget management and forecasting to bring your FinOps practice into the era of AI
Microsoft Tech Community – Latest Blogs –Read More
Version of chat gpt used in Word 2016
The rest of my team is asking me what version of Chat gpt is used in Word MSO Version 2406 Build 16. I’m assuming V 4.
Thanks!
The rest of my team is asking me what version of Chat gpt is used in Word MSO Version 2406 Build 16. I’m assuming V 4.Thanks! Read More
External Data Sharing With Microsoft Fabric
Organizations leveraging Microsoft Fabric can now use the external data sharing feature to allow users from another Microsoft Fabric tenant access their data. The data stays in the provider’s OneLake storage location and no data is moved. Instead, this cross-tenant sharing creates a link, called a OneLake shortcut, and the recipient of the share tenant creates a pointer back to the provider tenant. Users in the recipient tenant are provided a read only access to the data. The data is shared across tenant boundaries, and the recipient can use it with any OneLake compatible Fabric workload in their own tenant. What makes external sharing solution so seamless and frictionless is the fact that the adoption of PowerBI already has massive adoption in terms of the number of organizations and the millions of users who leverage it daily. The key becomes, organizations don’t need to do anything different nor stand up any new products and solutions; organizations and users can simply continue to use what they have been using and take advantage of this new feature.
External data sharing is currently supported for data residing in tables or files within:
Lakehouses
KQL databases
We wanted to provide some high level step by step guidance to demonstrate how easy it was to setup the external sharing:
Step 1 Enable External Tenant Sharing:
1. Enable external data sharing in the provider tenant
Go to the tenant settings in the providing tenant.
Find the External data sharing (preview) tenant setting (under export and sharing settings), enable the toggle, and specify who in the tenant can create external data shares.
Decide if you want to enable this capability for everyone or limit to certain security groups.
Step 2 Create an external data share:
In a workspace or in the OneLake data hub, find the Fabric item that contains the data you want to share.
Open the context menu of the selected item and choose External data share (preview).
In the New external data share dialog that opens, choose the folder or table to be shared and select Save and continue.
Enter the email address of the user you want to share the data with and select Send. An email will be sent to the user inviting them to accept the invitation to share. Alternatively, you can select Copy link and then paste it into an email that you yourself compose.
Note – it is just as easy to revoke the share – under manage permissions:
Step 3 Allow/accept external data share in recipient tenant:
Go to the tenant settings in the recipient tenant.
Find the Users can accept external data shares (preview) tenant setting (under export and sharing settings), enable the toggle, and specify who in the tenant can create external data shares.
Decide if you want to enable this capability for everyone or limit to certain security groups
Accept an external data share:
Go to the link received via email and click on Get Started.
2. A dialog similar to one below appears that displays the name of the share and the details of the data provider’s tenant.
3. Select Accept and select a location. This opens the OneLake data hub. Select a lakehouse.
4. Select Next, select the table or folder location in which to create the incoming share shortcut, and then select Apply.
Observations:
The external data share shows up as a shortcut with the name starting with a “External_”.
The external data share gives a read-only version of data that can be accessed through all the Fabric experiences. For the spark notebook experience, users can choose from multiple languages or the low code/no code data wrangler experience to transform and prepare the data. In the example below, the table “store” is combined with the external shortcut “EXTERNAL_storeprofile”, which provides the store profile data, to get a complete view of the store features. The result is then saved to a new table, “storewprofile”. This new table can be accessed through the SQL Analytics Endpoint, Fabric Data Factory, or PBI experiences.
Here is an example of the SQL Analytics endpoint on the “External_” share:
3. The external share can be viewed through the lineage view of the workspace.
Key Takeaways
The external data share is a very powerful feature and so we hope you take away the following from the content we have shared:
Ease of creating and revoking a share.
Simplicity of accepting a share as the recipient.
Fabric Ecosystem & Non-Fabric Use Cases – although we have demonstrated a very Fabric centric article, non-fabric users can still benefit from this solution. For instance, if you are a Tableau user, you can connect to the XMLA endpoint of a semantic model or the SQL endpoint of Fabric via the necessary drivers. Given this, the solution only becomes even more compelling as it can handle both Fabric centric and non Fabric centric scenarios.
Microsoft Tech Community – Latest Blogs –Read More
Autofill dates while skipping cells (without formatting)
Hi everyone, new (ish) to Microsoft Excel and I’m having some trouble with the Autofill tool. I have an old schedule that I’d like to update the dates on, without having to manually input each date. I read online that you could autofill while skipping certain cells by pressing ctrl (cmd for me bc ios), but when I do that, the shortcut Autofill icon disappears. When I search for Autofill, I can’t find the option of Fill w/o Formatting. I can always go back and individually correct each cell color and date, but I’m sure there has to be some ways to cut down on time, I just don’t know where to look. The dates in the photo were the ones I tried messing around with, but as you can see I’m unable to keep the original cell colors.
Hi everyone, new (ish) to Microsoft Excel and I’m having some trouble with the Autofill tool. I have an old schedule that I’d like to update the dates on, without having to manually input each date. I read online that you could autofill while skipping certain cells by pressing ctrl (cmd for me bc ios), but when I do that, the shortcut Autofill icon disappears. When I search for Autofill, I can’t find the option of Fill w/o Formatting. I can always go back and individually correct each cell color and date, but I’m sure there has to be some ways to cut down on time, I just don’t know where to look. The dates in the photo were the ones I tried messing around with, but as you can see I’m unable to keep the original cell colors. Read More
Macros & VBA:
Hello,
I have never used macros before. How do I use VBA to move the data from column C to B? I tried recording macros but got stuck with coding (I have never coded).
Attached is a picture of my task. Thanks! The data is not real, FYI.
Hello,I have never used macros before. How do I use VBA to move the data from column C to B? I tried recording macros but got stuck with coding (I have never coded).Attached is a picture of my task. Thanks! The data is not real, FYI. Read More
Can I re-establish a connection between a Form and a linked Excel spreadsheet
We have an MS Form through O365 which is linked to an Excel sheet in Sharepoint. Each form entry has been automatically added to the next row of the Excel.
It appears that some manual modifications within the Excel have caused the connection between the Excel and the Form to be broken. New entries are not auto-populating in the Excel.
Can anyone provide a way to reconnect the form to the existing spreadsheet that has been receiving form submissions? I know I can link a new Excel, but we have years of data in the old one, and really want to re-establish the broken connection.
Help!
We have an MS Form through O365 which is linked to an Excel sheet in Sharepoint. Each form entry has been automatically added to the next row of the Excel.It appears that some manual modifications within the Excel have caused the connection between the Excel and the Form to be broken. New entries are not auto-populating in the Excel. Can anyone provide a way to reconnect the form to the existing spreadsheet that has been receiving form submissions? I know I can link a new Excel, but we have years of data in the old one, and really want to re-establish the broken connection.Help! Read More
Azure Administrator Career Path – wrong certification?
Hello,
I have a quick question about the Administrator Career Path/Plan at https://learn.microsoft.com/en-us/plans/50nrtozg28d354 – the modules are all for AZ-104, however the certification in milestone 2 is a MS-365 certification. Could you please update the path/plan to include the AZ-104 instead as that seems to be more aligned with the overall path?
Hello, I have a quick question about the Administrator Career Path/Plan at https://learn.microsoft.com/en-us/plans/50nrtozg28d354 – the modules are all for AZ-104, however the certification in milestone 2 is a MS-365 certification. Could you please update the path/plan to include the AZ-104 instead as that seems to be more aligned with the overall path? Read More
Excel formula cells without =, but want to make a formula of it
Hello,
Hopefully somebody can help me.
I want to make a formula that solves a formula in a cell without a = sign.
Example:
Cell A1 = 2+4+6+12
Cell A2 = Answer of cell A1
What formula do i need in cell A2 to do this?
I have looked for 2 hours and can’t find how to do it.
Hello, Hopefully somebody can help me. I want to make a formula that solves a formula in a cell without a = sign. Example:Cell A1 = 2+4+6+12Cell A2 = Answer of cell A1 What formula do i need in cell A2 to do this? I have looked for 2 hours and can’t find how to do it. Read More
Create library from Existing library – Item vs Document Parent Content Type
Using the option to create from an existing library that has an Enterprise Content Type applied is producing a library with both Document and the desired Enterprise Content Type. To avoid confusion, we delete the “Document” CT leaving just our Enterprise CT. This is now mapped incorrectly to a parent of “Item” vs “Document” or the “Enterprise CT”. I suspect it has something to do with the way CTs are pushed onDemand to new sites. If we delete our CT first leaving “Document” CT and then re-add our CT then we have the desired results. Frustrating workaround …
Using the option to create from an existing library that has an Enterprise Content Type applied is producing a library with both Document and the desired Enterprise Content Type. To avoid confusion, we delete the “Document” CT leaving just our Enterprise CT. This is now mapped incorrectly to a parent of “Item” vs “Document” or the “Enterprise CT”. I suspect it has something to do with the way CTs are pushed onDemand to new sites. If we delete our CT first leaving “Document” CT and then re-add our CT then we have the desired results. Frustrating workaround … Read More