Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Excel Spreadsheets to SharePoint

Posted on 2011-03-14
5
Medium Priority
?
653 Views
Last Modified: 2012-05-11
Looking for the best option for a customer who has massive and extensive Excel Spreadsheets.  I'm somewhat familiar with importing and using them in Sharepoint.  My previous experience with this was that certain functions within Excel [color coding, etc] did not exist within sharepoint but perhaps this has changed, etc.

This would be a hosted solution.  I'm also receptive to potentially using Google Apps.  The biggest thing for the customer is being able to access them with relatively decent speeds over a 3/4G Card as they are very mobile sales people.

Input/Suggestions greatly appreciated.

Thanks!
0
Comment
Question by:BGTSLLC
  • 3
  • 2
5 Comments
 
LVL 6

Accepted Solution

by:
ThatSharepointGuy earned 2000 total points
ID: 35130835
I've done this before, following something that Sahil Malike posted on his site: http://blah.winsmarts.com/2007-3-SharePoint_2007__Excel_Services_-_A_Quick_Introduction.aspx

It should be the same with SP2010.  Just open Excel, click the Office button in the top left-hand corner, browse to Publish > Excel Services and fill out the info.   It should set up everything up, and you can choose options for it.

Your speed issues will depend on what connection he or she is getting from the provider (just because he/she has a 3/4G card, doesn't mean they'll be going at 3/4G, if the provider is only running general 2G-level speeds, etc), and the bottleneck coming into/out of your network.

There is also a solution from Bamboo if you are looking for a simple 3rd party app for bulk copying documents, etc.  http://store.bamboosolutions.com/pc-36-6-list-bulk-import-available-late-august.aspx
0
 
LVL 4

Author Comment

by:BGTSLLC
ID: 35131040
I quickly read through the winsmarts link; very informative and thank you.

Question:

1.  Customer doesn't have a server so would I be using the Excel Services within a Hosted Solution from a 3rd party?

Heck the Excel Services would do alot of what they need but I just want to make sure it works within the parameters of a Hosted Solution and that part I wasn't sure I was getting from it.

Please advise and thanks!
0
 
LVL 6

Expert Comment

by:ThatSharepointGuy
ID: 35131166
No problems, BGTSLLC.  You posted this in the SharePoint category, so I assumed that you had a SharePoint environment up (or were going to build one in the near future).  If it's a hosted SHAREPOINT solution, then you should definitely have access to Excel Services, but I would contact them to be sure of that.  It might come free with your hosting plan, or you might have to pay extra for it...that would be entirely up to the service hosts.

And unfortunately, I've never had any experience with hosted solutions (nor have I had the opportunity to set it up within SharePoint, either...although it sounds like an interesting learning process).

Wish I could recommend one to you, but sadly I have no experience in that area.
0
 
LVL 4

Author Comment

by:BGTSLLC
ID: 35131191
My bad on the incorrect category - linear thinking [if it's sharepoint then it goes into sharepoint] but that's not always the case.

Your other post was still most helpful and steered me in the right direction.

Yeah the whole Hosted side of this deal holds the potential to be a very interesting path.  Life and learn!

Thanks!
0
 
LVL 6

Expert Comment

by:ThatSharepointGuy
ID: 35131428
Great, glad to be of service!  I'd say, let me know how it goes...but there's no way to communicate through messaging on E.E. ;-)  The best of luck to you!
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
Viewers will learn a basic data manipulation technique of unpivoting data in Power Query for Excel 2013 and the importance of using good data. Start with data in a poor structure: Create a table on your data: Unpivot columns: Rename columns: …
Viewers will learn how to share Excel data with others from desktop Excel, as well as Excel Online via OneDrive, and embed an Excel file on a website.

885 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