Archive for luglio 2011

EXCEL 2007 – mostra formule e dipendenze

 Formule: Mostra/Nascondi (Show Values/Formulas)

Formule:Dipendenze (Show dependencies)


  • Show values/formulas:Ctrl `
  • Select cells directly referred to by selected formula:Ctrl [
  • Select cells referred to by selected formula:Ctrl-Shift {

Categorie:MS Office Tag:

Sharepoint – Tools utili per la gestione e la migrazione della farm

Tools utili Farm Management e Governance:

SPSFarmReport: disponibile per SP 2007 (32 bit) e per SP 2010 (64 bit)
Restituisce un dettagliato report della farm in formato html

SharePoint Manager (2010, 2007)
The SharePoint Manager is a SharePoint object model explorer. It enables you to browse every site on the local farm and view every property. It also enables you to change the properties.

SPDev Utility: SharePoint Developer Utility
Check for any orphaned features

SPDev.exe -o FeatCheck
Check for any orphaned features. (Features that are enabled but no longer installed on the server/farm)

SPDev.exe -help FeatCheck

Esempio (per visualizzare feature attive in tutta la webapp, feature attive in siti e sottositi):
SPDev.exe -o FeatCheck -url http://<myWebapp>/  -scope webapp -allsites -allwebs

SharePoint Feature Administration and Clean Up Tool
Find faulty FeatureDefinitions and cleanly uninstall them.
Find Feature remainders in Sites, SiteCollections, WebApps and in the Farm, from e.g. forcefully uninstalled Features from farm without deactivating them before, causing errors.
Also, de-/activate Features Farm wide.


Resource Page Description
In some situation the STSADM command STSADM.EXE -o deactivatefeature is not able to deactivate a feature either on site collection or on site level.
This can (e.g.) happen if the feature definition for the feature that has to be removed is not installed in the farm.
This tool allows to remove the feature from the site or site collection completly.

WssRemoveFeatureFromSite -scope (site|sitecollection) -url <url-to-site> -featureid <featureid> -force
(Last edited Apr 12 2008 by Stefan Gossner, version 2)


Show List and View GUIDs (A little GUID picker)
Displays information and mappings  about “List Name – Guid” on a given website.
Installation not required.

Categorie:SharePoint Tag: