Run-time error '-2147418105 (80010007)' Automation error

[alhaas]

This is driving me crazy!

When trying to get a median in column by roll up, I keep getting the following error message immediately after attempting the roll up:



This does not happen when I do the same thing for other counties.  It is very frustrating.  I have tried re-downloading, and have updated the information. I even tried renaming the file.   Anything related to this county has the same problem.  There are no empty cells in the data.  I need to get my work done!!!  This is the feature that got me to purchase the software.


Thanks for any help,
alhaas

[DigDB Support]

Please send us the data file that's causing this problem. It doesn't look like related to DigDB.

[alhaas]

I found out what the problem was.  I use Excel 2007.  The number of rows in DigDB is still limited to pre-Excel 2007 row limits.  My file had approximately 104,000 records.  Once I split the file in two, with each below the 65,000ish row limit of previous Excel versions, I was able to get Median Roll up to work.  

Will there be a fix for this?

Thanks,
alhaas

[DigDB Support]

Thanks for the note. We will add that support in a month or two. For now, you did the right thing.

[excap]

Same issue here, I look forward to the new release!