Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is it possible to create two different files where in the first I put the data and in the second the references query?

I used IMPORTRANGE but this method gives me "=CONTINUE(A1; 2; 1)"... I want to separate many sheets, to lighten the file, but also keep the references between them. In this file I have foglio1 with the data while sum query is in the foglio2 but I want to have this query in another (different) file.

share|improve this question
"doesn't work" is not very descriptive. In what way doesn't it work? – Al E. May 3 '13 at 13:39
sorry i wansn't too clear ..for example in this case i want to sum a1 and b1 but i whant to put the query in another file .. is it possible? – jack1986 May 3 '13 at 14:01
@jack1986 I have deleted your previous question. In future please edit your original question instead of re-posting. I suggest you take some time to read the FAQ. – codingbadger May 3 '13 at 14:17
@jack1986: Please edit your question to clarify. Comments are impermanent. – Al E. May 3 '13 at 17:44

Yes, it is possible with a construct like so:


and, in New Google sheets, allow permission for the linking. key above is the spreadsheet key (long upper/lower case alphanumeric between forward slashes visible in the URL for the source sheet). Though you can use the entire URL.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.