.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Target audiences not working in excel services web part

Posted By:      Posted Date: September 07, 2010    Points: 0   Category :SharePoint
My appologies i posted this originally in the pre-2010 forum So i'm reposting here: We have recently upgraded to Sharepoint 2010 and we're experiencing problems with the "target audience" field being available to the users. I am not the CA admin though so it'll make this a bit tough to get solved if the problem is there. What i'm looking for are the suggestions of things for me to forward to the CA admin to change or check if anything. We have a seperate Virtual Machine that is running 2010 that has this option available to users on that farm for some reason. however on our corporate farm we don't have that option available. Plus on top of this the quick launch items are not working with audiences as well to turn off the headers to links that have nothing in them due to security trimming on document libraries. I'm hoping that this being a more of an overview of things to check would help others who may have this problem as well. I've seen resolutions such as rebooting the server and such, however that's a bit lower level and we need some higher level things to check that may resolve the issue. Think the simple stuff first to check and lets work down the list. Doesn't matter how stupid it is but can we get a more compiled list of things to check to make sure that target audience visibility to users is enabled? Thanks!

View Complete Post

More Related Resource Links

Target Audiences not working


Microsoft Office SharePoint Server Enterprise 2007 Version:

I created a Target Audiences for a Security Group that I created for a Pilot program that is being kicked off.  I only want the Security Group to see it.  I logged onto the site as a member OUTSIDE of the Security Group and I still saw it.  I have the example below, with the security group from Active Directory.  Any reason why it would not work?

Below is an Announcement on our Corporate Intranet site for educating users on Information Technology and computer related items.  It is a portal that we would like them to go to, to get all of their information.  I have yet to break up items based on Target Audiences, but now I think it might be a great time, as I have a way to use it that will be around for a few weeks.

Title Test  
Body Test
Expires 8/25/2010  
Target Audiences Security Pilot Group


Thank you.


Protect part of Excel sheet via Excel Services


Is it possible with Excel Services or other Out Of the Box standard features, to create a functionality as below description.

"Make an Excel sheet frozen/not editable on existing row but at the same time let users be able to create new rows, populated with a running numberid preferable in Sharepoint somehow?" 

//Best regards

Excel services wont display in web part, fails with a Event ID 5239

After upgrade to SP2 and current Cum SP, no sites in my portal taking advantage of Excel services can function.

checked event log and found the following

Event Type: Error
Event Source: Office SharePoint Server
Event Category: Excel Services Web Front End 
Event ID: 5239
Date: 10/15/2010
Time: 1:50:52 PM
User: N/A
There was an error in communicating with Excel Calculation Services http://BLAHBLAHBLAH:56737/SharedServices1/ExcelCalculationServer/ExcelService.asmx exception: The request failed with HTTP status 403: Forbidden.
[Session: (null)
User: SHAREPOINT\system].

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Any help is greatly appreciated, thanks.

The Working Programmer: Going NoSQL with MongoDB, Part 3


Wrapping up his examination of MongoDB, Ted Neward discusses predicate queries, aggregate functions and LINQ support, and provides some tips on hosting the NoSQL database in a production environment.

Ted Neward

MSDN Magazine July 2010

The Working Programmer: Going NoSQL with MongoDB, Part 2


Ted Neward continues his dissection of the alternative MongoDB database system, using exploration testing to investigate the underlying technology.

Ted Neward

MSDN Magazine June 2010

Excel Services: Develop A Calculation Engine For Your Apps


The Excel Services architecture lets users design their own algorithms and share workbooks on a server.

Vishwas Lele and Pyush Kumar

MSDN Magazine August 2007

Excel: Integrate Far-Flung Data into Your Spreadsheets with the Help of Web Services


Excel 2003 lets you dynamically integrate the data provided by different Web services. It also lets you take advantage of the latest capabilities in Office 2003 to customize list views, graphs, and charts, and to catalog bulk items online or offline. Find out how you can makle the most of the data returned from your Web services with the Office 2003 Web Services Toolkit API.

Alok Mehta

MSDN Magazine February 2005

Web Parts: Use Windows SharePoint Services as a Platform for Building Collaborative Apps, Part 2


Microsoft Office SharePoint Portal Server 2003, which is part of the Office System, lets you create and manage virtual servers, site collections, sites, workspaces, and users. You can also use the Windows SharePoint Services object model to design and implement user-targeted applications. In the second part of a two part series, the authors take a look at the WSS and SPS object models, Web Part Page anatomy, creating and deploying Web Parts, and Web Part security. They also discuss Web Part infrastructure and how to create custom Web Parts.

Jason Masterman and Ted Pattison

MSDN Magazine August 2004

In sharepoint excel working fine in office 2007 but not in office 2010


Hi All,

we receive error  while trying to create excel sheet using the template we have uploaded on the SharePoint 2007.


This occurs on a machine that has Office 2010 installed. Earlier the machine had Office 2007 and everything was working fine.


Can you let me know why is problem is coming and how to resolve this.



Sanjeev Tiwari


Targeted Audiences not working


I am looking to fix my Targeted Audiences on my Intranet Site.  Prior to SP2, I was able to choose SharePoint groups within the Targeted Audiences on web parts, left navigation bar, etc.  I no longer see any of the SharePoint groups. ("There were problems searching audiences. please contact the sys admin") I can see Global and Distribution/Security groups.  After researching, I found a hotfix that states:

"After you install the updates that are described in Microsoft Knowledge Base articles 952294 and 946517, Microsoft Office SharePoint 2007 audience targeting stops functioning for nested SharePoint groups for global navigation and for any SharePoint group audience targeting for Web parts. The navigation links and Web parts in these cases are not visible at all. Therefore, they are inaccessible to the user targeted."


This makes perfect sense, because it is only on my Intranet site (nested groups) where I am having issues.  Other site collections are working fine.  <

SharePoint 2010: Excel Services Resource Center

Are you looking to learn about Excel Services programmability capabilities? Learn about Excel Web Services, UDFs, the Excel Web Access Web Part, REST, and ECMAScript support.

Consuming External Data Using SharePoint Server 2010 Business Connectivity Services and an Excel 201

Learn how to use BCS in SharePoint Server 2010 to access and update external data by using Microsoft Excel 2010 as a client.

Sample: Business Connectivity Services Excel 2010 Add-In

Download a sample add-in that shows how to use BCS in SharePoint Server 2010 to access and update external data by using Microsoft Excel 2010 as a client.

Developing Applications in SharePoint 2010 Using Word Automation Services and Excel Services

Learn about the new client services features that are available in SharePoint Server 2010, including Word Automation Services and Excel Services.

Sample: Developing Applications in SharePoint 2010 Using Word Automation Services and Excel Services

Download sample code that demonstrates the new client services features that are available in SharePoint Server 2010, including Word Automation Services and Excel Services.

Interacting with the Excel Web Services API for SharePoint Server 2007

Get a quick start with the Excel Web Services API, which enables interaction with published Excel 2007 workbooks in SharePoint Server 2007 from a remote application. Learn considerations around session state, security, and performance.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend