Wednesday, August 14, 2013

Create redirect for Top Visitors Metrics Report



This is related to Url redirection for the TopVisitors link from the Site- Web analytics reports .
 Url :/_layouts/WebAnalytics/Report.aspx?t=SummaryReport&l=sc  and please click on “TopVisitors”  link from the left hand side quick launch.( provided access to all of you on this site )

From the Out of the box features of IIS, implemented the redirecting the Top visitors link to “The Webpage cannot be found”. This will applicable to entire web application level.




unable to view workbook1.xlsm excel


workbook1.xlsm  excel is containing unsupported features to render in SharePoint.

They are:

Ø  Macros Enabled
Ø  Sheet Protection
Ø  File format should be - .xlsx not xlsm

Disable Macros in excel 2010:
  Click the Microsoft Office Button , and then click Excel Options.
  Click Trust Center, click Trust Center Settings, and then click Macro Settings.
  Click the options that you want:
  • Disable all macros without notification Click this option if you don't trust macros. All macros in documents and security alerts about macros are disabled. If there are documents with unsigned macros that you do trust, you can put those documents into a trusted location. Documents in trusted locations are allowed to run without being checked by the Trust Center security system.
  • Disable all macros with notification This is the default setting. Click this option if you want macros to be disabled, but you want to get security alerts if there are macros present. This way, you can choose when to enable those macros on a case by case basis.
·         Change the file Format name from XLSM to xlsx:
·              Save the File format from .xlsm to .xlsx

Unable to view "View Workflow Reports"


Issue Description:
----------------------
Error loading the template {guid} for the Cancellation & Error Report report.

Error:  Value does not fall within the expected range.

Resolution:
--------------

After investigating, found that the issue was happened due to the reporting feature in the Site collection.

Deactivate and activate the Reporting service within the Site collection level,  will  allow to display all the reports related to workflows.