Solved

Why can't I change the column type or deleted it after I import the excel sheet into SharePoint Custom Listing?

Posted on 2011-09-02
8
853 Views
Last Modified: 2012-05-12
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.
0
Comment
Question by:lapucca
  • 4
  • 2
  • 2
8 Comments
 
LVL 21

Expert Comment

by:chapmanjw
ID: 36475058
Did it assign it as the "Title" column?
0
 

Author Comment

by:lapucca
ID: 36475085
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.  
0
 
LVL 21

Expert Comment

by:chapmanjw
ID: 36475102
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?
0
 

Author Comment

by:lapucca
ID: 36479357
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:lapucca
ID: 36479358
Here are the screen shots.  Thank you.
0
 
LVL 2

Expert Comment

by:shover
ID: 36479438
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”
0
 

Author Comment

by:lapucca
ID: 36479640
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.
0
 
LVL 2

Accepted Solution

by:
shover earned 500 total points
ID: 36493248
The first column in the Excel spreadsheet will be the column in SharePoint that is linked to the item. This column will be set to a single line of text. You will not have the option to change the column type or delete it.
Based on your screenshot, I would place “Item Requested” as the first column in your spreadsheet, because you have it defined as a single line of text.  

To clarify my comments on the title column, if you were to simply create a new custom list in SharePoint this column would be called “Title” by default and it is a single line of text.  If you place your mouse over the items in this column, you will get a dropdown menu.

titlecolumn.JPG
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now