Internal links creating new file

[Riia]

What I’m trying to do

I have an internal link to an obsidian note which should open that note. Others with the same syntax work perfectly. I am creating the link by typing two square brackets and then starting to type the file name, till the correct file shows in the list of suggestions, I click on it, and the link is created, as normal. However, in this case, if I then click on the link it creates a new blank note, in the same folder with almost the same name, just a -1 added to the end of the note.

Things I have tried

I have tried repeating these steps in a different note, and the new link behaves exactly the same, creating a new note instead of opening the intended note. Other internal links created today work exactly as they should.

I also tried creating the link using a simple drag and drop of the file into the note where the link should be. Same problem, clicking on the link creates a new note.

Here is the text of the link that is being automatically created (by either approach), which includes the full path to the note:

[[Z. External documents/spreadsheets/radiocarbon_Glykou_etal_2021_input.xlsx|radiocarbon_Glykou_etal_2021_input.xlsx]]

While the links as created for other files with similar names in the same folder look like this, without the full path:

[[carbon_Glykou_etal_2021_input.xlsx]]
[[strontium_Glykou_etal_2021_input.xlsx]]

(no, these notes are not themselves spreadsheets, they are my notes describing the metadata of spreadsheets, each with am external link to the spreadsheets themselves, they just have the same name as their corresponding spreadsheet).

Does anyone know what is causing this weirdness so I can make it stop? It would be lovely if clicking the link to the note actually opened the note, instead of creating a new, empty note.

I have tried merging the new note with the real note, in hopes that it would update the link, but no, it still just makes a new note.

PS

I am not certain if this counts as a bug report (e.g. something wrong with Obsidian), or a request for help (e.g. it is something I did that causes this). Most of the “help” posts I have read seem to be of the sort “I can’t figure out how to…”, so I have gone with bug report for now. If it is better with the other tag, let me know, and I can change it back.

[Riia]

While doing something else today I stumbled upon a solution to this problem. I added the Advanced URI plugin, and then used my right mouse over the note I want to link, used the Copy Advance URI option and then pasted that code in as an external link, and now it works.

I still don’t understand what was causing that issue, nor how to prevent it in the future, so I will leave this open on the off chance that anyone else can explain it, but if anyone else ever has this problem and stumbles on this post, at least I already have one work-around.

[Pch]

@Riia

Here is the text of the link that is being automatically created (by either approach), which includes the full path to the note:

[[Z. External documents/spreadsheets/radiocarbon_Glykou_etal_2021_input.xlsx|radiocarbon_Glykou_etal_2021_input.xlsx]]

This doesn’t look like a link pointing to a markdown note titled radiocarbon_Glykou_etal_2021_input.xlsx (where the .md extension would be implied) but a link to an .xlsx file titled radiocarbon_Glykou_etal_2021_input (stored in Z. External documents > spreadsheets) …

I can only guess that there could be some mix up going on between both files (the .md note and the .xlsx file) as they seem to be both located in the same folder and have the “same” name…
(If I understood correctly )

I didn’t have a .xlsx file on hand so I’ve tested with a .json one which I stored in one of the folder of the sandbox vault…

When adding a link to that .json file in a note I used this:

[[Formatting/test.json]]

… which looks similar to your link (minus the alias)

Now, wanting to create a markdown note bearing the same full name as the file (file title + extension), I instead used:

[[Formatting/test.json.md]]

Note the addition of the .md after the .json …
Clicking on it created a .md note titled test.json in the folder Formatting

Where it gets interesting (imho), is when I try to add the link of the test.json markdown note to another note as the suggester/dropdown, appearing when typing [[ in the note doesn’t differentiate between the .json file and the .md note: Both appear without a way to distinguish one from the other …

Trying to add one or the other from the suggester/dropdown to the note return a link to the .json file in each case but written slightly differently …

If I try to add a link pointing to the test.json markdown note by dragging and dropping it into a note from the file explorer, it also points to .json file (each time) …

I don’t know if this would be considered as a bug or something else … but when I create a .md note about a non-markdown file I have in my vault, I never add the extension of said file to the title of the corresponding note …
So I guess you could need/try to remove the .xlsx from the titles of the corresponding markdown notes …

The other possibility, at it seemed to work here would be to add the .md extension in the link meant to direct Obsidian to the markdown note and not the file, I guess (once more) …

[[Z. External documents/spreadsheets/radiocarbon_Glykou_etal_2021_input.xlsx.md|radiocarbon_Glykou_etal_2021_input.xlsx]]