I tipi di file classici non potranno più essere utilizzati a partire da gennaio 2021. È possibile effettuare la transizione dei file classici o scaricare un PDF. Ulteriori informazioni

Updating Connections on Connected Sheets

Richiedi una demo

We currently leverage connected sheets for reporting and have added additional columns to the report within the module. How can I those columns to the connected report that we leverage? I.e Need the 2 new columns brought into the connected sheet to update our reporting. 

0

Commenti

2 commenti

Data Voti
  • Kellie Volpicelli
    • Modificato

    We use connected sheets for reporting and in our case the sheets are connected to a query. So when we have needed to add additional columns, I have to add them to the query and then when I refresh the connection the columns come in to the connected spreadsheet. 

    0
  • Juaque Swanepoel

    Let's say you have two spreadsheets A and B.
    A contains the source report and B leverages that report via a connection on a Sheet X.
    The connected cells are locked due to the nature of how connected sheets work.
    Spreadsheet B has other sheets that reference to the Sheet X either by direct cell refences or formulas. Could also have links.
    If the formulas / references are not dynamic adding columns and rows to the sheet in Spreadsheet A would cause unwanted consequences by shifting underlying data.
    The only way I know of to replicate what has been done on the primary is to temporarily disconnect the sheet add the required rows and columns and reconnect.
    Not sure how it would work with queries as we don't have the Wdata.

    0

Accedi per aggiungere un commento.