Hi All,

I am trying to extract data from a PI tag in excel for every second over a 48 hour period. The error I get is that the ‘Outpu t exceeds sheet dimension. Try changing output cell or changing data orientation or decreasing number of events.’ I have tried doing this on a blank spreadsheet and so assume that it means that this is just too many data points? What is the maximum number of points I can extr act at 1 time? I also tried 1s intervals over a 24 hour period and this also did not work. I am able to retrive only 18hrs data, if i try to chage the end date then i get an error "Outpu t exceeds sheet dimension. Try changing output cell or changing data orientation or decreasing number of events"

Thanks Inadvance.

Regards,

Viritha.

Hi Viritha,

Are you using the old Excel workbook format? Pre Excel 2007, a worksheet can only contain 65536 rows. For your query, you will get 172800 rows. So this could be causing the problem.