|
Les types de fichiers classiques ne pourront plus être utilisés à partir de janvier 2021. Vous pouvez transférer vos fichiers classiques ou télécharger un PDF. En savoir plus

Updating Connections on Connected Sheets

Demande de démonstration

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

Commentaires

2 commentaires

Date Votes
  • Kellie Volpicelli
    • Modifié

    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

Vous devez vous connecter pour laisser un commentaire.