Others

How to Choose a Save Location When Creating a Microsoft List

Chanuka Geekiyanage Oct 20, 2026 869 views

Question details

The user needs to select a destination to save a new list in Microsoft Lists, but the Save to field is empty or unavailable.

How to Choose a Save Location When Creating a Microsoft List

Product: Microsoft Lists
Device & OS: not provided
Scenario: Setting up a new shared list in Microsoft 365 and attempting to define where it will be stored for team access.
Observed behavior: The Save to dropdown field is blank, preventing the user from saving the list, typically because no associated SharePoint site is available.

Before you start

Ensure you have an active Microsoft 365 subscription with access to both Microsoft Lists and SharePoint, as shared lists require an existing SharePoint site for cloud storage.

Solution 1Recommended

Create a New SharePoint Site to Enable List Saving

Shared Microsoft Lists must be stored on a SharePoint site. Creating a new site will populate your Save to field and allow you to proceed.

Microsoft Lists integrates directly with SharePoint to manage permissions and file storage for shared lists. If you are starting fresh or don't belong to any existing groups, you must manually establish a SharePoint site to host your data.

Open SharePoint

Log into your Microsoft 365 account, click the App Launcher (the grid icon in the top left), and select SharePoint.

Create a Site

Click on 'Create site' located near the top of the SharePoint homepage. Choose either a 'Team site' for collaboration or a 'Communication site' based on your needs.

Complete the Setup

Follow the on-screen prompts to name your site, add an optional description, and finish the setup process. Wait a few moments for the site to fully provision.

Return to Microsoft Lists

Open Microsoft Lists again and click 'New list'. When you reach the setup screen, click the 'Save to' dropdown, and your newly created SharePoint site will now be available to select.

Create a New SharePoint Site to Enable List Saving

Admin Permissions: If you do not see the option to create a SharePoint site, your Microsoft 365 administrator may have restricted these permissions. You will need to contact your IT department to request a site.

Free Microsoft Office alternative

Looking for a Seamless and Free Microsoft Office Alternative?

If you are looking to manage data, track lists, and organize spreadsheets but want to avoid the complexities of Microsoft 365 and SharePoint site administration, try WPS Office. It provides a lightweight, robust environment for your data management needs.

1. Download and Install: Visit the official WPS Office website to download the free application for your operating system.
2. Open WPS Spreadsheet: Launch WPS Office and open the Spreadsheet module to easily start creating and organizing your data lists.
3. Save and Share via Cloud: Click 'Save As' and select WPS Cloud to securely store your list online, allowing you to easily generate sharing links for team collaboration.

Fully compatible with Microsoft Excel (.xlsx) formats for easy data and list management.Lightweight installation with a highly intuitive, familiar user interface.Built-in WPS Cloud storage for saving and sharing your documents seamlessly without complex site setups.Free to download and use across Windows, Mac, Linux, iOS, and Android devices.

microsoft office alternative - wps office

Frequently Asked Questions

Why is my 'Save to' dropdown empty in Microsoft Lists?

The 'Save to' field appears empty when your account doesn't have access to any SharePoint sites. Microsoft Lists requires a SharePoint site to host and store any list intended for shared access.

Can I save a Microsoft List to my personal storage instead?

Yes, you can save personal lists to 'My lists', which stores them in your personal OneDrive. However, if you are creating a list meant for team collaboration, it must be saved to a shared SharePoint site.

Does a communication site work for hosting Microsoft Lists?

Yes, you can save a Microsoft List to both Team sites and Communication sites, provided you have the appropriate edit permissions to add content to that specific site.

What should I do if I am not allowed to create a SharePoint site?

If your organization has disabled self-service site creation, you must contact your IT department or Microsoft 365 administrator to either grant you the necessary permissions or create a SharePoint site on your behalf.

Office Quick Solutions