Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

how do I import my excel worksheet into dataview on a sharepoint site

Posted on 2012-03-28
4
302 Views
Last Modified: 2013-07-22
how do I import my excel worksheet into dataview on a sharepoint site? Right now its just an uploaded document where my users click and it downloads. I would like them to be able to edit this document in the same browser from the sharepoint site.
0
Comment
Question by:sirius7
4 Comments
 
LVL 2

Expert Comment

by:ArticalBadBoy
ID: 37780729
I would try to turn the spreadhseet into a table,  and syncronize with a custom SharePoint list. You could also ask your administrator to turn on XLservices in sharepoint, you could then display the spreadhseet as a webpart where users could edit the data directly.
0
 
LVL 1

Accepted Solution

by:
sirius7 earned 0 total points
ID: 37803246
I clicked the link for list on the left control panel then clicked create and it gave me the option to import into excel.
0

Featured Post

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.

Question has a verified solution.

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

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
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
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

829 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