When using importrange still can't modify spreadsheet.

  • Profile Image
    Jasoncaouk
    Asked on October 14, 2014 at 07:15 AM
    IF I USE IMPORTRANGE, I STILL CANT MODIFY THE SPREADSHEET
  • Profile Image
    Shadae
    Answered on October 14, 2014 at 10:01 AM

    Hi Jasoncaouk,

    To confirm, you are having an issue with editing the second spreadsheet that you have created to import information from your integrated spreadsheet?

    You would not be able to edit the data on the spreadsheet that the information is imported to, as it is only showing the information from the original spreadsheet. Any changes to the information you would do on the original spreadsheet and it would change in the new spreadsheet.

    You are however able to create additional columns and edit those within in the new spreadsheet. You should also be able to do your formatting edits on the new spreadsheet.

    I hope this helps, please inform us if you need additional assistance.