Export to spreadsheet is missing in survey list-SharePoint 2010

You can use surveys to ask people what they think about issues, how to improve your processes, and many other topics. You can collect the results by using several different types of questions, such as multiple choice, fill-in fields, and even ratings.

As we use Microsoft excel on quite regular basis and very used to with it, we need to see every application in the excel and makes every desperate effort to view it but now the issue is while exporting survey data to excel, we need that option i.e. ‘EXPORT TO SPREADSHEET’ and this seems to be missing.

How to troubleshoot this issue?

I will brief here number of steps by which you can troubleshoot the issue and let me know me know in case of any queries/questions.

·         You should have office application (Office 2010/Office 2007) should be installed on your client machine.

·         Make sure that 'SharePoint Server Enterprise Site Collection features' should be activated at the site collection level.

·         Are you logged in as site collection admin or site owner? What are your permissions on the site? Also, try opening IE in "Run as administrator" mode and see if that makes a difference.

·         Make sure that you have to check the option (i.e. export to spreadsheet) on a actual survey list and not on a web part

·         make sure that on the Survey page, the view on right-hand corner is set to "Overview"

·         On the actual survey list-make sure the proper view is selected inside the web part options: How to check this:

§  Open the survey list in which you are facing the issue

§  Edit page

§  Modify shared web part

§  Under the selected view option

§  Select 'current view' and click on apply

·         Try saving the survey list as a template and create a new one based on the same

·         try to create a access view/standard view by using the following steps:

§  Go to any list and click on create view

§  Copy that URL

§  Go back to the survey list now

§  Settings

§  List settings

§  Copy the url from the browser (i.e. List=)

§  Paste it in the create view (first step)

§  You will get the create view page

Please let me know in case of any further queries. I would be more than happy to help you as well as resolves your issues. Thank you.

Documents in this folder are not available. This folder may have been moved or deleted, or network problems may be preventing a connection to the server.

Guys,

Today I am going to share the issue that we had resolved yesterday and I hope the following troubleshooting steps will help you to resolve the same problem J

Issue:

While trying to open the document library in explorer view or using “Open with Windows Explorer” option and was getting following error

Documents in this folder are not available. This folder may have been moved or deleted, or network problems may be preventing a connection to the server.

Troubleshooting:

·         Confirmed that it’s a machine specific issue by login user to other workstation.

·         On user workstation, checked and found that the web Client service was not running.

·         From services.msc, changed service startup type to Automatic and started the service.

·         Performed IE Reset.

·         Run Office diagnostics.

·         Rebooted the workstation after every step to verify.

Resolution:

·         Backed up the registry folder "Software".

·         Deleted a folder “Software” under “HKEY_CLASSES_ROOT -> Software -> Microsoft -> MasterAggregatorForIPP -> OleDbHandlers”

·         Run Office Repair

·         Restarted workstation.

If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues J J

Edit in datasheet is missing in SharePoint 2010

SharePoint 2010 is simply fabulous J this version has already comes up with lot of new enhancements and easy to use functionality.

Requirements: Let’s suppose the site collection administrator has decided that he doesn’t want his team members to see the option of ‘edit in datasheet’ for a specific library. If I want to reframe this information in other terms then it would be like this-Site collection administrator wants to hide the ‘edit in datasheet’ option for a document library so that nobody can open it in datasheet view/ nobody can download the data by means of datasheet view.

In sharepoint 2007, it was possible by using some customized coding but in SharePoint 2010, it an out of box functionality and can be easily achieved.

Resolution: Please refer the following steps and your issue will be resolved:

·         Open the document in which you are facing the problem

·         Settings

·         Document library settings

·         Advanced settings

·         Make this option-“Allow items in this document library to be edited using the datasheet?”- Yes

·         Click OK

That’s it and you are done J

Note: it requires full control permissions for the document library or at the site level so that you can see the settings option.

If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues J J

Thank you.

Rating mechanism on blog site SharePoint 2010

I have created one blog site and tried implementing the rating mechanism and successfully used the rating mechanism on blog site template.

Please refer the following steps that i have implemented and let me know in case of any queries. Thank you.

·         On a blog site, under Blog Tools, click Manage Posts.

·         Under List Tools, click List, and then click List Settings in the Settings group.

·         Under General, click Rating settings.

·         Under Allow items in this list to be rated, click Yes, and then click OK.

·         In the top breadcrumb or left navigation, click Posts to return to your list of posts.

·         In the Ribbon, click the List or Library tab, and then click Create View.

·         Click Standard View. If Create View is disabled, you may not have the necessary permissions to create a personal or public view.

·         Click Standard View.

·         In the View Name box, type the name for your view, such as Ratings. Leave the Make this default view check box cleared.

·         In the Audience section, under View Audience, select Create a Personal view or Create a Public view. If Create a Public View is disabled, you may not have the necessary permissions to create a public view for this list or library.

·         In the Columns section, select only the columns that you want in the view and clear the columns that you do not want. To display just the post name and the rating, for example, select the Title and Rating (0-5) columns. You can add other columns you want, such as # of Comments.

·         Next to the selected columns, from the drop-down lists, select the order of the columns in the view.

·         In the Sorting section, select Created, and then click Show items in descending order. This setting will display the most recent posts first in the list, but you customize this setting, such as sorting by the highest rated posts.

·         Under Tabular View, clear the Allow individual item checkboxes checkbox.

·         Under Item Limit, type how many posts you want to display. For example, you might only want to display 5-10 posts if you have several other items to display on your blog page.

·         If you don’t want people to browse through pages of older posts from within this Web Part, click Limit the total number of items returned. This setting prevents the browsing arrows from displaying underneath the rated posts.

·         Click OK to create the view, and then click your blog name in the navigation to return to the blog home page.

·         Click Site Actions, and then click Edit Page.

·         Do one of the following:

Click Add a Web Part in the zone you want to place it.

Click on the page where you want to insert the ratings Web Part. For example, you might want to put it to the right of your posts. In the ribbon, click the Insert tab, and then click Web Part.

·         Under Categories, click Lists and Libraries, under Web Parts, click Posts, and then click Add. The new Web Part appears on the page.

·         To switch to the Ratings view you created, click the down arrow, and then click Edit Web Part. The configuration tool pane appears.

·         Under Selected View, click the ratings view you just created.

·         Under Appearance, type a name for the Web Part, such as Rate recent posts.

·         Make any other changes you want, and click OK.

Lync Server 2010 with supported IP Phones.

Lync Server 2010 with supported IP Phones.

Guys, 

Lync Server 2010 is well known about Conferencing features and it will support many types of IP phones.

Here I will walk through various supported IP Phones.

In Lync Server 2010, a device may refer to any unified communication (UC) device, including headsets and webcams, but the device that is discussed here is the IP phone because it is a managed device.

Phones running Microsoft Lync 2010 Phone Edition allow users to interact with the Lync Server 2010 communication and collaboration features.

Lync Server 2010 supports three types of IP phones:

• Desk phones.These phones are designed to be used by employees at their desk. Desk phones are also

known as information worker or knowledge worker phones.

• Common area phones.These phones are designed to be used in shared areas,such as lobbies, kitchens,

factory floors, and shared workspaces, and can be customized to provide different sets of

Lync Server2010 features.

• Conferencing phones.These phones are designed to be used in meeting rooms.

Desk Phones:

Lync Server 2010 provides options for both IP desk phones and Universal Serial Bus (USB) phones. IP phones provide a broader set of UC features and do not need to be connected to a computer that is running Lync 2010 to provide communication and collaboration features. USB phones require this connection as they are simply an extension of a local Lync 2010 client. IP phones will not allow users to log on unless the users are configured for Enterprise Voice. USB phones allow all users to log on regardless of their configuration. USB phones work for Lync 2010 calls by using the Internet, without requiring Enterprise Voice or a connection to the public switched telephone network (PSTN IP desk phones:

• Aastra 6725ip (new)

• Polycom CX500 (new)

• Polycom CX600 (new)

• Polycom CX700 (OCS 2007 R2 device (with upgrade))

• LG/Nortel 8540 (OCS 2007 R2 device (with upgrade))

Lync Server 2010 also introduces support the following USB desk phones:E ONLY. STUDENT USE PROHIBITED

• Polycom CX100

• Polycom CX200

• Polycom CX300 (new)

• Plantronics Calisto 420

• Plantronics Calisto 540

Common Area Phones

The supported common area phones are:

• Aastra 6721ip (new)

• Polycom CX500 (new)

Because all of the common area phones are IP phones, they do not need to be connected to a computer

to provide Lync Server 2010 UC functionality.

What Is a Hot-Desk Phone?

A hot-desk phone is a common area phone that allows users to log on to their own user accounts. The

features, policies, and settings associated with their user account will apply for as long as the user is

logged on. When the user logs out, the phone provides basic common area phone usage.

Conferencing Phones:

Conference room devices transmit high-quality audio, and those with video capabilities track the person

who is currently speaking. The supported conferencing devices are:

• Polycom CX5000 (audio/video)

• Polycom CX3000 (audio)

Thank you.