Solved

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

Posted on 2012-03-28
4
307 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
[X]
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
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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

752 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