PDA

View Full Version : Sleeper: Pivot table summarizing by sum



Ranelle
06-14-2005, 06:34 AM
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
06-15-2005, 10:36 PM
When the data is sent to Excel, is it being evaluated as text by any chance?

Ranelle
06-16-2005, 12:00 PM
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.