Live Data Connector & Excel (no success with larger reports)

Mike L.
Mike L. ✭✭✭
edited 12/09/19 in Smartsheet Basics

I'd like to connect to a report that is 32 columns by 217K rows, but I don't think it's going to happen.  I've tried switching to a newer computer and that increased the number of rows I could pull in but it's still not even close.  I even managed to test 64 bit office with the 64 bit connector but sad to say that didn't do it either.  

Possible Next steps:

- ditch excel for a different tool (Tableau?)

- go into workaround mode (work with smaller reports and stitch them together in excel)

- research the smartsheet pivot app to see if it can handle this amount of data

(I really don't think that this is a large amount of data, am I silly to think this is doable?)

All feedback welcome, thank you!

Comments