View original (French)

Importrange: You do not have permission to access this sheet

Solved
metoman Posted messages 36 Registration date   Status Member Last intervention   -  
 BEDEL08225 -
Hello,

I'm trying to connect several files using an importrange formula as seen on YouTube, but the file tells me that I do not have permission to access this sheet.

Both of these files are mine and are located in the same Google account.

The formula is as follows:

=IMPORTRANGE("URL";"ANNUEL!J1")

Could you help me and tell me why this is not working?

Thank you in advance.

3 answers

  1. Omer
     
    Hello,

    If the original file is an Excel import, it won't work; just change the format from XLSX to Google format.

    (File -> Save as Google Sheets)
    5
    1. Coralie
       
      Hello
      Thank you for the feedback. It was actually quite simple ;)

      Have a nice day
      0
    2. BEDEL08225
       

      Hello,

      I have the same problem, how did you manage to fix it?

      0