Cannot open the excel files in Sharepoint 2010

Its not a issue actually its just a setting that has changed may be after Migration to 2010.

Issue : Users cannot open excel files in SharePoint 2010 from the Library and get an error

This workbook cannot be opened because it is not stored in an Excel Services Application trusted location.
To create an Excel Services Application trusted location, contact your system administrator

Normally what we tend to do is we will go to the administrator and ask him to add the library to the trusted location .

Not need . No setting to be made on the server it is just a Library setting which can be changed from the site itself . Until you want to use excel web services ( Please make a note of this )

Cause : By default the files are designed to open in browser . So it is checking for trusted location   

Resolution :  

=> Go to the Library
=> On the top click on Library and go to Library settings .
=> Under General settings you will find Advanced settings 
=> Over there you will find the option which by default is set to open in Browser 
=> you need to set it to Open in Client and there you go . 
=> Click OK and you are done .

Hope it helps and you don't disturb the administrators :)     
 

My Links missing in SharePoint 2010 after Migration

We have just Migrated to 2010 and get a lot of tickets on this issue .

In MOSS 2007,  we are used to seeing a link in a drop-down box at the top right of our SharePoint sites, called My Links. At first glance, it seems that this functionality has been removed from SharePoint 2010. It’s still there but with a different name (Quick Links) .

How to retrieve the Lost my links from the 2007 site after migration to 2010 ?

Modifying a SharePoint Database is NOT SUPPORTED. Some would even argue running this select query against a database is not supported. Sometimes people want info out of the DB not excuses.

Disclaimer : Take all the required backups before you make any changes

1. So the first thing you need to do is figure out what profile database you need information out of. To do that you go to Central Admin.
2. Now Click Shared Services Administration from the quick launch.
3. From this screen hover over the appropriate SSP name, click the drop down arrow, and choose Edit Properties.
   
   
4. Now find where it says SSP Database. This your Database Name.
5. Now you need to open a SQL Query Window using the SQL Management tools
6. Then run the query below – Remember to replace the Use statement with your database name from step 4

Use SharedServices1_DB

Select

UP.NTName,

UP.PreferredName,

UP.Email,

UL.Title,

UL.URL

From

UserLinks UL inner join UserProfile_Full UP on UL.recordId = UP.recordID

Courtesy - Shane Young  

Ref : http://msmvps.com/blogs/shane/archive/2007/11/21/finding-my-links-in-the-database.aspx.

How do you get My Links back?

Libraries

In a library, go to the Library tab in the ribbon. 
Click the Connect to Office button.  This is the interface to add or remove a link to the library to the list of “My Links”, as well as to manage this list of links.

When you click Add to SharePoint Sites, this library is not only added to your own personal list of links, but it is added to all of your Office suite of applications, on the “Open” and “Save As” screens.

When you click Manage SharePoint Sites, the following screen is displayed, with a list of your whole list of links:

Where is my links on my Mysite ?

Go to your My Site and click on My Content at the top.  Click Site Actions, Edit Page, and click to Add a Web Part.  In the Recommended Items category of web parts, click to add the My Links web part to the page.  There it is!  Right click on the My Links web part title, and copy that URL to the clipboard.

If you want the My Links link to be more obvious and accessible, though?  Yes, there’s a way to do that also, although it still won’t be the same as it is in SharePoint 2007.  It entails adding My Links to the Personalization Site Links in the User Profile Service Application.

1. In Central Administration, click Manage Service Applications.
2. Click the User Profile Service Application.
3. Click Configure Personalization Site.
4. Click New Link.

1. Your URL will look something like that.  In this scenario, I have a web app just for the my sites.  Fill in an owner because that field is required.  Leaving the Audience field blank means that this link will be shown to everyone.

Now, when users are on their My Site, My Profile, My Content, they will see this:

http://www.sharepoint911.com/blogs/laura/Lists/Posts/Post.aspx?List=daba3a3b%2Dc338%2D41d8%2Dbf52%2Dcd897d000cf3&ID=66&Web=dbb90e85%2Db54c%2D49f4%2D8e97%2D6d8258116ca0

Uploading EXE files on Sharepoint site

By default, many file types are blocked, including file types that are treated as executable by Internet Explorer. Each Web application maintains a list of blocked file types that is based on file name extensions.

Please refer the following file extensions that are by-default blocked in SharePoint 2010 [Recommended by Microsoft]

I would like to tell you that this is not a SP limitation and we can allow any file types to be uploaded in SharePoint but not necessarily a great idea. Storing .EXE files in SharePoint can cause some serious security issues. Just imagine if a user wants to upload a .exe with a friendly name like "Gtalk.exe" but it’s really a virus - not good!.

SharePoint is definitely not the place to store everything, .EXE files being one of those things.

My suggestion:  If we are intending to have .exe files (or scripts etc.) stored in a SharePoint system, then at least put them inside zip files and allow .zip files to be uploaded rather than .exe files. This will mean that while the .exe files are still available, more effort will be needed to start them. Future prospect: Many benefits, Less pain J

SharePoint isn't a file share, it's web application.

Considering internal as well as external point of view: If you are accessing these internally only, we could keep them on a file share and just link to them from the SP site. This will execute outside of the browser instance in this case, but won’t work for outside users, unless you publish file shares via something like UAG (Unified Access Gateway).

File name extension	File type
.ade	Microsoft Access project extension
.adp	Microsoft Access project
.app	Application file
.asa	ASP declarations file
.asmx	ASP.NET Web Services source file
.asp	Active Server Pages
.bas	Microsoft Visual Basic class module
.bat	Batch file
.cdx	Compound index
.cer	Certificate file
.chm	Compiled HTML Help file
.class	Java class file
.cmd	Microsoft Windows NT command script
.com	Microsoft MS-DOS program
.config	Configuration file
.cpl	Control Panel extension
.crt	Security certificate
.csh	Script file
.dll	Windows dynamic-link library
.exe	Program
.fxp	Microsoft Visual FoxPro compiled program
.hlp	Help file
.hta	HTML program
.htr	Script file
.htw	HTML document
.ida	Internet Information Services file
.idc	Internet database connector file
.idq	Internet data query file
.ins	Internet Naming Service
.isp	Internet Communication settings
.its	Internet Document Set file
.jse	JScript Encoded script file
.ksh	Korn Shell script file
.lnk	Shortcut
.mad	Shortcut
.maf	Shortcut
.mag	Shortcut
.mam	Shortcut
.maq	Shortcut
.mar	Shortcut
.mas	Microsoft Access stored procedure
.mat	Shortcut
.mau	Shortcut
.mav	Shortcut
.maw	Shortcut
.mda	Microsoft Access add-in program
.mdb	Microsoft Access program
.mde	Microsoft Access MDE database
.mdt	Microsoft Access data file
.mdw	Microsoft Access workgroup
.mdz	Microsoft Access wizard program
.msc	Microsoft Common Console document
.msh	Microsoft Agent script helper
.msh1	Microsoft Agent script helper
.msh1xml	Microsoft Agent script helper
.msh2	Microsoft Agent script helper
.msh2xml	Microsoft Agent script helper
.mshxml	Microsoft Agent script helper
.msi	Microsoft Windows Installer package
.msp	Windows Installer patch package file
.mst	Visual Test source files
.ops	Microsoft Office profile settings file
.pif	Shortcut to MS-DOS program
.prf	System file
.prg	Program source file
.printer	Printer file
.pst	Microsoft Outlook personal folder file
.reg	Registration entries
.rem	ACT! database maintenance file
.scf	Windows Explorer command file
.scr	Screen saver
.sct	Script file
.shb	Windows shortcut
.shs	Shell Scrap object
.shtm	HTML file that contains server-side directives
.shtml	HTML file that contains server-side directives
.soap	Simple Object Access Protocol file
.stm	HTML file that contains server-side directives
.url	Uniform Resource Locator (Internet shortcut)
.vb	Microsoft Visual Basic Scripting Edition file
.vbe	VBScript Encoded Script file
.vbs	VBScript file
.ws	Windows Script file
.wsc	Windows Script Component
.wsf	Windows Script file
.wsh	Windows Script Host settings file