Tag Archives: microsoft
SharePoint list threshold limit
Hi
We run an access database connected to SharePoint online lists. One of the lists has 16000 items and I need to add an additional field (type lookup) but when trying to add this get an error saying “the attempted operation is prohibited because it exceeds the list view threshold”
I can’t seem to find a way to increase the 5000 threshold limit to get around this. Is the only option to removed items to get the limit under 5000 to then be able to add a field?
(we can’t create a new list and copy the data in as the autonumber ID from the existing list is used in the database)
Any suggestions would be appreciated!
Hi We run an access database connected to SharePoint online lists. One of the lists has 16000 items and I need to add an additional field (type lookup) but when trying to add this get an error saying “the attempted operation is prohibited because it exceeds the list view threshold”I can’t seem to find a way to increase the 5000 threshold limit to get around this. Is the only option to removed items to get the limit under 5000 to then be able to add a field? (we can’t create a new list and copy the data in as the autonumber ID from the existing list is used in the database)Any suggestions would be appreciated! Read More
Top Stories: June 11, 2024
Check it out!
English Top Stories: June 11, 2024 | Microsoft
Français À la une : 10 juin 2024 | Microsoft
Español Novedades más relevantes: 11 de junio de 2024 | Microsoft
Português Notícias principais: 11 de junho de 2024 | Microsoft
Check it out!
English Top Stories: June 11, 2024 | Microsoft
Français À la une : 10 juin 2024 | Microsoft
Español Novedades más relevantes: 11 de junio de 2024 | Microsoft
Português Notícias principais: 11 de junho de 2024 | Microsoft Read More
Safe Links API
Hi all,
I’m confused about the Safe Links feature which is called “Do not rewrite URLs, do checks via SafeLinks API only”.
There are two descriptions which are contradictory to me.
1st:
Do not rewrite URLs, do checks via SafeLinks API only: Select this option to prevent URL wrapping and skip reputation check during mail flow. Safe Links is called exclusively via APIs at the time of URL click by Outlook clients that support it.
(https://learn.microsoft.com/en-us/defender-office-365/safe-links-policies-configure)
2nd:
Do not rewrite URLs, do checks via SafeLinks API only: If this setting is selected (on), no URL wrapping takes place but the URLs are scanned prior to message delivery. In supported versions of Outlook (Windows, Mac, and Outlook on the web), Safe Links is called exclusively via APIs at the time of URL click.
(https://learn.microsoft.com/en-us/defender-office-365/safe-links-about)
So what exactly happens, if I enable the API check only? Are links scanned prior delivery or not?
Thanks
Hi all,I’m confused about the Safe Links feature which is called “Do not rewrite URLs, do checks via SafeLinks API only”. There are two descriptions which are contradictory to me. 1st:Do not rewrite URLs, do checks via SafeLinks API only: Select this option to prevent URL wrapping and skip reputation check during mail flow. Safe Links is called exclusively via APIs at the time of URL click by Outlook clients that support it.(https://learn.microsoft.com/en-us/defender-office-365/safe-links-policies-configure)2nd:Do not rewrite URLs, do checks via SafeLinks API only: If this setting is selected (on), no URL wrapping takes place but the URLs are scanned prior to message delivery. In supported versions of Outlook (Windows, Mac, and Outlook on the web), Safe Links is called exclusively via APIs at the time of URL click.(https://learn.microsoft.com/en-us/defender-office-365/safe-links-about)So what exactly happens, if I enable the API check only? Are links scanned prior delivery or not? Thanks Read More
Date help
Dear Experts,
I have an issue like this, given a Column “A” with the dates, my settings are like this,
Text function to extract is not helping somehow in “B2” to get the Month for each row.
Thanks in Advance,
Br,
Anupam
Dear Experts, I have an issue like this, given a Column “A” with the dates, my settings are like this,Text function to extract is not helping somehow in “B2” to get the Month for each row. Thanks in Advance,Br,Anupam Read More
How to download a SharePoint site template from the new Microsoft Lookbook New UI
Hi all,
Looks like Microsoft Lookbook has a new UI https://adoption.microsoft.com/en-us/sharepoint-look-book. However I don’t see any options/links to their repo to download a site template. The old UI redirects you to https://github.com/SharePoint/sp-dev-provisioning-templates. The new lookbook just shows information about the site template.
Does anyone know how I can download a site template from the new lookbook?
Thank you!
Hi all,Looks like Microsoft Lookbook has a new UI https://adoption.microsoft.com/en-us/sharepoint-look-book. However I don’t see any options/links to their repo to download a site template. The old UI redirects you to https://github.com/SharePoint/sp-dev-provisioning-templates. The new lookbook just shows information about the site template. Does anyone know how I can download a site template from the new lookbook? Thank you! Read More
This is another big change for personal account users!
I wonder if there will be blocked accounts?
“Starting September 16th, Microsoft personal email account users (e.g. Outlook.com, Hotmail.com, Live.com) will need to move to Modern Authentication methods in their email application. These will be necessary for all Outlook users.”
I wonder if there will be blocked accounts?Keeping our Outlook Personal Email Users Safe: Reinforcing Our Commitment to Security – Microsoft Community Hub”Starting September 16th, Microsoft personal email account users (e.g. Outlook.com, Hotmail.com, Live.com) will need to move to Modern Authentication methods in their email application. These will be necessary for all Outlook users.” Read More
Exchange 2010 SP3 Upgrade failing Organization Checks
Hi
I’m working on a project to remove the last Exchange 2003 server from the Exchange 2010 organization, which has now completed.
Next phase is to introduce an Exchange 2016 Server into the existing 2010 org and setup for coexistence prior to migration. The main issue is that I need to upgrade all Exchange 2010 SP1 servers to SP3 to support Exchange 2016 and in production this is failing the Organization checks.
The upgrade worked fine in UAT, which uses the same AD functional level (Windows Server 2008R2) and consists of all Windows Server 2016 DCs, same as production.
Since starting to update production 2010 servers I receive the following message after the Organization checks fail:
I have tried to update to SP2, which was a mission to find the installer as it is ancient (same as Exchange 2010 I know!), but to the same result and have tried everything to resolve the issue but to no avail.
Current Prod
AD Schema version = 87 (Windows Server 2016)
Exchange Schema rangeUpper = 14726
Current UAT
AD Schema version = 87 (Windows Server 2016)
Exchange Schema rangeUpper = 15334
I have read that the solution may be to add a legacy Windows Server 2012 as there is a problem with SP3 updates on Server 2016 DCs, but it worked on these fine in UAT so I’m rather perplexed as to this being the only solution.
Can anyone give me further advice as to what could be attempted next please? – Before we bite the bullet and introduce a legacy 2012 server just to upgrade to Exchange 2010 SP3 and then remove as soon as done, assuming it works!!
Please any suggestions would be greatly received?
Thank you
MB
Hi I’m working on a project to remove the last Exchange 2003 server from the Exchange 2010 organization, which has now completed. Next phase is to introduce an Exchange 2016 Server into the existing 2010 org and setup for coexistence prior to migration. The main issue is that I need to upgrade all Exchange 2010 SP1 servers to SP3 to support Exchange 2016 and in production this is failing the Organization checks. The upgrade worked fine in UAT, which uses the same AD functional level (Windows Server 2008R2) and consists of all Windows Server 2016 DCs, same as production. Since starting to update production 2010 servers I receive the following message after the Organization checks fail: I have tried to update to SP2, which was a mission to find the installer as it is ancient (same as Exchange 2010 I know!), but to the same result and have tried everything to resolve the issue but to no avail. Current ProdAD Schema version = 87 (Windows Server 2016)Exchange Schema rangeUpper = 14726 Current UATAD Schema version = 87 (Windows Server 2016)Exchange Schema rangeUpper = 15334 I have read that the solution may be to add a legacy Windows Server 2012 as there is a problem with SP3 updates on Server 2016 DCs, but it worked on these fine in UAT so I’m rather perplexed as to this being the only solution. Can anyone give me further advice as to what could be attempted next please? – Before we bite the bullet and introduce a legacy 2012 server just to upgrade to Exchange 2010 SP3 and then remove as soon as done, assuming it works!! Please any suggestions would be greatly received? Thank you MB Read More
OneDrive Error -10001 in MacBook Pro M2 Pro with macOS14.5
After install the newest version OneDrive app from Microsoft web.
OneDrive app didn’t start correctly, pop up an error code -10001, I cannot even click any button in the icon tool (Top Right corner), so it’s not possible to Quit OneDrive or get into the setting page in the App.
I try the following ways, but this issue keep happening when the app was starting up.
1. Move the OneDrive application to the trash and download the program again from official OneDrive web (version 24.086.0428.0003)
2. Reboot the MacBook
3. Update the macOS to latest macOS14.5 (2024-06-11)
4. Delete all the file that I can find in Finder App
MacBook Pro 14″ 2023 M2 Pro, from Taiwan Apple Store
—
I try to found solution in Microsoft Community, however the user that have the same error, cannot fix there problems too!
More than 20 users click “I have the same question” under the error-10001 post. No one has respond that their problem were solved. I believe this error happens currently for more than one year.
1. FreyaVandenBroeck with MacBook Air MacOS 14.5 (23F79) on 01 Jun 2024
https://techcommunity.microsoft.com/t5/onedrive/onedrive-on-mac/m-p/4157541
2. Benjamin Wang1 with MacBook Pro 2019 Intel i9 MacOS 13.4. on 02 Jul 2023
After install the newest version OneDrive app from Microsoft web.OneDrive app didn’t start correctly, pop up an error code -10001, I cannot even click any button in the icon tool (Top Right corner), so it’s not possible to Quit OneDrive or get into the setting page in the App.I try the following ways, but this issue keep happening when the app was starting up. 1. Move the OneDrive application to the trash and download the program again from official OneDrive web (version 24.086.0428.0003)2. Reboot the MacBook3. Update the macOS to latest macOS14.5 (2024-06-11)4. Delete all the file that I can find in Finder App MacBook Pro 14″ 2023 M2 Pro, from Taiwan Apple Store—I try to found solution in Microsoft Community, however the user that have the same error, cannot fix there problems too!More than 20 users click “I have the same question” under the error-10001 post. No one has respond that their problem were solved. I believe this error happens currently for more than one year. 1. FreyaVandenBroeck with MacBook Air MacOS 14.5 (23F79) on 01 Jun 2024https://techcommunity.microsoft.com/t5/onedrive/onedrive-on-mac/m-p/4157541 2. Benjamin Wang1 with MacBook Pro 2019 Intel i9 MacOS 13.4. on 02 Jul 2023https://answers.microsoft.com/en-us/msoffice/forum/all/onedrive-files-on-demand-didnt-start-error-code/9dbb2cab-e46b-4359-af4c-d12daf987ef7 Read More
Lockscreen text not showing up
Basically, whenever I turn off my pc and turn it back on, the lockscreen appears, but without text.
(I have absolutely no clue what label to use for this)
Basically, whenever I turn off my pc and turn it back on, the lockscreen appears, but without text.(I have absolutely no clue what label to use for this) Read More
Part 6: Introducing Deployment Stacks to Azure Data Factory
Introduction
This is part 6 on our series on Azure Data Factory CI/CD. This section will cover how to incorporate Azure Deployment Stacks into your Azure DevOps Pipelines.
Architecture and Scenario
Creating resources in Azure
Create Azure Storage Containers
Create Azure Key Vaults
Create Azure Data Factory: With Key Vault Access
Configure Azure Data Factory Source Control
Construct Azure Data Factory Data Pipeline
Publishing Concept for Azure Data Factory
Configure Deployed Azure Resources.
The YAML Pipeline Structure
The Publish Process
ARM Template Parameterization
ADF ARM Template Deployment
How to use Azure DevOps Pipeline Templates
How to Deploy Linked Templates for Azure Data Factory
What are Deployment Stacks?
As per MS Learn documentation a Deployment Stack is:
An Azure deployment stack is a resource that enables you to manage a group of Azure resources as a single, cohesive unit. When you submit a Bicep file or an ARM JSON template to a deployment stack, it defines the resources that the stack manage. If a resource previously included in the template is removed, it will either be detached or deleted based on the specified actionOnUnmanage behavior of the deployment stack. Access to the deployment stack can be restricted using Azure role-based access control (Azure RBAC), similar to other Azure resources.
The TL/DR summary is that deployment stacks are an Azure resource that tracks what has been deployed as part of an ARM deployment. This will allow us to destroy resources that are no longer part of the deployment.
How Does This Impact Data Factory?
When are editing and building pipelines in our Data Factory there is often the need to remove old Datasets, Linked Services, and/or Pipelines. If you are familiar with the ADF deployment process, then you are aware that we are deploying ARM templates in incremental mode.
This means that anything we remove from the Data Factory such as a Linked Services will still be out in the Data Factory’s upper environments which we shouldn’t have portal access to. This is a concern as it can be seen as a security threat as it violates Least Privilege Access principles as the Data Factory could have resources it no longer needs access to, specifically if leveraging things like connection strings. Additionally, there is a risk that pipelines that are no longer maintained could be triggered on accident in upper environments.
Thus, if we had a way to remove resources which are no longer defined in our collaboration branch we should!
How to Implement?
So, Deployment Stacks may sound great? However, how hard are they to update in our pipelines? Well, if you’ve been following to this point and leveraging YAML Templates, not hard at all! If your pipelines aren’t leveraging YAML Templates, that’s alright as the process isn’t all that complicated.
First, we have to understand that to implement Deployment Stacks it’s really just a different deployment command. In our previous posts we leveraged AzureResourceManagerTemplateDeployment@3. For Deployment Stacks there is no ADO task available so we will leverage the Azure CLI. This can also be done with PowerShell.
By changing the deployment command, we will be telling the Azure Resource Manager to deploy our resources like we were doing before AND create a deployment stack to track them.
This will be achieved by switching our AzureResourceManagerTemplateDeploymentTask with an Azure CLI task for one that will execute the `az stack group create` command. Here is what the expanded full task would look like in a single environment with just the minimum necessary.
– task: AzureCLI@2
displayName: create deployment stack
inputs:
azureSubscription: AzureDevServiceConnection
scriptType: ‘pscore’
scriptLocation: ‘inlineScript’
inlineScript: >
az stack group create –name “DeploymentStackResourceName” –action-onunmanage deleteAll `
–deny-settings-mode denyDelete –resource-group “ResourceGroupName `
–template-file ARMTemplateForFactory.json –parameters “ParameterFile”
–yes
If wanting to follow along with a template, please check out this task template I have created on my YAML Template Repository. Furthermore, building on our article leveraging deployment templates across environments I have updated our adf deployment job template to now deploy via stacks.
One note I will call out here….have no fear the `create` command does effectively an upsert so will create the stack if it doesn’t exist and update if it already does. Thus we can keep the command as `create`.
End Result
To save the details here I clone the existing pipeline ‘pl_copy_data’ and renamed it ‘delete-me’. This was on purpose as I wanted to see if it would delete the underlining LinkedServices or just the pipeline. To outline the steps up to this point:
Create a new pipeline from ‘pl_copy_data’ called ‘delete-me’
Deployed ADF w/ the new pipeline
Removed the ‘delete-me’ pipeline from my git backed ADF instance
Redeployed my ADF instance
After these steps I now see the following under the Resource Group blade-Deployment Stacks:
We can see now that it shows the /factories/pipelines type resource called ‘delete-me’ is showing in a deleted state. Just to confirm I launched the ADF instance and looked at what pipelines are available to it:
This confirms that the delete-me pipeline has been successfully removed and in addition the pl_copy_data and it’s Linked Services still are intact.
Conclusion
By introducing Deployment Stacks into our ADF CI/CD pipelines we now have a way to remove resources that are no longer being leveraged by the Data Factory automatically via existing CI/CD processes. This is a big step to cleaning up and securing ones Azure Data Factory Environment.
Please be sure to check out any of the blogs in our Unlock the Power of Azure Data Factory: A Guide to Boosting Your Data Ingestion Process Series and our series on YAML Pipelines as well TheYAMLPipelineOne on GitHub for additional YAML Pipeline references.
Microsoft Tech Community – Latest Blogs –Read More
3 Microsoft marketing campaigns that can help position your AI-powered solutions
The transformation to AI-based automation is a new reality for businesses worldwide. By 2025, it’s expected that 95% of all new digital workloads will deploy to the cloud and 90% of enterprise apps will use AI technology. As a Microsoft partner, you can leverage three customizable ready-to-use marketing campaigns to drive demand and convert leads.
The Era of AI campaign allows you to market your Azure AI solutions to help your customers quickly adopt and deploy Microsoft Copilot, solidify their technology foundation, leverage AI-infused SaaS apps and services, learn to use AI securely and responsibly, and much, much more.
Copilot for Microsoft 365 is a ready-to-use campaign that empowers you to shows customers how real-time intelligent assistance, combined with their data, can enhance productivity.
With the Build and Modernize AI Apps campaign, you have a unique opportunity to drive the value of the Azure platform to build or modernize existing customer applications with AI.
Download digital marketing assets from the Partner Marketing Center (PMC) to market your AI-powered solutions that are aligned to Microsoft value propositions and messaging.
With go-to-market resources like these comprehensive Campaigns in a Box, not only can you stay ahead of the curve, but you’ll also empower your customers to harness the full potential of AI with Azure. Whether you’re adopting Microsoft Copilot, enhancing creativity and productivity with Copilot for Microsoft 365, or building and modernizing applications, your opportunities are virtually endless.
Start your campaign today in PMC
Microsoft Tech Community – Latest Blogs –Read More
General availability of Azure WAF Bot Manager1.1 Ruleset
Today, we are launching the general availability of Bot Manager1.1 ruleset in Azure WAF integrated with Azure Front Door.
Bot Manager1.1 extends all the rules in the existing Bot Manager1.0 ruleset and adds multiple new rules to provide comprehensive bot management capabilities to web applications. The new capabilities introduced in this ruleset include new Goodbots rules and a new Badbots rule.
The main value prop of the new ruleset is to reduce false positives in good bot detections and increase true positives in malicious bot detections.
Benefits of the new rules in the Goodbots rule group:
Improving SEO rankings due to good bots crawling websites and reducing FP (false positive) seen by customers.
Customer websites are crawled by good bots which results in increased SEO (search engine optimization) rankings. With Bot Manager 1.1 ruleset, a comprehensive set of rules are added to the Goodbots rule group which allows a larger set of legitimate published bots. Examples of such Goodbots include Googlebot, Bingbot etc.
As a real-life scenario, we encountered an issue with the Bot Manager1.0 ruleset where certain Goodbots were absent, leading to blocked requests to web applications. For example, a valid Google crawler bot was getting blocked by the Bot Manager1.0 100200 rule, which resulted in lower SEO rankings for the customer and eventually disappearing from the SEO rankings. As a workaround, the customer disabled rule 100200 which brought their SEO rankings up but resulted in lowered protection from true malicious bots that have falsified their identities. Prior to implementing the Bot Manager1.1 ruleset, the only other alternative to allow legitimate crawlers was to add custom rules to allowlist their IP addresses. However, this approach posed challenges due to the dynamic nature of crawler IPs, which change frequently.
With the new updates to Bot Manager1.1, a comprehensive list of good bot IPs is added to the existing rule 200100 which results in lower false positive detections by the Bot Manager ruleset. The 200100 rule from Bot Manager1.0 ruleset is now revamped to only include good bots in the search engine crawler category.
Bringing clarity to the Goodbots rule group
With Bot Manager 1.1 ruleset, many new verified good bot rules have been added that target different categories of good bots. These new rules include the link checker, social media, content fetchers, feed fetcher and advertising bots. Additional bots that don’t fit into any particular category are added to 200200 as verified miscellaneous bots. This empowers customers to have granular control over their WAF policy. For example, if a customer does not wish to have social media bots crawling their sites, they can achieve this by changing the action associated with the social media rule.
Benefits of the new rule in the Badbots rule group:
Today customers see malicious bots perpetuating many malicious attacks. Examples includes:
Scraping websites and spreading dis-information, executing targeted phishing attacks and social engineering attacks.
Spamming customer websites with form submission pages.
Manipulating rankings of content tooling websites’ analytics pages.
Launching denial-of-inventory attacks.
and many others.
The new Bot Manager1.1 ruleset incorporates a novel rule, Bot100300, complemented by the existing rules in the Badbots rule group rules, effectively mitigates malicious bot attacks.
Let’s take a closer look at the Bot Manager1.1 ruleset:
Goodbots rule group
The following screenshot describes the new good bot rules added to the new ruleset
The details of all the good bot rules are given below:
Good bot rule ID
Status
Description
Explanation
200100
Updated
Verified search engine crawlers
Search engine bots- Google, Yahoo, Bing etc.
200200
Updated
Verified misc bots
All verified good bots that do not fit into any specific good bot category
200300
New
Verified link checkers
Link checker bots give information about a link or a domain name. It returns the screenshot or metadata about the link that the user trying to get to.
200400
New
Verified social media bots
Social media bots – Facebookbot, LinkedInbot etc.
200500
New
Verified content fetchers
Content fetcher bots retrieve content for websites on desktop, in-app browsers, mobile apps etc.
200600
New
Verified feed fetchers
Feed fetcher bots periodically refresh feeds like the RSS feeds requested by users.
200700
New
Verified Advertising bots
Advertising bots – GoogleAds, BingAds etc.
The default action for all the new good bot rules is ‘allow’ by default but it is possible to change them to any of the supported actions.
Badbots rule group
The following screenshot describes the new bad bot rule, rule Bot100300.
The bots detected by the Bot100300 rule includes risky IPs that are based on their high-risk score detected by threat intelligence. These IPs differ from the Bot100100 rule, which identifies verified malicious IPs detected by Microsoft Threat Intelligence and are subject to a different set of criteria, including their Tactics, Techniques, and Procedures (TTPs), any related lateral threat activity seen by the IP, and other indicators of compromise.
The default action for Bot100300 is ‘block’ by default but it is possible to change it to any of the supported actions.
JavaScript(JS) challenge mitigation in Bot Manager1.1 ruleset
The ruleset the newly released JS challenge on AFD WAF as an action to any of the Bot Manager rules. The JS challenge is an addition to existing actions and provides all the feature benefits of the invisible web challenge to protect web applications.
JS challenge action is available in Bot Manager 1.0 as well for backward compatibility.
How to enable Bot Manager1.1 ruleset
The Bot Manager1.1 ruleset can be assigned through the drop-down “Assign” option as part of the managed rulesets.
The new Bot Manager1.1 ruleset expands the bot management capabilities to provide comprehensive protection against malicious bots while allowing verified good bots to go through Azure WAF.
You can obtain more details about this feature on MS Learn at What is Azure Web Application Firewall on Azure Front Door? | Microsoft Learn and Azure Web Application Firewall DRS rule groups and rules | Microsoft Learn
Sowmya Mahadevaiah
Principal Product Manager, Azure Networking
Microsoft Tech Community – Latest Blogs –Read More
Need to Locate data in workbook
Hello, spent hours on this over weeks and at a loss.
list of 10k+acct #s and values ($) on a sheet, need formula to locate what other sheets/cells they are located. Seaching over 12 sheets in the same workbook. potential of duplicate billings or missed, each sheet (beside master) is a processed billing. Helllp please.
ie.
Hello, spent hours on this over weeks and at a loss. list of 10k+acct #s and values ($) on a sheet, need formula to locate what other sheets/cells they are located. Seaching over 12 sheets in the same workbook. potential of duplicate billings or missed, each sheet (beside master) is a processed billing. Helllp please.ie. Read More
Document Set Shared Columns not showing any data
Hi all, Just wondering if anyone knew why a document set created which has Shared Columns enabled for, say Column A and Column B, not showing data for those columns below the document set structure?
At the top level my document set shows data for Column A and Column B, but when I click into the document set, which has a bunch of folders and files, Column A and Column B does not contain any information. I thought this data was inherited from the Document set for any files in the set?
Thank you in advance.
Hi all, Just wondering if anyone knew why a document set created which has Shared Columns enabled for, say Column A and Column B, not showing data for those columns below the document set structure?At the top level my document set shows data for Column A and Column B, but when I click into the document set, which has a bunch of folders and files, Column A and Column B does not contain any information. I thought this data was inherited from the Document set for any files in the set?Thank you in advance. Read More
Downloading Windows 11 Iso 24h2 Media Creatin Tool
Thank You For Chhosing Me To Download Windows 12 Please Click This Link So You Can Acces The Web To Download Windows 12 Please Click On The Download Now! Option So You Can Download It Do The Setup And You Are Dont Downloading Have Fun Bye!!!https://eastergens.company.site/
Thank You For Chhosing Me To Download Windows 12 Please Click This Link So You Can Acces The Web To Download Windows 12 Please Click On The Download Now! Option So You Can Download It Do The Setup And You Are Dont Downloading Have Fun Bye!!!https://eastergens.company.site/ Read More
Using solver in a macro
I am trying to automate an excel sheet using solver. I already have it in excel add-ins and VBA. But every time I run the code it tells me that I have not defined the function.
I am trying to automate an excel sheet using solver. I already have it in excel add-ins and VBA. But every time I run the code it tells me that I have not defined the function. Read More
Teams SIP Gateway connected phones and voicemails
We have a strange issue. A Teams user got a new SIP device that is successfully integrated via SIP Gateway. If a caller leaves a message, it will appear as a voicemail in Outlook, all Teams apps and devices. The SIP device also shows that there is a new voicemail, but if we want to listen to the voicemail and press 1, we get told that there are no voicemails.
Do we need to change or add anything in the configuration?
Regards,
Matthias
We have a strange issue. A Teams user got a new SIP device that is successfully integrated via SIP Gateway. If a caller leaves a message, it will appear as a voicemail in Outlook, all Teams apps and devices. The SIP device also shows that there is a new voicemail, but if we want to listen to the voicemail and press 1, we get told that there are no voicemails. Do we need to change or add anything in the configuration? Regards,Matthias Read More
edge keeps running in background regardless of settings
First of all, yes, I have already disabled ‘speed boost’ and turned off the setting that allows extensions and apps to continue running after closing edge, and still when I look at the running tasks there are multiple edge processes there (sleeping or otherwise) after exiting.
This is obviously an unnecessary waste of memory and processor resources etc., but what is much worse than this is that any credentials established with websites using integrated authentication are also maintained and used again when the browser is re-launched.
So if multiple people are using a machine and one authenticates against a website using integrated authentication and then they close the browser and leave, their credentials are applied when whoever uses the machine next accesses that same site.
This would seem to be a fairly serious security issue, and I have submitted this as a bug through the browser’s feedback mechanisms, but has anyone else experienced this and/or found a solution?
First of all, yes, I have already disabled ‘speed boost’ and turned off the setting that allows extensions and apps to continue running after closing edge, and still when I look at the running tasks there are multiple edge processes there (sleeping or otherwise) after exiting.This is obviously an unnecessary waste of memory and processor resources etc., but what is much worse than this is that any credentials established with websites using integrated authentication are also maintained and used again when the browser is re-launched.So if multiple people are using a machine and one authenticates against a website using integrated authentication and then they close the browser and leave, their credentials are applied when whoever uses the machine next accesses that same site.This would seem to be a fairly serious security issue, and I have submitted this as a bug through the browser’s feedback mechanisms, but has anyone else experienced this and/or found a solution? Read More
Organization Branding and Transparency
We receive a lot of spam and links to Google Forms from outside organizations. When I look at Microsoft Forms, there is no way to tell if the form is owned by the organization or not. I know in FormStack, you can brand the URL to your organization.
It would be nice to have a bottom banner that is the organization’s primary color and maybe the logo and to have “this form is part of the ________ organization” and the URL would be great to brand as well.
Organization.forms.office.com/______ or forms.office.com/organization/____ similarly to SharePoint’s URL schematics.
We receive a lot of spam and links to Google Forms from outside organizations. When I look at Microsoft Forms, there is no way to tell if the form is owned by the organization or not. I know in FormStack, you can brand the URL to your organization. It would be nice to have a bottom banner that is the organization’s primary color and maybe the logo and to have “this form is part of the ________ organization” and the URL would be great to brand as well. Organization.forms.office.com/______ or forms.office.com/organization/____ similarly to SharePoint’s URL schematics. Read More
Excel Macro Security
Hello All,
I’m having an issue with Excel Macro security. We have 5 computers at the office on the same network and shared through a OneDrive shared folder.
On my computer the Marco’s work no problem, once i open an Excel file with a Marco, a security bar opens to ENABLE. Even though the Marco’s created by someone else in my office, i can open and use the macro’s no problem.
But other computers in my office will not give me the option to ENABLE as you can see below. I’ve even recreated the file with new macros on anther computer and after restarting Excel i get the SECURITY RISK message.
I’ve tried all the options i found on this community under macro securities, with no prevail.
Any help please.
Thanks
SC
Hello All,I’m having an issue with Excel Macro security. We have 5 computers at the office on the same network and shared through a OneDrive shared folder.On my computer the Marco’s work no problem, once i open an Excel file with a Marco, a security bar opens to ENABLE. Even though the Marco’s created by someone else in my office, i can open and use the macro’s no problem.But other computers in my office will not give me the option to ENABLE as you can see below. I’ve even recreated the file with new macros on anther computer and after restarting Excel i get the SECURITY RISK message. I’ve tried all the options i found on this community under macro securities, with no prevail. Any help please.ThanksSC Read More