Sorry not sure if I understand the situation correctly.
To my understanding,
- you are creating a local excel file named checklist (which has hyperlinks pointing to folders) and the corresponding folders with subfolders for each project.
- upload the checklist excel file and folders to the Sharepoint site.
- the hyperlinks stop working in Sharepoint/Teams, but are working locally
If I misunderstood it, please feel free to correct me.
Based on my test, it may be the expected behavior that hyperlinks don't work after the files are uploaded to Sharepoint.
As no matter you are using absolute path or relative path in hyperlinks on your local computer, once you upload the excel file and folders to Sharepoint, the folder structure gets changed so the hyperlinks would no longer work.
Oh, one other item, SOME of the links update and can open the appropriate library locations in the folders, but others do not update.
Are you syncing the Sharepoint site with your local folders?
And you first create the excel file also the folders locally and later synced these files to Sharepoint site?
Based on my test, in this way when you create hyperlinks it would point to the file path in Sharepoint.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.