Connect is stalling on the spreadsheet load

Updated on August 30, 2017 in Connect
2 on August 30, 2017

I’m updating using Connect. This usually works really quickly but today, for some reason it is getting stuck during and showing a message saying Loading…

I’m using a spreadsheet that I have not used before but I don’t think it is any different to previous spreadsheets.

  • Liked by
Reply
0 on August 30, 2017

Hi Gary, 

I’ve seen this before a few times. Connect is a very basic ETL program (extract, transform, load). I think Spider has kept it that way because It really helps with perfomance if there are fewer bells and whistles.

The downside of this is that the spreadsheets have to be ‘clean’. That is, they should only contain row and column data. Calculations are fine, but things like Pivot Tables or Images seem to cause Connect a real problem and it does not provide a helpful warning just the Loading… message.

Check your spreadsheet and remove anything that is not required for the upload.

  • Liked by
Reply
Cancel
0 on August 30, 2017

Brilliant! That was it.  I had a pivot table there which I have deleted, it all works now. Thanks.

  • Liked by
Reply
Cancel