I recently created a file (file X for this example) that has data and graphs. File X pulls data from File Y. Prior to today, I have been able to open File X, the data appears from the previous save and the graphs work. I can see the data in File X without opening File Y to refresh the data.
When I open File X today, I see #VALUE! error messages, despite the fact that when I used this file last week I did not receive this message. The only way I can get the message to go away is to open the linked file, File Y.
A) Why is this ocurring?
B) How do I make this go away, so that I don't have to open File Y to get File X to work (just like it worked up until today)?
When I open File X today, I see #VALUE! error messages, despite the fact that when I used this file last week I did not receive this message. The only way I can get the message to go away is to open the linked file, File Y.
A) Why is this ocurring?
B) How do I make this go away, so that I don't have to open File Y to get File X to work (just like it worked up until today)?