View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default #N/A External Link Error

What's the formula that you're using?

Steve C wrote:

I am getting a #N/A error in a cell on my workbook (Earned Time.xls). The
cell has a formula link to another workbook (Vacation.xls). When I open
Vacation.xls, the #N/A error in Earned Time.xls disappears and the cell
displays the proper information. When I close Vacation.xls, the cell in
Earned Time.xls continues to display the proper information up until the time
I save and close it.

However, when I re-open Earned Time.xls, the #N/A error is back! Can anyone
tell me why this is happening?


--

Dave Peterson