The Lemon Fool

On one or two occasions, including today, I've opened the HYPTUSS (11.72, the latest version), clicked the button to get prices, and an Excel warning box has popped up in front of the spreadsheet saying that there are circular references.

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 )

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%

Possibly a formatting issue on the cell in question? The format has accidentally been changed.

Perhaps similar to the issue I had.

viewtopic.php?p=226734#p226734

monabri wrote:Possibly a formatting issue on the cell in question? The format has accidentally been changed.

Perhaps similar to the issue I had.

viewtopic.php?p=226734#p226734

Thanks monabri. I'll investigate tomorrow and see if my issue is similar.

monabri wrote:Possibly a formatting issue on the cell in question? The format has accidentally been changed.

Perhaps similar to the issue I had.

viewtopic.php?p=226734#p226734

Just to wrap this up, the formatting was correct, so no joy there, but I did what I should have done in the first place; I downloaded a new version of the HYPTUSS and copied my data over.

This seems to have resolved the problem, so it must have been something I did inadvertently to my copy.

Thanks for your suggestion though - much appreciated.

Staffordian

staffordian wrote:

monabri wrote:Possibly a formatting issue on the cell in question? The format has accidentally been changed.

Perhaps similar to the issue I had.

viewtopic.php?p=226734#p226734

Just to wrap this up, the formatting was correct, so no joy there, but I did what I should have done in the first place; I downloaded a new version of the HYPTUSS and copied my data over.

This seems to have resolved the problem, so it must have been something I did inadvertently to my copy.

Thanks for your suggestion though - much appreciated.

Staffordian

That's good news, I was just about to have a look at this. I've got no idea what could have caused the problem, let's hope it wasn't Covid-19, I don't think my antivirus protects against that!

--kiloran