A
A.S.
In some instances when I recalc DSUM tables in very large
spreadsheets, the DSUM table will insert a random number
(often a value of "10") into a cell of the DSUM table,
rather than the data it is supposed to be referencing.
When I clear the range and rebuild it, it pulls the data
correctly into the table.
There is no rhyme or reason to this occurring. There is
no corruption that I can detect.
Any ideas as to what might be causing this, or what I can
do to prevent it? Is this a known bug?
spreadsheets, the DSUM table will insert a random number
(often a value of "10") into a cell of the DSUM table,
rather than the data it is supposed to be referencing.
When I clear the range and rebuild it, it pulls the data
correctly into the table.
There is no rhyme or reason to this occurring. There is
no corruption that I can detect.
Any ideas as to what might be causing this, or what I can
do to prevent it? Is this a known bug?