Live Data Connector & Excel (no success with larger reports)
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!