#N/A External Link Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
What's the formula that you're using?

Steve said:
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?
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change link-source on file after copy the sheet into new a newworkbook 5
#N/A in linked cell 4
#N/A Conditional Formatting affects all cells? 9
Ignoring Cells Returning #N/A 4
#N/A 5
formula error 1
SUMIF excluding #N/A 3
Avoiding #N/A 4

Back
Top