Hi
A user has a problem viewing a cube in Excel’s pivotTable.
He want’s sales-data from this year (Jan till Jun). When getting data
from this long period it keeps showing ‘#VALUE!’ in every field.

If I make a smaller selection (smaller period i.e. May till Jun)
everything looks fine.

Excel:
Excel runs inside another program using the MS Office Web Components.

Cube-data:
The data is a dataset from an SQL-server, that is used as base for the
temporary Cube (The connection between the SQL and Excel is coded in
VB.net).
It is not a cube from the analysis server.

When working with a normal cube the text ‘#VALUE!’ indicates that the
data the cube is based on is changed, but when it’s an SQL-query it
shouldn’t change once the query is done with.
Btw. It takes approximately ½ hour to get the data from the SQL-server
and into the temporary cube.

Does anyone know what might be wrong?
Any idea is mostly welcome. I don’t have access to the VB-code.

Thanx for the help in advance.
Kristoffer