Do you have specific format applied to the cells? Just guessing but I'd be there is some kind of illegal character in the source data that is causing your format to cause an error.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question