.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

Direct Link to a Sharepoint 2010 file from Access, Excel, etc

Posted By:      Posted Date: October 25, 2010    Points: 0   Category :SharePoint

Hi...our organization is upgrading to sharepoint 2010 from an earlier version.  In the earlier version, it was very easy to link to a document in a sharepoint library, from MS Access or Excel.  But now, on 2010 version, simply linking to the URL of the document no longer works.  It's like the file does not really exist in the location noted if you grab a shortcut URL.

Does anyone have any idea how we can continue to link to sharepoint 2010 documents, so all of our nicely linked access and excel processes continue to work

Hopefully I am making sense?



View Complete Post

More Related Resource Links

Link to Traditional File Shares from SharePoint 2010

Forgive me for possibly not using the right terminology.  I'm trying to determine if Sharepoint 2010 supports linking to traditional files shares so they can be presented as Document Libraries inside Sharepoint.  When searching I find lots of info about the capability to map traditional network drives to a Sharepoint Document Library, however that is essentially the opposite of what our customer needs to do.  Instead they want to keep a large repository of files out of a Sharepoint database, but still present it as a document library to their users.  I know that the BDC supports linking to External Data Sources, but I thought that is just for crawling, and searching external data stores.Is it possible to present a traditional file share \\servername\share as a document library (i.e. https://home.widgets.com/Documents/Forms/AllItems.aspx) in Sharepoint 2010?It looks like the capability is there especially because Server 2008 R2 refers to default shares as Libraries.Thanks.Matthew

SharePoint 2010 Export list Items to Excel, wrong url in iqy file

Hi, I have a SharePoint 2010 Environment that uses https://portal.<something>.com. Exporting to Excel of a list uses wrong URL. When I go to the a list, select the list to show the "office ribbon" and then select export to excel, excel will show the error "Excel cannot connect to the SharePoint List". When I take a look at the IQY file that is created it contains the wrong url: http://portal.<something>.com instead of https://portal.<something>.com Changing the URL in the IQY file manualy to https://portal.<something>.com and then opening it will excel is working fine, list data is exported to excel then. Alternate access mapping is configured to use https://portal.<something>.com as default, export to access is working normaly. I already deleted the http://portal.<something>.com alternate access mapping once to see if this fixes the problem. No fix, even not after IISreset or rebooting the server. Where or how is the export to Excel IQY file created and where is it possible to fix the URL it is putting in the IQY file? Grtz, Arjan

Sharepoint 2010 Excel Services Extranet Access


Hi to all,
I've an environment that includes 3 machines: the sp2010 frontend (W2K8 R2), the sp2010 backend (SQL2008 R2), the analysis services backend (SQL2008 R2).

I've successfully setup my environment with Kerberos constrained delegation and the entire thing works fine with both performancepoint and excel services (the requirement was to pass the user's domain identity to the analysis backend): thanks to the excellent SP2010 Kerberos Guide.

Now I've extended this portal to the Extranet zone, assigned it a new host header and upgraded my SPNs to include the new fqdn and also added it to the necessary accounts in Active Directory.

In the intranet environment everything is fine. I've published the Sharepoint site to the external network onto the ISA 2006 and setup the Kerberos constrained delegation from the isa computer account to the Sharepoint SPN.

So here is the point: I can correctly access the Sharepoint site from external with Kerberos authentication, performancepoint is fine but I cannot open excel workbooks from this zone, I already trusted both the file and the data connection locations with the external fqdn but still no luck. Even the sample workbook does not open. The error is "error while trying to execute the requested action. Retry".

Anyone has any hint on the possible causes?

Thanks in

Sharepoint 2010 - Lists not displaying Edit (Link to item) for Users with Edit Only access



I am using Sharepoint 2010.  I have several lists whose view includes the column "Edit (Link to Item)" in the default view.  I am the site admin so when I view the list the "Edit" column appears with the small "paper and pencil" icon and it works when clicked. 

I needed some users to only be able to view and edit existing items (not add or delete).  So I have created a site level permissions that I copied from "Read" and only checked the "Edit Items  -  Edit items in lists, edit documents in document libraries, and customize Web Part Pages in document libraries" under Lists. 

This new permission level does allow users to see the edit menu item on the standard "Title" hyperlink dropdown, but in the"Edit" column there isn't an icon or any clickable link to edit in the column.  Only from the menu.  Its as if the icon won't appear if I don't give them Add capability which is what I don't want.

 Thanks for any tips,






Reading Excel File from document library in sharepoint 2010


On a button click,I want to read a excel file placed in document library in sharepoint 2010.The button is in a visual web part.

I am giving the connection string as:



connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=http://server_name/Doc librar

Using the Excel Services REST API to Access Excel Data in SharePoint Server 2010 (Visual How To)

Learn how to use the REST API to retrieve resources such as ranges, charts, tables, and PivotTables from workbooks stored on SharePoint Server 2010.

Video: Using the Excel Services REST API to Access Excel Data in SharePoint Server 2010 (Visual How

Watch a short video that shows how to programatically retrieve data from an Excel workbook.

ClientAccessPolicy file in SharePoint 2010

I am upgrading my Silverlight demo code from the old beta to beta 2 and see that there are a few new considerations for the deployment of ClientAccessPolicy.xml files. In a previous post I demonstrated how to do this for SharePoint 2007. The heartburn that I get with that approach is any site collection owner or designer can drag the file into the site collection and open the site up to unwanted client access issues. In 2010 the virtual path provider no longer serves the files from the root of the site collection

Usage of Client Access Policy and crossdomain xml for sharepoint 2010>?


Hi Folks,

1.What is Clientaccesspolicy.xml in sharepoint ?

2.What is Crossdomain.xml ?

What is usage of wcf service deploy in sharepoint 2010?

Kindly give me some valuable comments ?


Thank you


Immanuel c


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


Sharepoint 2007 and Excel 2010 features


Does Sharepoint 2007 Server support the new Excel 2010 feaures like slicers? Or do i have to have Sharepoint 2010 to get that working (considering all other components besides Sharepoint 2010 are available in my Sharepoint 2007 environment) ?

- Thanks



Excel file published on Sharepoint


I want to use ExcelServices of MOSS to publish few XLS files.
The problem is if i want to open up the excel file it will not open in the web browser as I expected, altough i already click "Display as web page".
My MOSS instance is on a server without MS Excel installed on it.
The excel file was created using Excel 2003.
Any idea how to fix it?
Thank you very much,

Quick Note: Create Silverlight Applications to Access SharePoint 2010 Data

In this exercise, you will learn how to create Silverlight applications to display SharePoint 2010 lists inside DataGrid controls.

Developer Training: Data Access in Technologies in SharePoint 2010

Learn about the new data access technologies in SharePoint 2010 and how they can help increase your productivity. This training module covers the basics of LINQ handling and how to use the Client OM and REST to access SharePoint 2010 information remotely.

Quick Note (Scenario): Getting Started with Data Access in SharePoint 2010

The goal of these exercises is to give you the steps that you need to access data from various sources by using web development tools and technologies such as SharePoint 2010 and Visual Studio 2010.

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.
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