Looking up SharePoint list data in an Excel Template

Posted on 2011-04-18
Medium Priority
Last Modified: 2012-05-11
I have a custom content type in a document library based on an Excel Template.

I created a purchase order form.

I would like to reference a SharePoint Contact list I have for vendors, ideally in a dropdown list on the form.

Can this be done?

I have other dropdown lists on the form but I created those with a hidden sheet of LISTS.
Question by:sullisnyc44
  • 2
LVL 50
ID: 35419706

is the user interface a SharePoint form or an Excel form/spreadsheet?
LVL 16

Accepted Solution

jessc7 earned 2000 total points
ID: 35419772

Author Comment

ID: 35424903
It's an excel Spreadsheet
LVL 50
ID: 35428168
You could link the contacts list in another (hidden) sheet of the workbook and then reference that sheet.

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

864 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