Forum Discussion
.XLSM workbook not showing links in column
I have a .XLSM folder that I created. There is no VBA, but the way some of the formulas are written it necessitates the need of .XLSM format. ref: https://www.youtube.com/watch?v=ZZ9j8m1lT6w&t=1...
Thank you for this insight.
If I add the location of the workbook as a trusted location, is that user specific or would that inherit to anyone that opens the document?
I need to share this out to plant locations nationwide, having the recipients going to trust center as part of process isn't an option. I need them to be able to open the workbook and have it function as intended.
I have office 365, and it should be up to date, but don't have the navigation?
Wouldn't it be easier to just keep a manual list of sheet names and use the HYPERLINK function to create links to them? I understand this depends on the use of the file and how often tabs are added and/or renamed. But the simplest of solutions is often best. Alternatively, you might write a script that updates the sheet list and call that script on a scheduled basis using Power automate. See for example this article (by me) which contains precisely that script:
https://jkp-ads.com/articles/excel-office-script-examples.asp#Adding_a_table_of_Contents_to_your_workbook
And how to call such a script using Power Automate (the example does so for many files, but it will give you an idea):
https://jkp-ads.com/articles/excel-office-script-call-from-power-automate.asp
https://jkp-ads.com/articles/excel-office-script-examples.asp#Adding_a_table_of_Contents_to_your_workbook
And how to call such a script using Power Automate (the example does so for many files, but it will give you an idea):
https://jkp-ads.com/articles/excel-office-script-call-from-power-automate.asp
- Perhaps HyperLink function came about after the tutorial video I followed. As it is now, if I add a tab, it auto enters itself on the main page with the process followed in the video. I will give your link a view and see if that may work. Ultimately it is what works best for the users that I share the workbook to that have to update it. IT just needs to work without any manipulation on user end. Thanks much!
- If I save-as to the ancient Excel 97-2003 file format, the HYPERLINK function is retained. That indicates it has been around for a while 🙂
