SharePoint Document Issues

SharePoint Lists: Freeze Panes and Fix Excel Import Connection Errors

Chanuka GeekiyanageChanuka Geekiyanage Nov 14, 2026 868 views

Question details

The user wants to keep rows or columns visible in a SharePoint list and import an Excel table without a server connection error.

Freeze Panes and Troubleshoot Excel Imports in SharePoint Lists
Product
SharePoint Online Lists
Device & OS
not provided
Scenario
Working with a SharePoint list and creating a list from an Excel table.
Observed behavior
SharePoint does not provide a general Excel-style Freeze Panes feature for arbitrary rows and columns, and the Excel import reports that it cannot connect to the server.
Before you start

Confirm that you can open the target SharePoint site with the intended work or school account and have permission to create lists. Check that the source workbook contains a formatted Excel table.

Solution 1

Check SharePoint List scrolling and Freeze Panes limitations

Use this guidance to understand what can remain visible while scrolling a SharePoint list.

SharePoint Online does not offer a general Freeze Panes command for arbitrary list rows and columns. Column headers may remain visible while scrolling, depending on the list experience.

1
Check the list view

Open the list in SharePoint and scroll through its items to see whether the column headers remain visible in your list experience.

2
Use Excel for frozen panes

If you need to freeze specific rows or columns, open the data in Excel and use View > Freeze Panes. This applies to the workbook view, not the SharePoint list.

Free Microsoft Office alternative

Work with Excel spreadsheets in WPS Office

WPS Office is a free, lightweight alternative for working with spreadsheets in a familiar interface. Open compatible Excel files and continue working with your existing documents, though WPS does not fix SharePoint import or list-view issues.

Use Freeze Panes in WPS Spreadsheets when working in a workbook.Open and edit Microsoft Excel XLSX files.Work in a familiar spreadsheet interface that makes switching easier.Use a free, lightweight office suite for everyday document work.
microsoft office alternative - wps office

Frequently Asked Questions

Can I freeze the first column in a SharePoint list?

SharePoint Online does not provide a general Freeze Panes feature for arbitrary list columns. For an Excel workbook, use View > Freeze Panes in Excel instead.

Why does SharePoint say it cannot connect to the server when I import Excel?

The message can be related to the signed-in account, site permissions, browser session, network, or service availability. Verify each separately and give the exact error to your Microsoft 365 administrator if it persists.

Does my Excel data need to be a table before import?

Prepare the data as an Excel table before using New > List > From Excel. In Excel, select the data and choose Insert > Table, then save the workbook.

Can WPS Office fix the SharePoint import error?

No. WPS Office can open and edit compatible Excel files, but the SharePoint connection and permissions must be checked in SharePoint and Microsoft 365.