lapucca
asked on
Why can't I change the column type or deleted it after I import the excel sheet into SharePoint Custom Listing?
Hi, I'm using SharePoint 2007.
I crated a new list by importing a Excel sheet. The first 2 columns would not allow for changing column type after I import so I created 2 dummy columns in excel sheet then import it. I was able to delete one of the column but the 2nd one I cannot delete in SharePoint. Why and how can I get rid of this dummny column? Thanks.
I crated a new list by importing a Excel sheet. The first 2 columns would not allow for changing column type after I import so I created 2 dummy columns in excel sheet then import it. I was able to delete one of the column but the 2nd one I cannot delete in SharePoint. Why and how can I get rid of this dummny column? Thanks.
chapmanjw
Did it assign it as the "Title" column?
ASKER
No, it imports the titles from the excel, dummy1 and dummy2. They're also not Required fields either. It doesn't allow to change the column type and doesn't have a delete option either.
Can you post a screenshot of the column settings for this column as well as the List Settings page that shows the list of columns?
ASKER
Here are the screen shots. Thank you.
The first column in a spreadsheet is designated as the "title" column (the column with the link and drop down menu (but not necessarily named “title”). This column will also be a “single line of text”
On your spreadsheet, place the items that you want to be the "title" into the first column of the spreadsheet, and then create the list. Remember this will be a “single line of text”
On your spreadsheet, place the items that you want to be the "title" into the first column of the spreadsheet, and then create the list. Remember this will be a “single line of text”
ASKER
Sorry but I don't get what you're say.
"as the "title" column (the column with the link and drop down menu (but not necessarily named “title”). This column will also be a “single line of text” "
it sounds like you're say the 1st column is a drop down with menu and then you're saying it's a single line of text.
Also, "The first column in a spreadsheet is designated as the "title" column", do you mean the 1st column in a SharePoint? I mean, Excel doesn't designate 1st column as anything.
Thanks.
"as the "title" column (the column with the link and drop down menu (but not necessarily named “title”). This column will also be a “single line of text” "
it sounds like you're say the 1st column is a drop down with menu and then you're saying it's a single line of text.
Also, "The first column in a spreadsheet is designated as the "title" column", do you mean the 1st column in a SharePoint? I mean, Excel doesn't designate 1st column as anything.
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.