- Convert an old sheet to a new sheet (more on that below); or
- Don't use IMPORTXML, instead create a Google App Script for your sheet.
Here's how to upgrade from an old sheet to a new sheet:
- Figure out if you're using the old or new Google Sheets. Your using the new Google Sheets if there is a small green checkbox in the lower right corner of your sheet:
- If you're using an old sheet, you can manually convert to a new sheet. Currently, the only way to do this is to create a new sheet and copy. This page gives instructions for how to do that.
- There are a few feature differences between the old version of sheets and the new which you can read about towards the bottom of this page. Some things they don't mention explicitly, for example (and this bit me already): named ranges now require the sheet as well as the range name. You used to be able to define a range like "Foo = sheet1!A1:A20" and refer to that range on any other sheet as just "Foo". Now you have to refer to it as "sheet1!Foo" which is kind of a pain (or...maybe there's some workaround I haven't found yet).
My own preference is to write Google App Script for these types of things. Steve Ronuken has a long post here about replacing IMPORTXML with script instead.