Some years ago, I followed some advice and created a sheet that listed the other sheet names in the workbook using INDEX and REPLACE in the formulas. It worked perfectly. There was also advice that hitting Ctrl, Alt and F9 would recalculate the sheet. I think we were using version 2013 at the time.

Then I forgot about it. Now we are using version 2019. When I revisited the worksheet, all of the formulas have a #NAME? error. When I hit Ctrl, Alt and F9, it brings me to the login screen. I am guessing the problem is with this version of Excel.

Any advice?