I’m utilizing an exterior utility to enter information right into a Google Spreadsheet. This workbook is then referenced by a separate workbook (with the
IMPORTRANGE(spreadsheet_key, range_string) perform) that manipulates and interprets the info. My drawback is that at any time when I personally modify the referenced workbook, the referencing workbook updates simply fantastic, however at any time when the exterior utility modifies it, it doesn’t get up to date.
I’ve tried modifying the “Spreadsheet settings” in order that recalculation is completed each minute and on each change. Moreover, I’ve additionally put in an extension in Google Chrome that auto-refreshes the web page each hour. Nevertheless, the info doesn’t get re-imported from the referenced workbook. Even when I copy the formulation into a brand new cell, the info remains to be not re-imported.
Is there something that I can do to the referencing workbook to set off Google Sheets to re-import the info?
Edit: Simply to be clear, I presently have one workbook with information entered by an exterior utility in it (name it the “supply sheet”), and one other workbook with an
IMPORTRANGE perform in it (name it the “referencing sheet”). The information proven by the
IMPORTRANGE perform within the “referencing sheet” doesn’t embody any information entered by the exterior utility since I final personally edited the “supply sheet”. Additionally, each workbooks are utilizing the brand new Google Sheets.
Edit: Additionally, this query is just not the identical as How do I hyperlink a cell in Google Spreadsheets to a cell in one other doc? as a result of I’m utilizing the perform given as the answer to that query to import information from a spreadsheet. The issue is just not the best way to import the info, however moderately the best way to replace the supply for the info. My assumption can be that Google would have taken care of this for me, however the information within the “referencing sheet” doesn’t get up to date, and the one approach I can discover to get it to replace is to bodily go into the “supply sheet” and edit it myself.