Help: Pivot Cache error using Range object containing cell with 255char
 

User gets Error number 13 - Type Mismatch when calling the
PivotCache.Add method under the following condition: supplying a Range
object as the SourceData input parameter when that Range object
contains 1 or more cells with 255 characters.

The issue reproduces 100% of the time. Is this a known issue?

Interesting notes:
1.) The Range object itself appears to be OK when it contains one or
more cells with 255 characters appears. I can retrieve standard
properties of the object. The object seems perfectly valid.

2.) The PivotCache.Add method will work fine with the same source data
range (e.g. 1 or more cells 255 chars) *IF* the SourceData input
parameter is supplied as String (e.g. "Sheet1!A1:Z1000") instead of a
Range object.

So its not as if the PivotCache has problems w/ the data
size...there's just something odd when you use the Range object to
identify the range.

It occurs in both both 2K3 SP2 and 2K7 (VBA). I'm looking for
thoughts...hopefully a known issue (please provide KB article). Not
quite sure how to file issue to MS.