Why does Google Sheets take so long to load?

Why isn t importxml working in Google Sheets?

I have a web page that has an importxml call in it.

It works fine in my own web page. However, when I try to use it in Google Sheets, it returns an error message saying that the site does not support importxml. What is going on?

Since you say this works on your own web page, but not on Google Sheet, the solution seems to be some kind of security settings on the Google Sheet, or a different web server. The answer to a similar question on StackOverflow suggests that if you set "Always ask for import permission" and try again, it should work.

Why does Google Sheets take so long to load?

I have a Google Sheet in which I keep notes and it's very, very important.

Google Sheets is usually fast enough, but sometimes takes a while to load and then the data won't show up. This occurs even for the basic spreadsheet with only two cells on the first row, one empty and one with "="
I cannot find any solutions on how to speed up the process (even when I restart the computer) or if there is a way that I can force data to appear in the sheet. If you are having this problem with a spreadsheet containing only 2 rows, the data will probably come back if you remove "=". This is the default spreadsheet format, for reference purposes, and you don't have to leave this data if you don't want to. Also, make sure that "All Data" is enabled under Tools - Google Sheets - Resources - Manage. As pointed out by @Mason, "Update All" is the equivalent option for "All Data". This may help speed things up.