Forum Discussion
Solved
Formula not displaying value. Instead it displays #N/A
I have a formula that takes the date and time from another worksheet and gets only the date. The problem I have is that after I know it works and I close and re-open it the date from the formula says...
Hi Mogheh86
Looks like your reference file is on a file drive.
Just be sure to see the Enable Content yellow prompt to reconnect to the source data.
Here's a link that may be helpful as well: https://www.excel-easy.com/examples/external-references.html
Best wishes and hope that helps!
Cheers
Damien
Hi Mogheh86
Looks like your reference file is on a file drive.
Just be sure to see the Enable Content yellow prompt to reconnect to the source data.
Here's a link that may be helpful as well: https://www.excel-easy.com/examples/external-references.html
Best wishes and hope that helps!
Cheers
Damien
It turns out I don't need to figure it out. The information still pulls into the fields. Thanks for the help!
