Solved

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

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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

627 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