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. Continue Reading
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” . Continue Reading
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. Continue Reading