?
Solved

How to import spreadsheat into sharepoint list with default spreadsheet view

Posted on 2011-10-07
7
Medium Priority
?
494 Views
Last Modified: 2012-05-12
I'm new to sharepoint. I imported a list from an excel spreadsheet. The imported list will always default to the standard view, but I would like to open the list in spreadsheet view as the standard. When I create a list in Sharepoint I have the option to choose standard or datasheet. I don't see this option when I import the excel spreadsheet.  I also don't see an option to change the list afterwards. How can I accomplish to have the list in datasheet view in the quick launch?

Marcus
0
Comment
Question by:MarcusKoch
  • 4
  • 3
7 Comments
 
LVL 16

Expert Comment

by:jessc7
ID: 36936204
You just need to create a new DataSheet View, and assign it as the default view.

Here is a short video I made after having imported a list from a simple Excel spreadsheet:

http://screencast.com/t/h1pxuIfCe
0
 
LVL 16

Expert Comment

by:jessc7
ID: 36936210
I just noticed another post by you, where it looks like you are using WSS 3.0. My example was Foundation 2010.

The same concept applies, but the steps will be different. Create a new DataSheet View, and assign it as the default view.
0
 

Author Comment

by:MarcusKoch
ID: 36936306
Thanks for the feedback. I know that I can create a second view and then set this as the default, but when I import a spreadsheet I always need to create a second view and teh view menu will display two views to choose from. Since I can still change the view between spreadsheet and standard via the action menu I would like to get rid of the standard view in the view menu.

When I create a new view inside WSS 3 I can have the default be spreadsheet view without having any other view in the view menu.

Marcus
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 16

Accepted Solution

by:
jessc7 earned 1000 total points
ID: 36937250
Can't you just delete the standard view?
0
 

Author Comment

by:MarcusKoch
ID: 36938621
Thanks for that tip. I wasn't aware that I can delete the 1st view. So by design it seems not to be possible to import directly in spreadsheet view. You need to create a second view, set it as a standard and then delete teh old view. Pff, a lot of work for a basic feature.
0
 
LVL 16

Expert Comment

by:jessc7
ID: 36938754
In SharPoint 2010 you can enable inline editing on the Standard view instead:

http://www.youtube.com/watch?v=HHb9dF9mo-g
0
 

Author Comment

by:MarcusKoch
ID: 36938781
Thanks for the tip. Unfortunately our provider won't update WSS3 to Sharepoint Foundation before Feb 2012. But since it is free for us I will stick with WSS3 until then.
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010 do not offer the option to configure the location of the SharePoint diagnostic trace log files during installation.  This can, however, be configured through Central Administr…
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
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Loops Section Overview

850 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