have a look at File.....spread sheet settings... calculation tab. that may need adjusting.
On Wednesday, 23 June 2021 at 02:30:37 UTC+12 [email protected] wrote: > I am using Python and gspread to upload local .csv data to a google > *SpreadsheetA*. > > I have a separate google *SpreadsheetB* that uses =IMPORTRANGE to import > the data from Spreadsheet A and create a pivot table and corresponding > chart. > > If I were to manually adjust any data in SpreadsheetA (e.g., alter value > of any cell, add a value to an empty cell, etc), then the data in > SpreadsheetB—with its corresponding pivot table and chart—update > dynamically with the new data from SpreadsheetA. > > However, when SpreadsheetA is updated with new data programmatically via > Python, IMPORTRANGE in SpreadsheetB does not capture the new data. > > Any ideas as to why this happens and how I might be able to fix? > -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/google-spreadsheets-api/b92b0aed-4324-4441-b4b6-06a9958f83ean%40googlegroups.com.
