Google Doc Help

[Stormys]

I have been working on a google docs and it is using the formula importxml. The importxml use to work and now its seems to always give me either loading... or #N/A. I am looking for help on fixing this problem.

 

If you have either a fix in either formula based or google apps script(prefered) then you would be a life saver :)

 

=ImportXML("http://services.runescape.com/m=clan-hiscores/members.ws?clanId=31085&pageSize=15&ranking=51","//span['name']")

 

Above, I provide the exact formula.

 

Thanks

[Hedgehog]

I get this error a lot. It appears to be google's fault. Nothing you can do about it, just wait for it to work again.

[Stormys]

I get this error a lot. It appears to be google's fault. Nothing you can do about it, just wait for it to work again.

 

It is back and working now. Great to know I can count on google docs >.<

[Stormys]

A second question, how do I have my importxml auto-refresh update like every minute instead of every hourish(i think)

[Jedlas]

I use a trick to get around that, basically you add a random, changing variable to the URL in a way that doesn't effect it.

I use

=INT(GOOGLECLOCK()/TIME(0;5;0))&GoogleFinance("GOOG")

which should never be the same twice and change every minute at minimum.

So put that in a cell, let's say B1, then you would change your formula to be:
=ImportXML("http://services.runescape.com/m=clan-hiscores/members.ws?random="&B1&"?clanId=31085&pageSize=15&ranking=51","//span['name']")

It will still give the same results, but should force it to stop caching and update every minute.