Solved

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

Posted on 2012-03-28
4
293 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

895 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

18 Experts available now in Live!

Get 1:1 Help Now