Table of Contents
While going through several forum sites we concluded that so many users have shared their grievances while working on SharePoint they fail to create a list in excel. And when they try to create a list from an existing file that’s available on the SharePoint website they get prompted with the following message:
“Something went wrong. The file [xxxx] does not exist”.
If you are also trying hard to get past the error then you have reached at the right place. Here we will try to mention all the possible fixes to get past the issue. So stay tuned with us.
But before proceeding with the troubleshooting methods we believe that we should go through its possible reasons for the better understanding of this error.
Why I am having cannot create list in Excel the File does not exist
- You won’t be able to create a list from the targeted Excel Sheet if the default Document Directory has been deleted from the SharePoint.
- Another reason for the error is the data type within the Excel Sheet and in addition to data type, managed metadata or some look column can also be a reason
- You are likely to face the above mention error if the file’s name has been renamed from Documents to something else.
Try these fixes for cannot create list in Excel the File does not exist
Method 1: The Default Document Library is Renamed
As we have earlier mentioned that if the default document library has been renamed then you may suffer from the above mention issue. So in such situation you have to rename it back to Documents.
To do the same follow the below mention steps:
Step 1: Navigate to the Library Settings>then go to the List Name, Description and Navigation
Step 2: Now click on Name and then rename the file
Once you have renamed the file then check if the issue resolved or not.
Method 2: Default Document Library is deleted
One of the major reasons for facing the current error is deletion of default Document Library .In such scenario you have to retrieve the deleted file.
To do so follow the below mention steps:
Step 1: If the default Document Library is deleted and present in the recycle bin in such case you can restore it. And hence you will get your Excel file back and you can proceed with the process of creating a list from that file.
Step 2: If the file has been deleted and you are unable to get it back from the recycle bin, then you will have to create a new library with the name Documents.
Method 3: Issue with the Data Type
If you are facing the above mention error because of data type within the Excel Sheet then you have to check the columns within the file.
Try to create a new list from an existing list that uses common data types like a single line of text, date and people picker. If it works for you then we suggest you to find out what other date types you are using there which might be creating issues.
Method 4: Managed Metadata is the problem
Once you are done with checking all the columns within the Excel Sheet then ensure that the data type is not the culprit, then you can move on to file the source of the error. Find out whether the managed metadata or some look column is creating the above mention trouble.
That’s all about cannot create list in Excel the File does not exist. We have tried our best to provide all the potential fixes to get past the error and now it’s your turn to follow our guidelines.