Forum Discussion

pinogar's avatar
pinogar
Copper Contributor
Apr 01, 2025

Editing excel in sharepoint

hello!

I have an excel 365 file in sharepoint and when several users try to edit at the same time, and after that update it, the file gets freeze and produces errors.

 

Is there any solution or configuration in the sharepoint in order to optimise and improve the used of the file by several users at the same time with out errors?

Thanks a lot

excel
Excel for web
office 365

3 Replies

  • mary23's avatar
    mary23
    Copper Contributor
    Apr 03, 2025

    I can't get nothing to open up I keep getting redirected everywhere somebody's got me hacket

     

  • Kidd_Ip's avatar
    Kidd_Ip
    MVP
    Apr 03, 2025

    Take this:

     

    1. Enable Co-Authoring
    • Ensure that the Excel file is stored in a SharePoint Online document library and is opened using Excel Online. Co-authoring allows multiple users to edit the file simultaneously without conflicts.
    1. Optimize File Size
    • Large files with complex formulas or data can cause performance issues. Simplify the file by:
      • Reducing the number of formulas and pivot tables.
      • Splitting large files into smaller, manageable ones.
    1. Use Versioning
    • Enable version history in SharePoint to track changes and avoid overwriting errors. This can be configured in the document library settings.
    1. Check Permissions
    • Ensure that all users have appropriate permissions (e.g., Edit access) to avoid conflicts.
    1. Update Office and SharePoint
    • Ensure that all users are using the latest version of Excel 365 and that SharePoint is updated to the latest version.
    1. Avoid Simultaneous Editing in Desktop Excel
    • If users open the file in Excel Desktop, simultaneous editing may cause issues. Encourage users to use Excel Online for collaboration.
    1. Monitor Network Performance
    • Slow network connections can lead to freezing. Ensure that users have stable internet connections.
    1. Use SharePoint Settings
    • Configure SharePoint to optimize file handling:
      • Enable Check-In/Check-Out for files to manage edits.
      • Set appropriate file size limits in the library settings.
  • JaxonMitchell's avatar
    JaxonMitchell
    Iron Contributor
    Apr 02, 2025

    1. Edit directly in the browser
    Click File > ‘Edit in Browser’
    Support Function:
    ✓ Basic formulas
    ✓ Cell Formatting
    ✓ Simple charts
    2. Advanced Editing Requirements
    Click ‘Open in Desktop Application’ (requires Office installed)
    Automatic checkout of locked files (conflict prevention)
    3. File locking conflicts
    powershell
    # Administrator forced unlock (SharePoint Online)
    Connect-SPOService -Url https://contoso-admin.sharepoint.com
    Set-SPOFileCheckedOut -SiteUrl ‘https://contoso.sharepoint.com/sites/team’ -ServerRelativeUrl ‘/documents/file.xlsx’ -CheckinType MajorCheckIn
    4. Version Control Conflicts
    File > Information > Version History
    Compare/restore old versions
    5. External Link Updates
    Data > Edit Links > Set ‘Auto Update’
    Co-Editing Best Practices
    Real-time co-editing rules
    Avoid table-wide operations (e.g. sorting/filtering)
    Fixed editing of different worksheets per person
    Change Tracking
    Review > Track Changes (fully supported in desktop version only)
    Data validation limitations
    SharePoint schema does not support dynamic array overflow
    Alternative: use Power Query to preprocess data

Resources