SharePoint Lists: Freeze Panes and Fix Excel Import Connection Errors
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.

- 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.
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.
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.
Open the list in SharePoint and scroll through its items to see whether the column headers remain visible in your list experience.
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.
Troubleshoot the Excel-to-SharePoint List import
Check the workbook, account, permissions, and connection separately from the Freeze Panes question.
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.

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.





