Solved

Sharepoint and Excel Validation List

Posted on 2009-04-08
2
515 Views
Last Modified: 2012-05-06
I have an excel sheet that I would like to put into sharepoint.  This excel sheet consist of validaiton list that reference other worksheets and give a drop down on the main view.  I would like to have this same option once I get into sharepoint.

I have uploaded the EXCEL document.  I'm looking for a way to put this into sharepoint, as a link list, and have the same functionality.
Template.zip
0
Comment
Question by:securitythreat
2 Comments
 
LVL 15

Accepted Solution

by:
dp_expert earned 500 total points
Comment Utility
You will not get the same functionality, but can get close.
First you need to create sharepoint list from the other worksheets that are referenced in the main one. Then create list based on the excel and use lookup columns to get data from the other lists.
You cannot get the lookup data from excel sheets - you need to convert them to list.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

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…
The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

743 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