Sleeper: Pivot table summarizing by sum

[Ranelle]

hey,

i have an asp .net program that sends a datagrid to an exisiting excel worksheet. in that worksheet, i have a pivot table set up.
problem is, the column of data that i use for the data field in the pivot table, isnt being reflected when i summarize by sum. i get only 0's.
the only ways i can get the values to show is if i manually re-enter the number in each cell of that column or if i do something like

dim oldVal as integer
oldVal = myData.cells(2,8)
myData.cells(2,8) = oldVal

i'd like to know if there's a more efficient way of solving this problem because the worksheet has ALOT of data rows.

thanks in advance.

[geekgirlau]

When the data is sent to Excel, is it being evaluated as text by any chance?

[Ranelle]

probably. even though the values in the datagrid are of type integer.

i've decided to just loop through each value with the code i posted above. its working fine thus far with it.

thanks anyway.