Type Mismatch on Pivot Table creation

[jomili]

The macro snippet below is a tried and true one I've been using for months. This morning it started giving me an error 13 Type Mismatch on the line beginning "ActiveWorkbook.PivotCaches.Add...". I thought maybe it was having trouble with the used range, so tried adding "ActiveSheet.UsedRange
", but that didn't help. I'd appreciate any insight anyone can provide.

Please Login or Register  to view this content.

[jomili]

I found a cause, but I'm not sure why it's a cause.

In the data source for my pivot, I have a column called "Desc", which orignally contains a 30 character description. This morning I augmented that piece by running a routine that replaces the 30 character description with a paragraph fully describing the item. After that is when I started having the problem.

What's really weird is that WITH the paragraphs in, I can manually create the PT with no problem, but my automation won't do it. Going back to the 30 character description, the automation creates the pivot with no problem.

Any clues as to the "Why" of this would be greatly appreciated.

[jomili]

Okay, I found this one out on my own. The problem was Excel 2003's limits, in this case an apparently undocumented one of having over 911 characters in a cell. I truncated the data, and now I'm rocking and rolling.

Thanks,
John