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