Log In
Register
Home
November 15, 2020
Offline
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.
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
Hi Joseph,
I was able to complete the refresh without any errors.
What excel version are you using?
November 15, 2020
Offline
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.
July 16, 2010
Offline
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.....inamo-riga
Mynda
1 Guest(s)
