Cell showing #N/A

[malverd]

I have a spreadsheet with a circular reference. All I care about is the value updating. I don't need to go back and view any prior data. I just need the values to constantly update.

Example:
Data is constantly updated in cell A1. That value is put into cell B1. Then if A1 is updated, that value is added to the existing value in B1.

The data coming into A1 is DDE. It relies on me having another program open to bring the data into Excel.

The problem is, when I close the spreadsheet and then reopen, it show cell B1 as #N/A. I am assuming there is a brief instance where A1 is #N/A and this is why B1 continues to have #N/A.

However, if i click in cell B1 to show the formula and then tab out of it, then cell B1 will begin to update.

Is there a way to avoid this error from occurring?

Thanks

 

[GQue]

Wish I could help... Sound like you just need to do a Formula Refresh when you first open. I think it's F9 (Calculate Update).

If that doesn't do the trick, I would need more info...

 

[malverd]

I'm not sure if this is the same thing as F9. When Excel starts, it states, "This workbook contains links to other data sources...." Then there is the Update or Don't Update button. I choose the Update button, but B1 still shows $N/A until double click in it and then tab out of it. Then it will start updating.

Any ideas?

Wish I could help... Sound like you just need to do a Formula Refresh when you first open. I think it's F9 (Calculate Update).

If that doesn't do the trick, I would need more info...

 

[GQue]

If you click Update, then press F9, and that doesn't work, then I am not sure what else to do. I am not a big fan of linked cells to begin with so I most likely never encountered this before...