Overview of SharePoint Online
SharePoint Online, a vital component of the Microsoft 365 suite, is a cloud-based platform crucial in enhancing collaboration and document management for businesses. It offers many features, including document storage, version control, and robust search capabilities. SharePoint Online is not just a tool but a facilitator that enables teams to work together more efficiently by providing a centralised location for storing and sharing documents, facilitating seamless communication and collaboration across various departments and geographical locations. Its integration with other Microsoft 365 applications, such as OneDrive and Microsoft Teams, further extends its functionality, making it an indispensable tool for modern businesses.
Importance of Understanding the Limitations of SharePoint Online
While SharePoint Online offers numerous advantages, businesses must be aware of the limitations of SharePoint Online to optimise its usage fully. Understanding these constraints can help organisations plan effectively, avoid pitfalls, and ensure smooth operations. Critical limitations of SharePoint Online, such as file size restrictions, storage limits, and list thresholds, can impact workflow efficiency if not managed proactively. By being aware of these limitations, businesses can implement best practices and workarounds to mitigate their effects, thereby maintaining productivity and ensuring the platform meets their needs. Additionally, understanding the specific limitations of SharePoint Online based on subscription plans can assist in making informed decisions when selecting the most appropriate plan for the organisation’s requirements.
Limitations of SharePoint Online: File Size Limitations
Maximum File Size for SharePoint Online
Part of the limitations of SharePoint Online is the maximum file size limit. At present, SharePoint Online limits individual file uploads to 250 GB. This restriction applies to files uploaded to SharePoint document libraries, OneDrive folders, Microsoft Teams Files tabs, and Viva Engage conversations. While this limit accommodates most business needs, it can pose challenges for organisations dealing with large video files, extensive databases, or complex project files.
Workarounds for Large File Management
To effectively manage large files within the limitations of SharePoint Online, consider the following workarounds:
- Proper Data Planning: Identify which data should be kept on SharePoint Online and what can be archived or stored in alternative locations.
- Versioning: Utilise SharePoint Online’s versioning capabilities to maintain only necessary document versions, reducing overall file size.
- File Compression: Compress files before uploading them to minimise their size.
- Alternative Storage: Consider using OneDrive for Business or other third-party storage solutions for huge files.
- User Training: Educate users on efficient storage practices and cleaning up unnecessary files.
- Storage Alerts: Set up alerts to track storage usage and prevent unexpectedly reaching the limit.
Table: SharePoint Online File Size Limits and Recommendations
| Limitation | Details | Recommendations |
| Maximum File Size | 250 GB per file | Compress large files before uploading. |
| File Storage Locations | SharePoint document libraries, OneDrive, Teams Files tabs, Viva Engage conversations | Use alternative storage solutions for huge files. |
| Version Management | Maintain only necessary document versions | Utilise versioning capabilities to manage file sizes. |
| Storage Planning | Archive non-essential data | Plan data storage to optimise space usage. |
| User Training | Educate on efficient storage practices | Implement regular training sessions for users. |
| Storage Monitoring | Set up storage alerts | Monitor storage usage proactively. |
By understanding and addressing the file size and the limitations of SharePoint Online, businesses can optimise their document management processes, ensuring seamless collaboration and efficient use of storage resources.
Limitations of SharePoint Online: Storage Limitations
Per User Storage Limits
One fundamental limitation of SharePoint Online is its per-user storage limit. This restriction is one of the critical limitations of SharePoint Online that organisations must consider. Each user can effectively use up to 25 TB of storage. This allocation is sufficient for most small to medium-sized businesses. However, this limit can be restrictive for organisations with high data demands, necessitating careful storage management.
Per Site and Per Group Storage Limits
In addition to the limitations of SharePoint Online imposes storage caps at the site and group levels:
- Per Site: Each site in SharePoint Online has a maximum storage capacity of 1 TB.
- Per Group: Each group has a storage capacity of up to 100 GB.
These limits require organisations to strategically plan data storage to ensure uninterrupted access and efficient collaboration.
Strategies for Effective Storage Management
To manage storage effectively within the limitations of SharePoint Online, consider implementing the following strategies:
- Strategic Storage Distribution: Spread data across multiple sites and libraries to optimise storage use and prevent any site from reaching its limit.
- Archiving Policies: Implement archiving policies for older documents and data not frequently accessed, freeing up space for current projects.
- Monitoring Tools: Use SharePoint’s built-in monitoring tools to track storage allocation and usage. Review these metrics regularly to ensure efficient storage management.
- Data Cleanup: Periodically review and clean up obsolete files and data. Encourage users to delete unnecessary documents and versions to maintain optimal storage levels.
- Educate Users: Train users on best practices for storage management, including how to archive documents, delete old versions, and use alternative storage options for large files.
Table: SharePoint Online Storage Limits and Recommendations
| Limitation | Details | Recommendations |
| Per User Storage Limit | Up to 25 TB per user | Monitor individual storage usage regularly. |
| Per Site Storage Limit | Maximum 1 TB per site | Distribute data across multiple sites and libraries. |
| Per Group Storage Limit | Up to 100 GB per group | Implement archiving policies for older documents. |
| Storage Monitoring | Built-in tools to track usage | Use monitoring tools to review storage allocation. |
| Data Cleanup | Periodic review of files | Regularly clean up obsolete files and data. |
| User Education | Training on storage best practices | Educate users on efficient storage management techniques. |
By understanding and managing SharePoint Online’s storage limitations, businesses can optimise their data management practices, ensure effective resource use, and maintain high productivity levels.
Limitations of SharePoint Online: List Limitations
Default View Threshold for List Items
Part of the significant limitations of SharePoint Online’s storage is the default view threshold for list items, which is capped at 5,000 items. This limit ensures optimal performance and avoids slow response times when users access or interact with lists. Exceeding this threshold can lead to difficulty retrieving and managing data, impacting workflow efficiency.
Indexing and List Design Best Practices
To mitigate the impact of the list view threshold and enhance the performance of large lists, consider the following best practices:
- Indexing: Create indices on columns frequently used in queries to improve performance and increase the list view threshold to accommodate up to 30,000 items.
- List Design: Carefully design your lists to ensure they adhere to the column limitations. Avoid creating unnecessary columns and provide the list structure.
- Filtered Views: Use filtered views to display only relevant items, reducing the number of items retrieved once and improving performance.
- Folder Organisation: Organise items into folders to break down large lists into smaller, more manageable sections.
- Item Limits: Set item limits on views to control the number of items displayed simultaneously, enhancing user experience and performance.
Table: SharePoint Online List Limitations and Mitigation Techniques
| Limitation | Details | Mitigation Techniques |
| Default View Threshold | 5,000 items | Use indexing to increase the threshold to 30,000 items. |
| Column Limitations | Maximum of 200 user-defined columns per list | Plan and design lists to avoid unnecessary columns. |
| Filtered Views | Display relevant items only | Implement filtered views to improve performance. |
| Folder Organisation | Organise items into folders | Use folders to break down large lists. |
| Item Limits | Control the number of items displayed | Set item limits on views to enhance performance. |
By understanding the list of limitations of SharePoint Online and applying these best practices, businesses can maintain efficient workflows and ensure a smooth user experience. Effective management of list items and thoughtful list design can significantly mitigate the impact of these limitations, allowing for more productive use of SharePoint Online.
Limitations of SharePoint Online: General Limitations
User Capacity
One of the general limitations of SharePoint Online’s storage is user capacity. The platform supports a base limit of 300 users, which can be expanded to 25,000 for organisations on the E5 plan. This limitation necessitates careful planning to ensure all necessary users have access without exceeding the capacity, especially for growing businesses.
Number of Sites and Document Versions
SharePoint Online also imposes limits on the number of sites and document versions:
- Number of Sites: An organisation can create up to 25,000 sites, providing ample space for creating digital workspaces. However, exceeding this limit can complicate management and navigation.
- Document Versions: Each document can maintain up to 500 significant versions, facilitating extensive revision history and collaboration. This limit ensures that storage is used efficiently without overwhelming the system with excessive versions.
External Users and Workflow Instances
Additional limitations of SharePoint Online include constraints on external users and workflow instances:
- External Users: SharePoint Online allows up to 5,000 external users, facilitating collaboration with partners and clients outside the organisation. Proper management of these users is essential to maintain security and efficiency.
- Workflow Instances: The platform supports up to 200 unique workflow instances per site, enabling automation and streamlining of business processes. Exceeding this limit can impact workflow performance and system stability.
Table: General SharePoint Online Limitations
| Limitation | Details | Recommendations |
| User Capacity | The base limit is 300 users, but the E5 plan allows for an expansion to 25,000 users. | Plan user access carefully and upgrade plans as needed. |
| Number of Sites | Up to 25,000 sites | Organise sites effectively to avoid management issues. |
| Document Versions | Up to 500 significant versions per document | Implement version control policies to manage versions. |
| External Users | Up to 5,000 external users | Manage external access efficiently and securely. |
| Workflow Instances | Up to 200 unique workflow instances per site | Optimise workflows to stay within the limit. |
By understanding the limitations of SharePoint Online’s storage, businesses can implement effective strategies to optimise their platform use. Proper planning and management can help mitigate the impact of these constraints, ensuring smooth operations and maximising the benefits of SharePoint Online.
Limitations of SharePoint Online: Operational Limits for Moving/Copying Files
Total File Size, Number of Files, and Individual File Size Restrictions
One of the limitations of SharePoint Online’s storage includes specific operational limits regarding moving or copying files. These restrictions are in place to ensure optimal performance and avoid system overloads. The fundamental limitations include:
- Total File Size: The total file size limit when moving or copying files is 100 GB. This means the combined size of all files in a single move or copy operation cannot exceed this limit.
- Number of Files: You can move or copy 30,000 files in a single operation. Exceeding this number can lead to errors and interruptions in the process.
- Individual File Size: Each file involved in these operations must be less than 15 GB, except for OneNote files, which have a stricter limit of 2 GB.
These limitations of SharePoint Online require careful planning and management, especially when dealing with large volumes of data.
Strategies for Managing Large File Operations
To effectively manage file operations within the limitations of SharePoint Online, consider the following strategies:
- Split Large Files: Divide large files into smaller parts that comply with the individual file size limit. This can facilitate smoother transfers and minimise the risk of errors.
- Batch Operations: Break down large file operations into smaller batches. Instead of moving or copying all files simultaneously, operate in stages, ensuring each batch stays within the size and number limits.
- Use PowerShell and CSOM: To gain greater control over file operations, utilise SharePoint PowerShell cmdlets or the SharePoint Online Client Object Model (CSOM). These tools provide flexibility and can handle complex file operations more efficiently.
- Third-Party Tools: Consider using third-party applications designed to assist with managing SharePoint content. These tools can streamline moving or copying large files or large volumes of files.
- Schedule Operations During Off-Peak Hours: Schedule large file operations during off-peak hours to minimise the impact on system performance and user access.
By incorporating strategies tailored to the limitations of SharePoint Online’s storage, businesses can enhance their ability to manage files smoothly and efficiently.
Limitations of SharePoint Online: Document Library Limitations
Maximum Items, File Size, List View Threshold, and Permissions Limit
Document libraries in SharePoint Online are essential for storing and managing files. Still, they come with several limitations that users must be aware of to ensure smooth operations:
- Maximum Items: SharePoint document libraries can hold up to 30 million items, including documents and folders. However, performance can be affected when dealing with large numbers of items, primarily if they are not appropriately managed.
- File Size: A single document uploaded to a SharePoint library can have a maximum file size of 250 GB. Files larger than this cannot be stored and must be split or compressed.
- List View Threshold: SharePoint Online’s list view threshold displays up to 5,000 items by default. Attempting to retrieve more than 5,000 items at once without proper indexing can lead to performance issues.
- Permissions Limit: It is recommended that unique permissions for items within a document library be limited to no more than 5,000. Exceeding this number can complicate permission management and degrade performance.
Syncing with OneDrive
Syncing SharePoint document libraries with OneDrive allows users to access their files offline and provides a convenient way to manage documents. However, there are limitations of SharePoint Online to consider:
- Item Limit: The OneDrive sync client can handle up to 300,000 files across all synced libraries. Exceeding this limit can lead to sync errors and slow performance.
- File Size Limit: The maximum file size for syncing is 250 GB, like the upload limit for SharePoint document libraries.
- File Path Length: The file path, including the file name, must not exceed 400 characters. This includes the domain name, library path, folder structure, and file name.
- Selective Sync: Users can select specific folders to synchronise their devices. However, overseeing these choices across many files and folders can be challenging.
Table: Document Library Limitations and Management Techniques
| Limitation | Details | Management Techniques |
| Maximum Items | Up to 30 million items | Use folders and metadata to organise and manage items. |
| File Size | Maximum 250 GB per file | Compress or split large files before uploading. |
| List View Threshold | Display up to 5,000 items | Implement indexing and filtered views to improve performance. |
| Permissions Limit | Limit unique permissions to 5,000 | Simplify permission structures and use groups for access control. |
| OneDrive Sync Item Limit | Up to 300,000 files | Regularly review and clean up synced files. |
| OneDrive Sync File Size Limit | Maximum 250 GB per file | Ensure large files are within the size limit before synchronising. |
| File Path Length | Maximum 400 characters | Simplify folder structures and file names. |
| Selective Sync | Manage which folders to synchronise | Use selective sync to manage storage on local devices. |
Businesses can optimise their document management processes by understanding SharePoint Online’s document library limitations and employing these management techniques. Proper planning and organisation can help mitigate the impact of these limitations, ensuring efficient and effective use of SharePoint Online.
Limitations of SharePoint Online: Integration and Plan-Specific Limitations
Dynamics 365 Integration Limitations
One of the limitations of SharePoint Online is its integration with Dynamics 365. While linking Dynamics 365 with SharePoint Online enhances document management capabilities, there are certain caveats:
- Security Models: Dynamics 365 and SharePoint Online have different security models. This can lead to scenarios where users might access documents in SharePoint Online that they cannot see in Dynamics 365 or vice versa.
- Feature Availability: Not all SharePoint features are available through Dynamics 365. Advanced document management functionalities like workflows, version control, and metadata may not work seamlessly.
- Complex Configuration: Setting up and maintaining integration between Dynamics 365 and SharePoint Online requires careful configuration to preserve security and functionality.
Variations by Microsoft 365 Subscription Plans
SharePoint Online’s features and limitations vary significantly depending on the Microsoft 365 subscription plan. Key differences include:
- Plan 1: Designed for small teams or organisations, Plan 1 offers essential storage and collaboration tools. It includes document sharing, team sites, and primary content management. However, it lacks advanced security and compliance features.
- Plan 2: Suitable for medium to large teams, Plan 2 includes enhanced storage capacity, advanced search capabilities, and additional compliance features. It also offers more robust security measures than Plan 1.
- E5: The most comprehensive plan, E5 is ideal for large organisations requiring extensive capabilities. It includes all features of lower plans plus advanced analytics, Power Automate for process automation, and the most comprehensive security and compliance tools.
Table: SharePoint Online Plan Comparisons
| Plan | Storage | Number of Users | File Size | Other Restrictions |
| Plan 1 | 1 TB per organisation + 10 GB per license | Up to 300 users | Max 250 GB per file | Basic collaboration features and standard search capabilities. |
| Plan 2 | 1 TB per organisation + 10 GB per license | 1 – 500,000 users | Max 250 GB per file | Enhanced search, additional DLP capabilities, and advanced security features. |
| E5 | 1 TB per organisation + 10 GB per license | 1 – 500,000 users | Max 250 GB per file | Advanced analytics, Power Automate integration, comprehensive security, and compliance tools. |
Understanding SharePoint Online’s integration and plan-specific limitations allows businesses to effectively select the most appropriate plan and configure integrations. By being aware of these constraints, organisations can better plan their usage, ensuring that SharePoint Online meets their needs and supports their goals efficiently.
Limitations of SharePoint Online: Increasing SharePoint Online Limits
Criteria and Process for Requesting Limit Increases
While SharePoint Online provides substantial capabilities, some organisations may find the default limits restrictive. To address this, Microsoft allows requests for increased limits under specific criteria:
- Organisation Size: Larger organisations with significant data needs are more likely to receive approval for increased limits.
- Number of Employees: More active users can justify expanding capacity.
- Current Usage: Demonstrating high current usage and future growth projections can support the case for increased limits.
- Business Criticality: If SharePoint Online is critical to business operations, this can be a decisive factor in the approval process.
Process for Requesting Limit Increases:
- Assessment of Needs: Evaluate current and projected usage to determine specific requirements.
- Documentation Preparation: Gather detailed information about organisational size, number of employees, current SharePoint Online usage, and business criticality.
- Contact Microsoft Support: Submit a request through the Microsoft Support Contact Page, providing all relevant documentation and a clear explanation of why increased limits are necessary.
- Review and Decision: Microsoft will review the request and potentially request additional information. Decisions are typically made within ten working days.
- Implementation: If approved, Microsoft will guide the organisation through implementing the increased limits.
Benefits and Considerations for Increased Limits
Increasing SharePoint Online limits can offer several benefits:
- More Storage Space: This accommodates larger projects and data sets without external storage solutions.
- Higher User Capacity: Supports growing teams and ensures all employees access necessary resources.
- Improved Performance: Enhanced resource allocation can lead to better system performance and faster access times.
- Scalability: Facilitates future growth without immediate concerns about hitting system limits.
However, there are important considerations:
- Potential Costs: Increased limits may come with higher subscription fees or additional charges.
- Ongoing Compliance: Ensuring continued adherence to Microsoft’s Service Level Agreements and policies is essential.
- Management Overhead: Larger data sets and more users can increase the complexity of system management.
Table: Recommendations for Requesting Increased Limits
| Recommendation | Details |
| Evaluate Current Usage | Assess current SharePoint Online usage and future needs to justify the request. |
| Prepare Detailed Documentation | Provide comprehensive information about organisational size, user base, and data needs. |
| Submit Request to Microsoft | Contact Microsoft Support with all relevant details and a clear explanation. |
| Monitor and Manage Usage | Regularly review usage to ensure it aligns with the increased limits. |
| Consider Potential Costs | Be prepared for adjustments to subscription fees or additional charges. |
| Adhere to Compliance Requirements | Ensure ongoing compliance with Microsoft’s policies and Service Level Agreements. |
| Plan for Future Scalability | Use the increased limits to facilitate future growth and operational needs. |
By understanding the process and criteria for increasing SharePoint Online limits, businesses can effectively plan and justify their needs, ensuring they can leverage the platform’s full potential to support their growth and operational efficiency.
Limitations of SharePoint Online: Third-Party Enhancements
Enhancing SharePoint with VirtoSoftware
Businesses can use third-party enhancements like VirtoSoftware offers to overcome some of SharePoint Online’s limitations. These tools are designed to integrate seamlessly with SharePoint Online, extending its functionality and improving overall efficiency. VirtoSoftware provides various solutions that address usual challenges, helping organisations make the most of their SharePoint environment.
Overview of Popular VirtoSoftware Tools
VirtoSoftware offers several popular tools that enhance the capabilities of SharePoint Online:
- Virto Calendar: This tool integrates multiple calendars into one SharePoint calendar view, combining Exchange Calendar (Outlook), Google Calendar, Salesforce Calendar, and others. It supports colour-coding and overlays, making it easier to manage schedules and deadlines from a single interface.
- Virto Kanban Board: Designed for visual task management, the Kanban Board allows teams to manage workflows using a card-based layout. It supports drag-and-drop functionality, customisable columns and swimlanes, and various task management features such as sorting, filtering, and editing directly on the board.
- Virto Alerts and Reminders: This tool ensures that team members are updated with changes within SharePoint lists, documents, and other items. It automates the delivery of notifications, which can be customised to fit specific needs, ensuring timely updates and maintaining operational continuity.
Table: Benefits and Features of VirtoSoftware Tools
| Tool | Benefits | Features |
| Virto Calendar | – Centralised calendar view | – Integration with multiple calendars – Colour-coding – Calendar overlays |
| Virto Kanban Board | – Improved task management and workflow transparency | – Drag-and-drop functionality – Customisable columns and swimlanes – Task sorting and filtering |
| Virto Alerts and Reminders | – Timely updates and notifications | – Customisable alert conditions – Alert templates – Automatic notification delivery |
By integrating these third-party tools from VirtoSoftware, organisations can enhance SharePoint Online’s functionality, making it a more powerful and flexible platform. These enhancements address SharePoint Online’s limitations, providing additional features that improve productivity, collaboration, and overall user experience.
Conclusion
Summary of Key Points
Understanding the limitations of SharePoint Online is crucial for businesses to optimise their usage of this powerful platform fully. Key limitations include:
- File Size Limits: A maximum of 250 GB per file upload.
- Storage Limits: Per user, site, and group storage constraints.
- List Limitations: A default view threshold of 5,000 items.
- General Limitations: User capacity, number of sites, document versions, external users, and workflow instances.
- Operational Limits: Restrictions on moving and copying files.
- Document Library Limits: Maximum items, file size, list view threshold, permissions, and synchronising with OneDrive.
- Integration and Plan-Specific Limits: Dynamics 365 integration and variations by subscription plans.
Best Practices for Navigating SharePoint Online Limitations
To effectively navigate these limitations, businesses should implement the following best practices:
- Proper Planning: Assess your organisation’s needs and plan your SharePoint usage accordingly.
- Data Management: Use archiving, versioning, and regular data cleanup to manage storage efficiently.
- Indexing and Design: Implement indexing and careful list design to optimise performance.
- Use of Third-Party Tools: Leverage third-party enhancements like those from VirtoSoftware to extend SharePoint’s capabilities.
- User Training: Educate users on best practices for storage, file management, and collaboration.
- Monitor Usage: Regularly monitor storage and usage to prevent exceeding limits.
Final Thoughts on Maximising SharePoint Online Efficiency
Despite SharePoint Online’s limitations, organisations can maximise efficiency and effectiveness with careful planning and strategic management. Understanding these constraints allows businesses to implement proactive measures, ensuring that SharePoint Online meets their needs and supports their operations seamlessly.
By leveraging best practices and considering third-party enhancements, businesses can optimise their SharePoint environment, facilitating better collaboration, improved productivity, and more efficient data management. Properly navigating SharePoint Online’s limitations will help companies unlock their full potential, making it a cornerstone of their digital workplace strategy.