Updating remote references excel

I have the settings for both sheets set to update every minute and the tabs are set to refresh every minute.

I have tried editing the "Spreadsheet settings" so that recalculation is done every minute and on every change.

Furthermore, I have also installed an extension in Google Chrome that auto-refreshes the page every hour.

However, the data does not get re-imported from the referenced workbook.


My assumption would be that Google would have taken care of this for me, but the data in the "referencing sheet" does not get updated, and the only way I can find to get it to update is to physically go into the "source sheet" and edit it [email protected] Can you explain what you mean by "ensuring that the right version is used as the source"?



Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>