Wednesday, May 7, 2014

The workbook cannot be opened - Excel File SharePoint

Whether you open a excel file in SharePoint the following message appear "The workbook cannot be opened"

You have to do these 2 steps:
  1. Run Powershell commands
    1. $w = Get-SPWebApplication -Identity http://portal
    2. $w.GrantAccessToProcessIdentity("domain\ServiceAccount")
  2. Restart IIS iisreset /noforce

The breapoint will not currently be hit. No symbols have been loaded for this document.

Hi Folks,

One day in the morning I keep getting this error: The breakpoint will not currently be hit. No symbols have been loaded for this document.

I asked for help on a Microsoft College and He simple did "nothing". After 30 minutes it started to work and the only different thing he done was this:
Solution:

  1. Go to Menu build -> Configuration Manager
  2. In the Active Solution Configuration, select Release (or Debug if you had Release). Close
  3. Do a Clean Solution then a Build Solution
  4. Switch back to to Debug (or Release if you had Debug).
  5. Now if you deploy the error will go away.

Hope it helps for you folks

Allow anonymous access to internal, external or other network

Best Practices for allowing anonymous access to an existing Web Application or Portal.

NOTE: If you go straight and allow anonymous access on your Web Application, all users will have to click Sign In.

In spite of allow anonymous access to your web application and site collection, you should extend your web application and create a new IIS site with new hostname and then allow anonymous access


That’s is the right way because if you do all at the same web application users within intranet will not automatically authenticate in your Portal.

Trade-off: The problem is when you separate the same Site in two or more hostnames. Forms can only be submitted to one URL, so you must choice which one. That's the trade-off.
If you have a solution for that, I really appreciate your share.

Thank you.