Referencing data on one spreadsheet from a second spreadsheet
Posted on 2014-03-13
I keep data I use in various spreadsheets in one spreadsheet called "dataheader_ust". The other spreadsheets (example: wtc.xlsm) refer to information on "dataheader_ust" using references like:
I use manual calc. I find when I update the other spreadsheet (e.g. wtc.xlsm) the data from dataheader_ust is not updated. I can usually get it to update by recopying and pasting the formula, or filling from another nearby cell, but not buy using CTRL-f9.
Is there a reliable way to ensure that all references to outside spreadsheets update?
Also - I always open the dataheader_ust spreadsheet in the same session as the spreadsheet that uses the data. Is that necesssary? Or, can wtc.xlsm get data from dataheader_ust when dataheader_ust is not open?