K
keeena
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.
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.