Differences between Excel 2010 features in Excel and in the browser

SharePoint 2010 has feature called “Office web app”, I have already explained about office web app in this post: http://sanketinfo.blogspot.com/2011/07/how-to-install-office-web-app-for.html

With Office web app, we can open Microsoft application in browser; still there are some features which are not available in browser view. Here is link which talks about differences for Excel 2010 in excel client and in the browser: http://office.microsoft.com/en-us/excel-help/differences-between-using-a-workbook-in-the-browser-and-in-excel-HA010369179.aspx

PowerPivot for Microsoft Excel 2010

Download link for PowerPivot for Microsoft Excel 2010: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=7609

Alternate solutions for automatic workflow history clean up – MOSS 2007

By default in MOSS 2007, workflow task history list values are being cleanup/deleted every 60 days, so we can’t audit data based on workflow history list, this is very known concern for SharePoint.

Here are some links which talks about different workaround for automatic workflow history cleanup: 

http://blogs.technet.com/b/officeasia/archive/2010/11/28/workaround-for-the-situation-that-sharepoint-auto-cleanup-job-deleted-workflow-history.aspx

http://technet.microsoft.com/en-us/library/cc424956(office.12).aspx

http://vspug.com/drewdevo/2008/08/27/workaround-for-missing-workflow-history/

We can also go with custom solution in which we can design database structure for storing workflow history data. Then from database we can populate and retrieve data to display into OOB workflow history page.

How to deploy custom master page using solution package in SharePoint 2010

Microsoft provided many great features and functionality into Visual Studio 2010 for developing any solutions for SharePoint 2010, with Visual Studio 2010 we can create and mapped 14 HIVE folders very easily.

Microsoft provided very detailed and step by step guide for how to create and deploy any branding solutions using Visual Studio 2010 for SharePoint 2010.

http://msdn.microsoft.com/en-us/library/gg447066.aspx

One more good reference link: http://sharepointchick.com/archive/2010/03/26/deploying-a-custom-master-page-in-sharepoint-2010.aspx

SharePoint 2010 Branding – Master Page

As we all know that MOSS 2007 master page is not going to work properly with SharePoint 2010, in other way it is always good to create new master page for SharePoint 2010, there are some changes in placeholder name for 2010 master page and some new placeholder introduced in 2010 master page like ribbon tag, etc..

V4.Master is default master page for 2010; codeplex also has provided starter master pages for 2010 which will be very useful.

Here are some very good links to follow for starting creating master page for SharePoint 2010, links has detailed information regarding from where to start and how.

http://www.sharepointedutech.com/2011/01/24/sharepoint-2010-branding-series-part-two/ 

http://startermasterpages.codeplex.com/ (codeplex master pages)

http://sharepoint.microsoft.com/Blogs/GetThePoint/Lists/Posts/Post.aspx?ID=386

Here is link for SharePoint 2010 CSS reference names: http://sharepointexperience.com/csschart/csschart.html

Good Luck with master page designing :)