Hi All,
I am using Sumproduct formula to pull in data from one Excel file A to another Excel file B. I noticed that if I don't have file A (which has the data) open, then file B (with the Sumproduct formula) does not automatically get updated with new data I have added to to file A. I have to open File A for this to work and it works even if File A is opened by multiple sources and is in read only mode. Is there a way to get File B updated withought having to open File A or is this a limitation of Sumproduct function?
Thanks!
Bookmarks