Opening the Excel Error Checking for circular references takes me to a cell in the Company data sheet, and I see that in some (but not all) of the lines relating to shares I hold, the entry in column D, the New Data Sheet Sector has changed from a sector description to a formula, such as:
=VLOOKUP(TEXT(C65,"0"),'Company Data Sheet'!C:D, 2,FALSE)
and the display in the cell is a 0.
Does this behaviour suggest an issue I can or should do anything about?
As far as I can tell, in spite of this warning, everything is working as I would expect.
I'm running Windows 10 and Excel 2007 (yes, I know, but I'm a cheapskate
![Very Happy :D](./images/smilies/icon_e_biggrin.gif)
TIA
Staffordian
EDIT: Just discovered that when I click the Get Sharecast Forecast Yields button, all but the first entry comes back (quite quickly) as 0.00%