Clicking an active tab opens the previous tab?

ctmainiac22

New Member
Joined
Aug 7, 2007
Messages
14
Good afternoon -
Strange case here and I can't seem to find any background after an afternoon of Google/forum searching.

I have a file that is recreated annually with tabs created for each month's work. The 2018 file had no issues, but, the 2019 file is causing issues.

When, say, the March tab is clicked on, the previous/February tab opens, and so on. To open the latest tab, you must click to the right, beyond the "new tab" plus sign.

This file was submitted to us by a client (as was the 2018 file), so, other than it being a .xslx file, we don't have much else to go on as to how the file was created. One would think it was just a "Save As" from the 2018 file, but, as previously mentioned, that file was fine.

Has anyone seen this before, or, have any idea what the issue could be... and any possible fix? As the information month to month varies, and there are several people accessing this file monthly, if one isn't aware of this issue or just isn't paying attention, there is a pretty high risk of invalid information being pulled in. So any help would be greatly appreciated.

If more information is needed, please let me know, and I'll gladly supply what I can.

Thanks,
Katy
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,022
Latest member
Mohamed Magdi Tawfiq Emam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top