Excel formula external link to workbook on OneDrive returns REF status

The formula is referencing the external file via this path: 'https://d.docs.live.net/1b1ecec231c6xxx/CapApp/Trail Life/[TL Sales by Item 10-01-2022 to 09-30-2023.xlsx]PT by Item by Month'!$A:$A. In ...