Excel memory issue

[MartyLH]

Sorry for the long description, but I want to make it as clear as possible up front.
I have a workbook with a tab for each day, used as a daily log for my department. It a simple form, with some minor conditional formatting, and a few small formulas. It is a 'shared' file so multiple users have access at the same time. This is the second edition. The one we used last year had no issues, this one has one. I copied an unused tab from the old file into a new file, then copied it to multiple tabs, one for each day of the year.

Now to the issue ..... When we first started using it, it would always open to the first tab for all users. After a few days of use it started opening at the last edited tab for most of us. Now about 50% of us it will open at their last saved tab, but for some it opens to the first tab.
Any ideas where I can look to resolve this issue of not opening to the last saved tab?

No hurry on this. We've adapted to the issue, but would like to find a resolution soon.

thank you
mlh

 

[starl]

Shared workbooks are easily corrupted...

But, you could unshare the workbook and put the following macro in the ThisWorkbook module

Private Sub Workbook_Open()
Sheets(1).Activate
End Sub

this will jump to the leftmost sheet (including hidden sheets), when the workbook is opened.
after pasting the code, you can reshare the workbook.

See Where do I paste the code that I find on the internet for how to paste code into the ThisWorkbook module