Making an Excel tab – a worksheet – default open everytime for everybody in SharePoint.

I have a complex spreadsheet that I use to track security and accounts for Team Foundation Server. I created a worksheet that has a linkable index to all the other tabs. This sheet I named "Index"

The problem is the spreadsheet does not open on my Index tab, but whatever somebody opened and saved it as last time. I need the "Index" tab to be default.

Well, the problem is the order you create the tabs is the order they are named in the code of the Workbook. Renaming the tabs from Sheet1, Sheet2, etc. does not actually change the coded order.

Continue reading