I am trying to pull team rosters off a site. Each team has a URL. There seems to be a problem with the header column. I randomly would receive a expression error when attempting to refresh the individual links. I removed the changed types off the headers, then randomly received a cell size error message, see below.
I then attempted to load all URLs in one table. I do not receive any error messages but some teams do not load.
I am wondering if this is fixable or any advice on this situation.
I have uploaded an excel file with the tables, which you can refresh to see the random error that happens.
Thanks in advance for any help.
Hi Joseph,
I was able to complete the refresh without any errors.
What excel version are you using?
I am using the latest version with Office 365.
After you completed the refresh, did you look at the table to the left in the count column, if any teams got flagged with 0 results ? should highlight red.
Hi Joseph,
Refreshed fine for me. I had one zero value in the count (column D) highlighted in red, which was for RUS Dinamo Riga https://www.eliteprospects.com/team/673/dinamo-riga
Mynda
Yup, same issue as me.
I cant figure out a work around.
Anyone have advice ?
I didn't think the red highlighted zero values were the issue. I thought the issue is the error messages you're getting. We can't replicate those, so don't have any advice, sorry.
