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%
Got a credit card? use our Credit Card & Finance Calculators
Thanks to Anonymous,bruncher,niord,gvonge,Shelford, for Donating to support the site
HYPTUSS circular references
-
- Lemon Quarter
- Posts: 2316
- Joined: November 4th, 2016, 4:20 pm
- Has thanked: 1913 times
- Been thanked: 877 times
-
- Lemon Half
- Posts: 8498
- Joined: January 7th, 2017, 9:56 am
- Has thanked: 1563 times
- Been thanked: 3460 times
Re: HYPTUSS circular references
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
Perhaps similar to the issue I had.
viewtopic.php?p=226734#p226734
-
- Lemon Quarter
- Posts: 2316
- Joined: November 4th, 2016, 4:20 pm
- Has thanked: 1913 times
- Been thanked: 877 times
Re: HYPTUSS circular references
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.
-
- Lemon Quarter
- Posts: 2316
- Joined: November 4th, 2016, 4:20 pm
- Has thanked: 1913 times
- Been thanked: 877 times
Re: HYPTUSS circular references
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
-
- Lemon Quarter
- Posts: 4133
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3287 times
- Been thanked: 2869 times
Re: HYPTUSS circular references
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
Return to “Financial Software - Discussion”
Who is online
Users browsing this forum: No registered users and 5 guests