Hmm. Does the data type matter? I had to format my X,Y fields to text. Not sure if it's related to my Title column. I had a red message in the settings for my Esri Maps Location column that said I needed to have another column called Title. To remedy this I just renamed a random column 'Title'. Is the actual title column the one with hyper-linked records in it? (Currently my X field)
These are the steps I went through to create the Esri Maps Location column:
-Uploaded an excel spreadsheet (following the guidelines presented in the linked Office help vid: SharePoint lists III: Create a list based on a spreadsheet - SharePoint Server)
-List settings> Create column> checked Esri Maps Location
-Still in List settings, under Location Settings I checked Latitude and Longitude and selected the respective fields from my table (list) in the drop down, Y for Y and X for X
-Clicked OK
I mentioned in another post (which I'm guessing will reappear once GeoNet is setup fully) that my Esri Maps for Sharepoint is version 2.1.1. Is this an issue?