CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
Shubham_Lohia
Shubham_Lohia

Reputation: 19

ImportRange Not Working Properly - Google Sheets

I am trying to import data for range A1:J from the sheet named "BODY COVER STOCK" using ImportRange function the first Column shows NA and Column H,I,J shows blank under headings. Can anyone help me out in finding where I am going wrong with this.

Data SpreadSheet link - https://docs.google.com/spreadsheets/d/1HzSslzdKFtbxEdPQPX5Ox0Cq2NNaqRViYX3ookQ4I1w/edit#gid=0

Target SpreadSheet Link - https://docs.google.com/spreadsheets/d/18zkwzlPi1PREKW8EG71NGGokOULKRMqAdEck-u3YvHA/edit#gid=0

Thanks in advance.

Formulae I am using -

=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1HzSslzdKFtbxEdPQPX5Ox0Cq2NNaqRViYX3ookQ4I1w/edit#gid=0","BODY COVER STOCK!A1:J")

Data Sheet Image - Data Sheet

Target Sheet Image - Target Sheet

Upvotes: 1

Views: 1075

Answers (1)

player0
player0

Reputation: 1

could ba a result of excessive usage of dependency...

if you have editing access to Data SpreadSheet try adding an intermediate (new) sheet with this in A1:

={BODY COVER STOCK!A1:J}

and then import that new sheet with IMPORTRANGE

=IMPORTRANGE("1HzSslzdKFtbxEdPQPX5Ox0Cq2NNaqRViYX3ookQ4I1w", "new sheet!A1:J")

Upvotes: 1

Related Questions