Month: September 2024
Using a function in COUNTIF criteria
Is it possible to use a function inside COUNTIF criteria so that it is applied to each cell in the range under test? For instance, I have column A of text values and want to count cells in it with the text longer than 8. I’m trying to write something like =COUNTIF(A:A,LEN(A1)&”>8″), but it doesn’t work. What is a correct syntax if possible?
Is it possible to use a function inside COUNTIF criteria so that it is applied to each cell in the range under test? For instance, I have column A of text values and want to count cells in it with the text longer than 8. I’m trying to write something like =COUNTIF(A:A,LEN(A1)&”>8″), but it doesn’t work. What is a correct syntax if possible? Read More
Brand Center Options Grayed Out (Already have Organizational Assets Library)
I’m trying to activate the Brand Center in Org Settings, but everything is grayed out. I’m a global admin and we already use an Organizational Assets Library, which it detects. According to the documentation, it’s supposed to prompt to enable a public CDN and then we’re good to go, but that isn’t happening.
Anyone run into this? Is there some kind of prereq that hasn’t been met maybe?
I’m trying to activate the Brand Center in Org Settings, but everything is grayed out. I’m a global admin and we already use an Organizational Assets Library, which it detects. According to the documentation, it’s supposed to prompt to enable a public CDN and then we’re good to go, but that isn’t happening. Anyone run into this? Is there some kind of prereq that hasn’t been met maybe? Read More
CALCULATING 24 HOUR TIME TO THE NEAREST QUARTER HOUR
I bill clients and pay contractors to the nearest quarter hour. I cannot seem to put together a formula that will do the job.
say start time is 0800 hrs stop time 1215 hrs. the formula (B-A)/100 returns 4.15 and not the 4.25 needed to calculate pay at the appropriate rate
but if start time is 0730 hrs and stop time is 1715 the formula (B-A)/100 returns 9.85 and not 9.75 needed
is there a step function i can incorporate? or do I have to create a table and use a look up function? perhaps something simple I haven’t thought of?
I bill clients and pay contractors to the nearest quarter hour. I cannot seem to put together a formula that will do the job. say start time is 0800 hrs stop time 1215 hrs. the formula (B-A)/100 returns 4.15 and not the 4.25 needed to calculate pay at the appropriate rate but if start time is 0730 hrs and stop time is 1715 the formula (B-A)/100 returns 9.85 and not 9.75 neededis there a step function i can incorporate? or do I have to create a table and use a look up function? perhaps something simple I haven’t thought of? Read More
Announcing Global Provisioned Managed Deployments for Scaling Azure OpenAI Service Workloads
We’re excited to announce a major advancement in AI deployments with Azure OpenAI Service: Global Provisioned Managed Deployments, now Generally Available (GA) as of September 18, 2024. This launch marks a significant milestone in our commitment to making AI more accessible, scalable, and flexible for customers worldwide, building on our August release of Provisioned Throughput Units (PTU) for self-service regional deployments.
What is Global Provisioned Managed?
Global Provisioned Managed is a new deployment type within the Azure OpenAI Service that leverages Azure’s global infrastructure to serve provisioned traffic more efficiently. It supports the latest GPT-4o (2024-08-06) and GPT-4o-mini (2024-07-18) models, making them accessible to customers without the limitations of region-specific quotas or capacities. This new deployment model empowers customers to extend AI capabilities to any corner of the globe, providing greater flexibility and speed in deploying models.
Dual Availability: Global and Regional
We are also pleased to announce that the GPT-4o (2024-08-06) model is now available not only through Global Provisioned Managed deployments but also for Provisioned Regional Deployments via self-service. This means customers have the flexibility to choose between a globally managed deployment model or a more controlled, region-specific deployment approach, depending on their specific needs and preferences.
Key Benefits of Global Provisioned Managed Deployments
Access to the Latest Models Everywhere: The Global Provisioned Managed deployment model removes regional limitations, allowing customers to access the newest AI models like GPT-4o and GPT-4o-mini across all supported Azure regions, including eastus, westeurope, japaneast, and more.
Simplified Deployment and Management: Unlike traditional deployment approaches, Global Provisioned Managed decouples capacity management from specific regions, granting automatic access to the new global quota for all eligible customers.
Data Residency and Compliance Flexibility: While API traffic may be processed globally, all customer data is securely stored in the Azure OpenAI Service resource’s region, ensuring adherence to regional data residency and compliance requirements.
Transparent and Flexible Pricing: Billing for Global Provisioned Managed follows the same model as existing Provisioned Managed deployments, ensuring predictable costs with options for hourly pricing and reservations to accommodate diverse usage scenarios.
Dual Deployment Options for Greater Flexibility: The availability of the GPT-4o model for both Global Provisioned Managed and Provisioned Regional Deployments gives customers the freedom to choose the most suitable deployment strategy for their organizational needs.
Why Choose Global Provisioned Managed?
This new deployment type represents a significant evolution in our approach to AI, offering:
Global Reach: Deploy AI models anywhere without the constraints of regional quotas or capacities.
Cost Efficiency: Benefit from cost management options, including monthly and yearly reservations.
Enhanced Flexibility: Deploy and scale AI solutions faster with less complexity and administrative burden, allowing you to focus more on innovation.
Regional Control: For customers needing specific regional deployments, the GPT-4o model remains available through self-service, enabling full control over capacity management.
How to Get Started
Deploying your AI models globally or regionally is simple:
For Global Provisioned Managed Deployments: This option will be available in your Azure OpenAI Service regional resources starting September 18, 2024. To use it, create or select an existing regional resource, and choose the Global Provisioned Managed deployment option.
For Provisioned Regional Deployments: The GPT-4o (2024-08-06) model is available for self-service regional deployments, giving you flexibility to manage regional capacities and resources according to your needs.
Looking Ahead: More Models and Regions
Our initial rollout of Global Provisioned Managed includes support for the GPT-4o and GPT-4o-mini models, with plans to expand the availability of more models under this deployment type. For those requiring specific regional support, the existing Provisioned Managed deployment remains available.
Embrace the Future of AI with Azure OpenAI Service
Azure OpenAI Service is committed to pushing the boundaries of AI capabilities. With the new Global Provisioned Managed deployments, we’re breaking down barriers, providing more flexibility, and ensuring our customers can fully leverage AI’s potential anywhere in the world.
Learn More:
Azure Pricing Provisioned Reservations
Azure OpenAI Service Pricing
More details about Provisioned Throughput
Documentation for Onboarding
PTU Calculator in Azure AI Studio
Unveiling Azure OpenAI Service Provisioned Reservations blog
Data, Privacy, and Security for Azure OpenAI Service
Microsoft Tech Community – Latest Blogs –Read More
Creating an Oulook distribution list, my first, LOST all the addresses in Outlook Contact
Created a list of addresses using instructions from MS. Add then saved. Now all I get for both icons People and Groups is 1 address and the group. I had MANY addresses in the People folder. What happened. The group does hold the ones I selected for the group.
Created a list of addresses using instructions from MS. Add then saved. Now all I get for both icons People and Groups is 1 address and the group. I had MANY addresses in the People folder. What happened. The group does hold the ones I selected for the group. Read More
How to Free Up Storage in SharePoint Online Using Intelligent Versioning and PowerShell
So I’ve gotten more and more questions from users and client how to free up storage in their enviroment and I didn’t see and good post about how to do it, so I wrote a blogppost 🙂
Introduction
Freeing Storage in SharePoint Online Using Intelligent Versioning and PowerShell Automation
As organizations increasingly adopt SharePoint Online for collaboration and document management, managing storage efficiently becomes a critical challenge. One significant contributor to storage consumption is SharePoint’s versioning feature, which creates multiple versions of documents, leading to storage bloat over time.
In this post, we’ll discuss how to intelligently manage file versioning in SharePoint Online and automate the cleanup of old versions using PowerShell. By the end, you’ll have a clear strategy for maintaining healthy storage and managing SharePoint’s powerful versioning features effectively.
Understanding SharePoint Online Versioning
Versioning in SharePoint Online allows users to save multiple copies of documents as they get revised. This is essential for tracking changes, restoring earlier versions, and enabling collaboration. However, if not managed properly, the version history of documents can accumulate rapidly, consuming valuable storage space.
By default, SharePoint retains all versions of a document. Over time, this can lead to excessive storage usage, increased costs, and slower performance. This is where Intelligent Versioning becomes a useful strategy.
What is Intelligent Versioning?
Intelligent Versioning refers to a smart strategy that helps balance retaining valuable document history while freeing up unnecessary storage. Rather than keeping all document versions indefinitely, Intelligent Versioning helps ensure that only recent and important versions are retained, while older versions are deleted to conserve space.
This approach helps you optimize your SharePoint storage while preserving important data.
How Intelligent Versioning Works
Intelligent Versioning introduces a feature called automatic version thinning, which gradually trims older document versions while preserving key timestamps. Here’s how it works:
First 30 Days: All versions are kept.
From 30 to 180 Days: Hourly or daily versions are stored.
Beyond 180 Days: Weekly versions are kept indefinitely.
By using this automatic thinning approach, Microsoft reports that you can reduce version storage usage by up to 96% in some cases, without compromising users’ ability to access important historical versions.
My personal experience, I’ve seen storage saved 30-60% from various clients!
Benefits of Intelligent Versioning
Optimize Storage Costs: By deleting outdated versions, you reduce storage consumption, keeping within limits and potentially lowering costs.
Improve Performance: With fewer document versions stored, searches and retrieval times are faster.
Maintain Data Integrity: Intelligent Versioning ensures you delete only unnecessary versions while keeping critical ones intact.
How to Enable Intelligent Versioning
To enable Intelligent Versioning across your SharePoint Online tenant, use the following PowerShell command:
# Connect to SharePoint Online
$adminSiteUrl = “https://<tenant>-admin.sharepoint.com”
Connect-SPOService -Url $adminSiteUrl
# Enable Intelligent versioning
Set-SPOTenant -EnableVersionExpirationSetting $true
PnP Powershell:
# Install and Import PnP PowerShell module if not installed
# Install-Module -Name “PnP.PowerShell”
# Connect to SharePoint Online Admin Center
$adminSiteUrl = “https://<tenant>-admin.sharepoint.com”
Connect-PnPOnline -Url $adminSiteUrl -Interactive
# Enable Intelligent Versioning
Set-PnPTenant -EnableVersionExpirationSetting $true
Once enabled, this will apply Intelligent Versioning to all new files in SharePoint document libraries. You can verify this setting in the Admin Center under Versioning Settings.
Automating Version Cleanup Using PowerShell
While Intelligent Versioning applies to new documents, older files require manual intervention. Managing versions manually across multiple sites can be a tedious task. Fortunately, PowerShell allows you to automate the process.
Using the New-SPOSiteFileVersionBatchDeleteJob cmdlet, you can create batch deletion jobs to remove document versions older than a specified date.
Prerequisites:
SharePoint Online Administrator permissions.
SharePoint Online Management Shell installed.
PowerShell Script: Automating Version Cleanup
Here’s a PowerShell script that retrieves all site collections in your SharePoint Online tenant and creates a batch delete job for document versions older than 365 days:
# Connect to SharePoint Online
$adminSiteUrl = “https://<tenant>-admin.sharepoint.com”
Connect-SPOService -Url $adminSiteUrl
# Get all site collections
$siteCollections = Get-SPOSite -Limit All
# Loop through each site collection
foreach ($site in $siteCollections) {
Write-Host “Processing site: $($site.Url)”
# Create a batch delete job for versions older than 365 days
try {
New-SPOSiteFileVersionBatchDeleteJob -Identity $site.Url -DeleteBeforeDays 365 -confirm:$false
Write-Host “Batch delete job created for site: $($site.Url)”
}
catch {
Write-Host “Error creating batch delete job for site: $($site.Url)”
Write-Host $_.Exception.Message
}
}
# Disconnect from SharePoint Online
Disconnect-SPOService
PnP Powershell:
# Install the PnP PowerShell module if not already installed
# Install-Module -Name “PnP.PowerShell”
# Connect to SharePoint Online
$adminSiteUrl = “https://<tenant>-admin.sharepoint.com”
Connect-PnPOnline -Url $adminSiteUrl -Interactive
# Get all site collections
$siteCollections = Get-PnPTenantSite -IncludeOneDriveSites -Limit All
# Loop through each site collection
foreach ($site in $siteCollections) {
Write-Host “Processing site: $($site.Url)”
try {
# Create a batch delete job for versions older than 365 days
New-PnPSiteFileVersionBatchDeleteJob -SiteUrl $site.Url -LastRetainedVersionDate 365 -confirm:$false
Write-Host “Batch delete job created for site: $($site.Url)”
}
catch {
Write-Host “Error creating batch delete job for site: $($site.Url)”
Write-Host $_.Exception.Message
}
}
# Disconnect from SharePoint Online
Disconnect-PnPOnline
How This Script Works
Connect to SharePoint Online: The script first connects to your SharePoint Online tenant using the Admin Center URL.
Retrieve All Site Collections: It retrieves all site collections using the Get-SPOSite cmdlet.
Set Retention Date: The script calculates the retention date as 365 days before the current date.
Create Batch Delete Job: The New-SPOSiteFileVersionBatchDeleteJob cmdlet creates a batch job to delete versions older the days you’ve set.
Error Handling: If an error occurs, it logs the error and continues to the next site collection.
Best Practices for Intelligent Versioning and Cleanup
Define a Versioning Policy: Decide how many versions you want to retain for different types of documents. This can be configured in library settings or using PowerShell (e.g., -MajorVersionLimit X). I recommend having it in automatic!
Automate Version Cleanup: Use automation to regularly clean up old versions, minimizing the need for manual intervention.
Monitor Storage Usage: Regularly review storage reports from the SharePoint Admin Center to identify areas where storage is being consumed excessively. Make use of SharePoint Archive and Backup for data that isn’t needed on regular basis
Combine with Retention Policies: Protect critical files by applying Retention Labels or Retention Policies to ensure they are not deleted prematurely, especially for legal or compliance reasons.
Conclusion
As your organization grows, efficiently managing your SharePoint Online storage is crucial. Intelligent Versioning helps you retain the benefits of version control while optimizing storage and keeping costs under control.
By using PowerShell to automate version cleanup, you can streamline the process, ensuring that unnecessary versions are deleted without impacting important datam This way you can clean up old data and know that your future data isn’t being eaten up!
https://yourmodernworkplace.com/blog/Free-Storage-In-SharePoint-Online-Using-Intelligent-Versioning
So I’ve gotten more and more questions from users and client how to free up storage in their enviroment and I didn’t see and good post about how to do it, so I wrote a blogppost 🙂
Introduction
Freeing Storage in SharePoint Online Using Intelligent Versioning and PowerShell Automation
As organizations increasingly adopt SharePoint Online for collaboration and document management, managing storage efficiently becomes a critical challenge. One significant contributor to storage consumption is SharePoint’s versioning feature, which creates multiple versions of documents, leading to storage bloat over time.
In this post, we’ll discuss how to intelligently manage file versioning in SharePoint Online and automate the cleanup of old versions using PowerShell. By the end, you’ll have a clear strategy for maintaining healthy storage and managing SharePoint’s powerful versioning features effectively.
Understanding SharePoint Online Versioning
Versioning in SharePoint Online allows users to save multiple copies of documents as they get revised. This is essential for tracking changes, restoring earlier versions, and enabling collaboration. However, if not managed properly, the version history of documents can accumulate rapidly, consuming valuable storage space.
By default, SharePoint retains all versions of a document. Over time, this can lead to excessive storage usage, increased costs, and slower performance. This is where Intelligent Versioning becomes a useful strategy.
What is Intelligent Versioning?
Intelligent Versioning refers to a smart strategy that helps balance retaining valuable document history while freeing up unnecessary storage. Rather than keeping all document versions indefinitely, Intelligent Versioning helps ensure that only recent and important versions are retained, while older versions are deleted to conserve space.
This approach helps you optimize your SharePoint storage while preserving important data.
How Intelligent Versioning Works
Intelligent Versioning introduces a feature called automatic version thinning, which gradually trims older document versions while preserving key timestamps. Here’s how it works:
First 30 Days: All versions are kept.
From 30 to 180 Days: Hourly or daily versions are stored.
Beyond 180 Days: Weekly versions are kept indefinitely.
By using this automatic thinning approach, Microsoft reports that you can reduce version storage usage by up to 96% in some cases, without compromising users’ ability to access important historical versions.
My personal experience, I’ve seen storage saved 30-60% from various clients!
Benefits of Intelligent Versioning
Optimize Storage Costs: By deleting outdated versions, you reduce storage consumption, keeping within limits and potentially lowering costs.
Improve Performance: With fewer document versions stored, searches and retrieval times are faster.
Maintain Data Integrity: Intelligent Versioning ensures you delete only unnecessary versions while keeping critical ones intact.
How to Enable Intelligent Versioning
To enable Intelligent Versioning across your SharePoint Online tenant, use the following PowerShell command:
# Connect to SharePoint Online
$adminSiteUrl = “https://<tenant>-admin.sharepoint.com”
Connect-SPOService -Url $adminSiteUrl
# Enable Intelligent versioning
Set-SPOTenant -EnableVersionExpirationSetting $true
PnP Powershell:
# Install and Import PnP PowerShell module if not installed
# Install-Module -Name “PnP.PowerShell”
# Connect to SharePoint Online Admin Center
$adminSiteUrl = “https://<tenant>-admin.sharepoint.com”
Connect-PnPOnline -Url $adminSiteUrl -Interactive
# Enable Intelligent Versioning
Set-PnPTenant -EnableVersionExpirationSetting $true
Once enabled, this will apply Intelligent Versioning to all new files in SharePoint document libraries. You can verify this setting in the Admin Center under Versioning Settings.
Automating Version Cleanup Using PowerShell
While Intelligent Versioning applies to new documents, older files require manual intervention. Managing versions manually across multiple sites can be a tedious task. Fortunately, PowerShell allows you to automate the process.
Using the New-SPOSiteFileVersionBatchDeleteJob cmdlet, you can create batch deletion jobs to remove document versions older than a specified date.
Prerequisites:
SharePoint Online Administrator permissions.
SharePoint Online Management Shell installed.
PowerShell Script: Automating Version Cleanup
Here’s a PowerShell script that retrieves all site collections in your SharePoint Online tenant and creates a batch delete job for document versions older than 365 days:
# Connect to SharePoint Online
$adminSiteUrl = “https://<tenant>-admin.sharepoint.com”
Connect-SPOService -Url $adminSiteUrl
# Get all site collections
$siteCollections = Get-SPOSite -Limit All
# Loop through each site collection
foreach ($site in $siteCollections) {
Write-Host “Processing site: $($site.Url)”
# Create a batch delete job for versions older than 365 days
try {
New-SPOSiteFileVersionBatchDeleteJob -Identity $site.Url -DeleteBeforeDays 365 -confirm:$false
Write-Host “Batch delete job created for site: $($site.Url)”
}
catch {
Write-Host “Error creating batch delete job for site: $($site.Url)”
Write-Host $_.Exception.Message
}
}
# Disconnect from SharePoint Online
Disconnect-SPOService
PnP Powershell:
# Install the PnP PowerShell module if not already installed
# Install-Module -Name “PnP.PowerShell”
# Connect to SharePoint Online
$adminSiteUrl = “https://<tenant>-admin.sharepoint.com”
Connect-PnPOnline -Url $adminSiteUrl -Interactive
# Get all site collections
$siteCollections = Get-PnPTenantSite -IncludeOneDriveSites -Limit All
# Loop through each site collection
foreach ($site in $siteCollections) {
Write-Host “Processing site: $($site.Url)”
try {
# Create a batch delete job for versions older than 365 days
New-PnPSiteFileVersionBatchDeleteJob -SiteUrl $site.Url -LastRetainedVersionDate 365 -confirm:$false
Write-Host “Batch delete job created for site: $($site.Url)”
}
catch {
Write-Host “Error creating batch delete job for site: $($site.Url)”
Write-Host $_.Exception.Message
}
}
# Disconnect from SharePoint Online
Disconnect-PnPOnline
How This Script Works
Connect to SharePoint Online: The script first connects to your SharePoint Online tenant using the Admin Center URL.
Retrieve All Site Collections: It retrieves all site collections using the Get-SPOSite cmdlet.
Set Retention Date: The script calculates the retention date as 365 days before the current date.
Create Batch Delete Job: The New-SPOSiteFileVersionBatchDeleteJob cmdlet creates a batch job to delete versions older the days you’ve set.
Error Handling: If an error occurs, it logs the error and continues to the next site collection.
Best Practices for Intelligent Versioning and Cleanup
Define a Versioning Policy: Decide how many versions you want to retain for different types of documents. This can be configured in library settings or using PowerShell (e.g., -MajorVersionLimit X). I recommend having it in automatic!
Automate Version Cleanup: Use automation to regularly clean up old versions, minimizing the need for manual intervention.
Monitor Storage Usage: Regularly review storage reports from the SharePoint Admin Center to identify areas where storage is being consumed excessively. Make use of SharePoint Archive and Backup for data that isn’t needed on regular basis
Combine with Retention Policies: Protect critical files by applying Retention Labels or Retention Policies to ensure they are not deleted prematurely, especially for legal or compliance reasons.
Conclusion
As your organization grows, efficiently managing your SharePoint Online storage is crucial. Intelligent Versioning helps you retain the benefits of version control while optimizing storage and keeping costs under control.
By using PowerShell to automate version cleanup, you can streamline the process, ensuring that unnecessary versions are deleted without impacting important datam This way you can clean up old data and know that your future data isn’t being eaten up!
https://yourmodernworkplace.com/blog/Free-Storage-In-SharePoint-Online-Using-Intelligent-Versioning Read More
How do I write this formula?
Hi!
I’ve created a workbook with 2 worksheets. They’re named “MW-562 Pay” and “Employee Hours”.
When the user fills in the “MW-562 Pay”, certain bits of the information is pulled from the “MW-562 Pay” worksheet into the “Employee Hours” worksheet.
The formula I’ve used, in the cells on the “Employee Hours” worksheet, to do this is
=’MW-562 Pay’!A14
and I change the A14 from cell to cell as needed. It works great.
Where I’m running into trouble:
Some users will need to add a second “MW-562 Pay” worksheet (and a third, and a fourth, etc.) to accommodate more employees.
To do that, they’ll copy the “MW-562 Pay” worksheet into the workbook. They’ll be instructed to name those additional worksheets as “MW-562 Pay 2” and “MW-562 Pay 3” and “MW-562 Pay 4” and so on.
I need to pre-populate the “Employee Hours” worksheet ahead of time with formulas so that it’s ready to pull the info from the additional “MW-562 Pay” worksheets once they’re added, if they’re added (some users won’t need to add additional worksheets, the one will be enough).
The cells on the “Employee Hours” worksheet that will pull info from the added worksheets need to remain visibly empty until and unless the user adds more “MW-562 Pay” worksheets.
Because I know what the name of the additional worksheets will be, I thought that I could write the formulas ahead of time to pull the info from those yet-to-be added worksheets, for example:
=’MW-562 Pay 2′!A14
And then when someone copies the “MW-562 Pay” and names that added worksheet “MW-562 Pay 2”, the formulas I pre-populated into the “Employee Hours” worksheet would start pulling the needed info from the newly added “MW-562 Pay 2” worksheet.
Unfortunately, I ended up with #REF errors on the “Employee Hours” worksheet in all cells that have formulas pulling info from the yet to be added “MW-562 Pay 2” worksheet.
I understand why I received the #REF errors (because the formulas are referencing a worksheet that isn’t present yet) but I thought, no big, that’ll change once I add the “MW-562 Pay 2” worksheet.
Alas, that didn’t happen, the #REF errors remained.
How would I go about accomplishing my goal which is to have the “Employee Hours” worksheet pre-populated with the formulas that’ll pull the info from the additional worksheets once they’re added? Is it possible?
Thank you so much!! 🙂
Hi! I’ve created a workbook with 2 worksheets. They’re named “MW-562 Pay” and “Employee Hours”. When the user fills in the “MW-562 Pay”, certain bits of the information is pulled from the “MW-562 Pay” worksheet into the “Employee Hours” worksheet. The formula I’ve used, in the cells on the “Employee Hours” worksheet, to do this is =’MW-562 Pay’!A14 and I change the A14 from cell to cell as needed. It works great. Where I’m running into trouble: Some users will need to add a second “MW-562 Pay” worksheet (and a third, and a fourth, etc.) to accommodate more employees. To do that, they’ll copy the “MW-562 Pay” worksheet into the workbook. They’ll be instructed to name those additional worksheets as “MW-562 Pay 2” and “MW-562 Pay 3” and “MW-562 Pay 4” and so on. I need to pre-populate the “Employee Hours” worksheet ahead of time with formulas so that it’s ready to pull the info from the additional “MW-562 Pay” worksheets once they’re added, if they’re added (some users won’t need to add additional worksheets, the one will be enough). The cells on the “Employee Hours” worksheet that will pull info from the added worksheets need to remain visibly empty until and unless the user adds more “MW-562 Pay” worksheets. Because I know what the name of the additional worksheets will be, I thought that I could write the formulas ahead of time to pull the info from those yet-to-be added worksheets, for example: =’MW-562 Pay 2′!A14 And then when someone copies the “MW-562 Pay” and names that added worksheet “MW-562 Pay 2”, the formulas I pre-populated into the “Employee Hours” worksheet would start pulling the needed info from the newly added “MW-562 Pay 2” worksheet. Unfortunately, I ended up with #REF errors on the “Employee Hours” worksheet in all cells that have formulas pulling info from the yet to be added “MW-562 Pay 2” worksheet. I understand why I received the #REF errors (because the formulas are referencing a worksheet that isn’t present yet) but I thought, no big, that’ll change once I add the “MW-562 Pay 2” worksheet. Alas, that didn’t happen, the #REF errors remained. How would I go about accomplishing my goal which is to have the “Employee Hours” worksheet pre-populated with the formulas that’ll pull the info from the additional worksheets once they’re added? Is it possible? Thank you so much!! 🙂 Read More
Quick search outlook 2021 problem
Hello everyone
I have a question about searching in outlook.
I am connected to the exchange server.
When I do a search, it searches for letters for 3 days.
today
last search
To make it search more, I need to click
include older results
How can I make it search not only for 3 days, but for a month at once? (without clicking include older results)
Or should it give a full search (include older results)?
Hello everyoneI have a question about searching in outlook.I am connected to the exchange server.When I do a search, it searches for letters for 3 days.today last search To make it search more, I need to clickinclude older results How can I make it search not only for 3 days, but for a month at once? (without clicking include older results)Or should it give a full search (include older results)? Read More
Tls 1.0 and tls1.1
At the os level I have tls1 and tls1.1 off. Could it be configured under IIS per site?
How can find these individual sites making outbound connections?
Iis10 on windows 2022
Thanks
At the os level I have tls1 and tls1.1 off. Could it be configured under IIS per site?How can find these individual sites making outbound connections? Iis10 on windows 2022 Thanks Read More
Account locked the verification method doesn’t work now
Hi,
I’m writing for someone my girlfriend as her account cannot be retrieved.
She reset her password and cannot sign in since.
She is trying to reset password again but when she tries to verify the 2FA, th eonly option available is by receiving a SMS. But the website keeps telling her that this verification method is not working now, and cannot do anything else.
Can you please help me with that ? I can give you more info if needed.
Hi,I’m writing for someone my girlfriend as her account cannot be retrieved.She reset her password and cannot sign in since.She is trying to reset password again but when she tries to verify the 2FA, th eonly option available is by receiving a SMS. But the website keeps telling her that this verification method is not working now, and cannot do anything else. Can you please help me with that ? I can give you more info if needed. Read More
How to set up Formula to determine my aged in a given Year
I am trying to set up a spreadsheet in Excel to determine a person’s age in a given year. For example, if I was born on 04/27/1956, how old would I have been in 1994, or how old would I be in 2047? Any help would be greatly appreciated,
Sag771
I am trying to set up a spreadsheet in Excel to determine a person’s age in a given year. For example, if I was born on 04/27/1956, how old would I have been in 1994, or how old would I be in 2047? Any help would be greatly appreciated,Sag771 Read More
How to create a Theme with the colors of your brand reusable in all SharePoint sites
The SharePoint Brand center introduces a brand color management experience along with a new experience for creating and managing themes for your organization.
The all-new brand color experience allows you to create a standard set of colors for your organization that will be utilized in other experiences.
This allows you to seamlessly create and standardize your color options.
You will also be able to create and manage your organization’s themes in the Brand center for SharePoint and Microsoft Viva Connections.
With this new theme creation and management experience, you will be able to easily create themes for your organization and make them available in the “Change the look” experience.
The SharePoint Brand center introduces a brand color management experience along with a new experience for creating and managing themes for your organization.
The all-new brand color experience allows you to create a standard set of colors for your organization that will be utilized in other experiences.
This allows you to seamlessly create and standardize your color options.
You will also be able to create and manage your organization’s themes in the Brand center for SharePoint and Microsoft Viva Connections.
With this new theme creation and management experience, you will be able to easily create themes for your organization and make them available in the “Change the look” experience. Read More
How can I share a word doc for review but not download?
We have an issue with reviewers downloading shared files and returning them 3-4 weeks later with markup that is out of sync with the shared version.
I see how to share for review. I can share for view only – no download.
Is it possible to share for review and not allow downloading?
We have an issue with reviewers downloading shared files and returning them 3-4 weeks later with markup that is out of sync with the shared version. I see how to share for review. I can share for view only – no download. Is it possible to share for review and not allow downloading? Read More
Surface Support Portal delivers significant time savings for IT admins
Microsoft is streamlining the support experience for Surface Commercial users by transitioning from the traditional Services Hub to a modern, consolidated support system. The new Surface Support Portal, accessible via the Microsoft 365 admin center enables IT admins to manage all Surface devices from a single platform. This eliminates the need for additional tools, allowing admins to quickly access warranty information, create support requests and manage repairs—all without contacting Microsoft Support. The result: A more efficient, convenient and time-saving solution tailored to meet the needs of IT teams.
For a quick overview, check out the video:
Complete support solution: Surface Support Portal vs. Services Hub
The Surface Support Portal packs a host of features that greatly exceeds the capabilities of the Services Hub – Support for business site, ensuring a seamless transition while offering enhanced support, increased functionality and improved efficiency.
Feature
Surface Support Portal
Services Hub
Self-serve capabilities
Yes
No
Track service & support order history
Yes
No
Access to Surface technicians
Yes
Yes
View warranty status
Yes
No
Secure authentication
Yes
No
Access to Support tools
Yes
No
Support via chat
Yes
No
Role-based access control
Yes
No
AI-enabled self-help
Yes
No
Platform
Microsoft 365
Admin Center
Microsoft 365
Admin Center
How can the Surface Support Portal help you?
Simplify management: Streamline device support and reduce the time needed to manage your Surface fleet with centralized tools. A single portal helps you manage updates, track repairs, and monitor device warranty, eliminating the need to switch between multiple platforms or tools for different tasks.
Monitor & manage: Gain full visibility into your support requests with Microsoft. Track ticket status and download shipping labels. Stay updated on new device serial numbers for exchanges to help track newly assigned devices and maintain accurate inventory records.
Bulk device repair & exchange orders: Handle up to 100 devices in a single service order workflow, saving time and effort by processing hardware repairs, battery replacements, damage claims, and related tasks — all while accommodating various warranty types and service agreements.
Enhance security & efficiency: Secure access to your devices, service, and support using Microsoft 365 authentication and validation for added protection. For example, ensure that only authorized IT admins can access device management features and support requests by using multifactor authentication (MFA) and role-based access controls.
Maximize budget & resources: Quickly identify which devices are covered under warranty to avoid unnecessary expenses and delays for service and support. For example, prioritize repairs or replacements for in-warranty devices and avoid paying out-of-pocket for repairs that are still covered under manufacturer or extended warranties.
AI-enabled self-help: Utilize AI for problem-specific recommendations and step-by-step troubleshooting guidance to help Surface users resolve common technical issues.
Customers using Microsoft Intune can take advantage of all the capabilities discussed above, along with additional insights, through the Surface Management Portal. For all other customers, the Surface Support Portal represents a leap forward in access to support and management of your Surface fleet. For more information on how to access Surface Support Portal and the Surface Management Portal, follow the links below. Sign up today and simplify the management of your Surface devices with streamlined support and enhanced control.
Customers with an existing Microsoft 365 subscription can access the Surface Support Portal via the Surface support page. For those without a Microsoft tenant, a new tenant can be created for free with no attached products required to gain access to the Surface Support Portal. To learn more, see Surface Support Portal overview – Surface | Microsoft Learn.
Learn more
Surface portals overview
Surface Support Portal overview – Surface | Microsoft Learn
Surface Management Portal overview – Surface | Microsoft Learn
Assign admin roles for Surface portals – Surface | Microsoft Learn
Microsoft Tech Community – Latest Blogs –Read More
Don’t miss the upcoming Microsoft Fabric & AI Learning Hackathon Informational AMA | October 8th!
The Microsoft Fabric & AI Learning Hackathon is underway and we’re excited to learn about your project ideas and questions! Join us for an interactive session where we’ll look at recent announcements from the European Microsoft Fabric Community Conference, share tips and best practices for competing in the Hackathon, provide technical and informational support, and connect you with expert resources to support ongoing development of your Hackathon project!
RSVP here!
The Microsoft Fabric & AI Learning Hackathon is underway and we’re excited to learn about your project ideas and questions! Join us for an interactive session where we’ll look at recent announcements from the European Microsoft Fabric Community Conference, share tips and best practices for competing in the Hackathon, provide technical and informational support, and connect you with expert resources to support ongoing development of your Hackathon project!
RSVP here! Read More
Excel formula with commission based tiers
Hello!
I can’t wrap my head around how to create this formula.
In cell I20 I have an employee’s net sales. In I21 I want to create a formula that will give their commission earnings.
So for example, if the employee has $132,000 in annual sales, their commission tier would be 2%, BUT they wouldn’t just get a blanket 2% on their annual sales. They would have 0% commission on the first $50,000, 1% on the $50k-100k, etc.
Thank you!
Hello! I can’t wrap my head around how to create this formula. In cell I20 I have an employee’s net sales. In I21 I want to create a formula that will give their commission earnings. So for example, if the employee has $132,000 in annual sales, their commission tier would be 2%, BUT they wouldn’t just get a blanket 2% on their annual sales. They would have 0% commission on the first $50,000, 1% on the $50k-100k, etc. Thank you! Read More
Can anyone shed some light on what happened with SharePoint lists? SUPER slow to non-functional
Hi. We currently update a SP list using an Excel spreadsheet that compares new stuff to what’s already in the list. Anything new in the spreadsheet that isn’t in the list gets copied/pasted to the bottom of the list. That still works. But we also identify anything that needs to be removed (i.e., it’s in the SP list but not in the updated Excel sheet, and the only way to transfer that info to the SharePoint list is to copy from the Excel sheet and paste into the SP list (grid view). Then the list can be filtered on flagged items to remove them. That part is no longer working.
Prior to June 2024, that process did work, albeit very slowly and poorly; could paste in only ~100 records at a time. Then in June, something changed with SP, and the look of list changed, but so did the performance – to the better! Still not 100% great, but way better than before. But, sometime during the first week of September, Microsoft rolled SharePoint back, and now I don’t seem to be able to paste in anything. At all.
This is a major impact and setback to our processes. Does anyone have any information on what MS did and why? I’ve even got a ticket in with a Microsoft Support Escalation Engineer, and she said, “I have not found anything indicating why they made the change but I know they made a lot of changes to the Lists recently.”. I appreciate any information folks may have – including a better way to update a SP list. Thank you!
Hi. We currently update a SP list using an Excel spreadsheet that compares new stuff to what’s already in the list. Anything new in the spreadsheet that isn’t in the list gets copied/pasted to the bottom of the list. That still works. But we also identify anything that needs to be removed (i.e., it’s in the SP list but not in the updated Excel sheet, and the only way to transfer that info to the SharePoint list is to copy from the Excel sheet and paste into the SP list (grid view). Then the list can be filtered on flagged items to remove them. That part is no longer working. Prior to June 2024, that process did work, albeit very slowly and poorly; could paste in only ~100 records at a time. Then in June, something changed with SP, and the look of list changed, but so did the performance – to the better! Still not 100% great, but way better than before. But, sometime during the first week of September, Microsoft rolled SharePoint back, and now I don’t seem to be able to paste in anything. At all. This is a major impact and setback to our processes. Does anyone have any information on what MS did and why? I’ve even got a ticket in with a Microsoft Support Escalation Engineer, and she said, “I have not found anything indicating why they made the change but I know they made a lot of changes to the Lists recently.”. I appreciate any information folks may have – including a better way to update a SP list. Thank you! Read More
What the latest Copilot enhancements mean for Small and Medium-sized Businesses
Hey Everyone! In case you missed it, Microsoft made a slate of announcements earlier today discussing the next phase of Copilot for work.
These include improvements in Excel with the integration of Python unlocking the ability to use everyday language to analyze data, new features such as Prioritize my inbox in Outlook, and Narrative builder in PowerPoint, and the addition of Copilot Pages within BizChat to foster collaboration while using AI generated content. Read more about these enhancements and more in this blog from Brenna Robinson.
What are you most interested in trying out first? Sound off in the comments.
Hey Everyone! In case you missed it, Microsoft made a slate of announcements earlier today discussing the next phase of Copilot for work.
These include improvements in Excel with the integration of Python unlocking the ability to use everyday language to analyze data, new features such as Prioritize my inbox in Outlook, and Narrative builder in PowerPoint, and the addition of Copilot Pages within BizChat to foster collaboration while using AI generated content. Read more about these enhancements and more in this blog from Brenna Robinson.
What are you most interested in trying out first? Sound off in the comments. Read More
Can you change the visualization of the Group Calendar web part?
Good afternoon, is it possible to change the Group Calendar web part’s layout to reflect a 30/31 day view, instead of event-by-event? I am shocked there is not an OOTB option for this…
Thank you in advance!
Morghan C.
Good afternoon, is it possible to change the Group Calendar web part’s layout to reflect a 30/31 day view, instead of event-by-event? I am shocked there is not an OOTB option for this… Thank you in advance! Morghan C. Read More
Intune enrollment – deploying an IPAD same configuration 50 clients
I work in a manufacturing warehouse and we are moving from a handheld scanner Windows mobile to an ipad with a bluetooth scanner. I dont want to configure these as a shared device in intune , but a managed device in intune that will run at most 3 apps. I’m trying to understand the best way to configure the device with a single account and then the ipad will be locked down with a wifi connection and run the apps internally, mostly a url in a browser. The plan is to configure these devices in fully supervised mode in intune
I work in a manufacturing warehouse and we are moving from a handheld scanner Windows mobile to an ipad with a bluetooth scanner. I dont want to configure these as a shared device in intune , but a managed device in intune that will run at most 3 apps. I’m trying to understand the best way to configure the device with a single account and then the ipad will be locked down with a wifi connection and run the apps internally, mostly a url in a browser. The plan is to configure these devices in fully supervised mode in intune Read More