I run combat from an excel sheet and I've got automatic links to all the monsters in DnDBeyond thanks to the consistent naming policy. This works fine for example in the case of an air elemental:
Please note that both links work when clicking on these links here, but if you copy them into excel and then click on them, the first does work whilst the second does not.
Any ideas how to make the later link work from excel?
I run combat from an excel sheet and I've got automatic links to all the monsters in DnDBeyond thanks to the consistent naming policy. This works fine for example in the case of an air elemental:
Please note that both links work when clicking on these links here, but if you copy them into excel and then click on them, the first does work whilst the second does not.
Any ideas how to make the later link work from excel?
Very interesting - I was able to recreate this issue as well. Thanks for the heads up - I'll pass this along to the team.
Edit: After more testing and research, it's not an issue with D&D Beyond - the issue happens because when you open a link within Excel it more or less removes any cookies before sending you to that link. There's nothing we can do on our side.
Cool, thanks for the speedy response GP! Hopefully this will be of use to people in the future who try and do the same thing (I've edited the title appropriately). I'll reply to this thread again if I find a solution within Excel.
DJC - sadly Excel is my tool of choice and only partly because I can work on it whilst at work and still look like I'm working!
Sadly not Emmber - I've got lots of VBA powering the backend of it so I can't bring that across.
Stormknight - good thinking but sadly this doesn't work either. Having read into it a little, it appears that excel handles a hyperlink differently because it assumes that it's a link to a file rather than a webpage so it tests out what the link does in a temporary browser with no cookies present.
Thanks all, but I think that I'm just going to have to manually search (or code the VBA) for anything that's behind a paywall.
Rollback Post to RevisionRollBack
To post a comment, please login or register a new account.
I run combat from an excel sheet and I've got automatic links to all the monsters in DnDBeyond thanks to the consistent naming policy. This works fine for example in the case of an air elemental:
https://www.dndbeyond.com/monsters/air-elemental
But if I try for the air elemental myrmidon, I just get redirected to the PotA intro page (I have paid for PotA btw):
https://www.dndbeyond.com/monsters/air-elemental-myrmidon
Please note that both links work when clicking on these links here, but if you copy them into excel and then click on them, the first does work whilst the second does not.
Any ideas how to make the later link work from excel?
-
View User Profile
-
View Posts
-
Send Message
D&D Beyond StaffVery interesting - I was able to recreate this issue as well. Thanks for the heads up - I'll pass this along to the team.
Edit: After more testing and research, it's not an issue with D&D Beyond - the issue happens because when you open a link within Excel it more or less removes any cookies before sending you to that link. There's nothing we can do on our side.
It is some kind of authentication issue. It seems the link forgets (or doesn't check) your login and/or licence status and auto redirects.
Try a Google doc instead. Maybe links from within the browser will work.
Cool, thanks for the speedy response GP! Hopefully this will be of use to people in the future who try and do the same thing (I've edited the title appropriately). I'll reply to this thread again if I find a solution within Excel.
DJC - sadly Excel is my tool of choice and only partly because I can work on it whilst at work and still look like I'm working!
I just tried this in OpenOffice Calc and it seems to work fine. It's basically the same thing - and free. Could you use that as an alternative?
Mega Yahtzee Thread:
Highest 41: brocker2001 (#11,285).
Yahtzee of 2's: Emmber (#36,161).
Lowest 9: JoeltheWalrus (#312), Emmber (#12,505) and Dertinus (#20,953).
-
View User Profile
-
View Posts
-
Send Message
D&D Beyond FoundersIirc, Excel uses internet explorer to handle links, even if your default browser is something else.
Try logging into D&D Beyond in internet explorer (and leaving the browser open) then trying your Excel links again.
I'm not at my pc currently, so can't test this myself, but I found a very similar issue on a separate project several years ago
Pun-loving nerd | Faith Elisabeth Lilley | She/Her/Hers | Profile art by Becca Golins
If you need help with homebrew, please post on the homebrew forums, where multiple staff and moderators can read your post and help you!
"We got this, no problem! I'll take the twenty on the left - you guys handle the one on the right!"🔊
Sadly not Emmber - I've got lots of VBA powering the backend of it so I can't bring that across.
Stormknight - good thinking but sadly this doesn't work either. Having read into it a little, it appears that excel handles a hyperlink differently because it assumes that it's a link to a file rather than a webpage so it tests out what the link does in a temporary browser with no cookies present.
Thanks all, but I think that I'm just going to have to manually search (or code the VBA) for anything that's behind a paywall.