Too Many Different Cell Formats Error – Excel 2007/Excel 2010

This error can arise when you go to paste data at the end of a list where some of the following conditions apply:-
-the workbook was originally a 97 – 2003 xls format workbook,
-covers a large area or has a long list of data,
-cell formatting has been used to provide borders and fill over a large area.
This article discusses the solution.

This error can arise when you go to paste data at the end of a list or in a large spreadsheet where some of the following conditions apply:

PowerPivot for Excel 2010 and SharePoint 2010

On Friday, I was catching up on my podcasts and listing to Hilton Giesenow’s The MOSS Show and in Episode 34 Hilton interviews Pej Javaheri from the SharePoint B.I. team at Microsoft about Business Intelligence and SharePoint.

What got my attention was PowerPivot which is an add-in for Excel or SharePoint that allows you to connect to large tables of data to do pivot table like analysis.

On Friday, I was catching up on my podcasts and listing to Hilton Giesenow‘s The MOSS Show and in Episode 34 Hilton interviews Pej Javaheri from the SharePoint B.I. team at Microsoft about Business Intelligence and SharePoint.

What got my attention was  PowerPivot which is an add-in for Excel or SharePoint that allows you to connect to large tables of data to do pivot table analysis.

PowerPivot Tools as seen on Excel 2010 ribbon
PowerPivot Tools as seen on Excel 2010 ribbon
PowerPivot Window Tools
Tools Shown in PowerPivot for Excel window

Continue reading “PowerPivot for Excel 2010 and SharePoint 2010”

The True Value of Excel Training

I a big part of what I do is Excel training particularly Intermediate, Advanced and custom courses. It is not unusual when you have just finished a demonstration or an exercise using a feature to hear a groan from somewhere in the group, followed by comments like “I could have used this last week doing report x” or “This process will save me x hours every week” or “that will enable me to do a report I didn’t think we could do” .

A big part of what I do is Excel training particularly Intermediate, Advanced and custom courses. It is not unusual when you have just finished a demonstration or an exercise using a feature to hear a groan or a gasp from somewhere in the group, followed by comments like “I could have used this last week doing report x” or “This process will save me x hours every week” or “that will enable me to do a report I didn’t think we could do” .

As an aside, this is when you need the lesser known excel function =gobacktolastweek(1), where the argument or parameter is the number of weeks you need to go back in time, so you can use your new skill and save a bunch of time when you needed it. Continue reading “The True Value of Excel Training”

How to Create Calculated Items in Pivot Tables

Excel 2007/2010 How to Create Calculated Items in Pivot Tables

Calculated Items in Excel Pivot Tables allow you to make categories from existing categories. This Tutorial shoes you how!

Continue reading “How to Create Calculated Items in Pivot Tables”

Calculated Fields in Pivot Tables

The following short movie illustrates preparing calculated fields in pivot tables in Excel 2010. This technique is very similar for Excel 2007. This is the first of a short series on Pivot Tables that I am preparing.

The following short movie illustrates preparing calculated fields in pivot tables in Excel 2010. This technique is very similar for Excel 2007.  This is the first of a short series on Pivot Tables that I am preparing.

Requires Flash Player 9 or better. Continue reading “Calculated Fields in Pivot Tables”