Why is this IMPORTRANGE formula not working?

Question

I keep getting an error while using the IMPORTRANGE formula:

=importrange(“1uUbz2HAzgwBwY3zMXqcLJM_Z8qVQZHNP0wzRaNHceTc”, “Sheet1!A:B”)

I changed the name of my sheets several times to make sure everything matches but see a:

Formula parse error

and I am not sure what I am doing wrong. The original sheet has several tabs as well.

Can you see where the error is?

Answer 1

This worked for me:

=importrange(“1uUbz2HAzgwBwY3zMXqcLJM_Z8qVQZHNP0wzRaNHceTc”; “Sheet1!A:B”)

Maybe try it with a semicolon

Answer 2

Add the link format eg =importrange("https://docs.google.com/spreadsheets/d/1uUbz2HAzgwBwY3zMXqcLJM_Z8qVQZHNP0wzRaNHceTc","Sheet1!A:B") this should fix it