Excel focus issues

Hi mathetes,

Right now I have two workbooks that I update regularly, and I see the behavior in both of them.

1. COVID-19 statistics.xls - This tracks the number of cases and deaths using data entered manually from the Tampa Bay Times. In Sheet1, I track these for four scopes: National, Florida, Hillsborough County and Pinellas County. For each scope and metric, the daily change, % change and a 10-day moving average are calculated. These are all simple arithmetric expressions, though the MA cells must check whether there are any missing values within the past 10 days. In this book, Sheet1 has a sequence number in column A and the days date in column B; National cases are in columns C-F and deaths in G-J; Florida cases are in columns K-N and deaths in O-R; Hillsborough County cases are in columns S-V and deaths in W-Z; ; Pinellas County cases are in columns AA-AD and deaths in AE-AH. This sheet has expressions in the first 155 rows and data entered in the first 132 rows, and formula calculation is Automatic. Sheet2 is empty (used only to click out of sheet 1 when the focus issue occurs). A typical daily session would include the following steps:
   1. refresh the TB Times page and navigate to the page having the day's statictics.
   2. In the workbook,
      1. put the focus in the current day's column C (National cases) and enter the value manually (not via copy/paste)
      2. Hit Tab 4 times to advance to column G (National deaths) and enter that value.
      3. Hit Tab 4 times and repeat 2.1 and 2.2 for the Florida, Hillsborough County and Pinellas County values.
      4. Click Save.
2. CheatSheet.xls - used to generate new randomized passwords and assign them to specific sites. Sheet1 contains the text values of email subject lines that I've edited every time I get a password change confirmation; the edits are to denote what format of ID is used, the current password hint for that site and the date it was most recently changed, plus formatting to indicate where these values begin and end. After editing and saving, the outlook item is copied to the clipboard as tab-separated values for "From", "To", "Subject", "Received" and "Size". This string is pasted into columns B-F, and expressions in columns G-P tease out the values. Sheet2 contains the data and logic to generate unique randomized password values using ranges that contain lower- and upper-case letters, digits and special characters. Automatic calculation is on and updates 50 rows with new passwords, When I've consumed all 50 from the last batch, I insert 50 rows at the bottom and manually copy the latest 50 values in.

Note that COVID-19 statistics.xls is typicaly always open and is updated daily, while CheatSheet.xls is only open when I'm changing a specific site's password or adding a new site, or when I make periodic changes to all "sensitive" sites (i.e. financial, not just where I have a forum login).  I  have other workbooks of course, but these are the only ones I've updated for the past few months.

P.S. Before Excel, I used Lotus Symphony (but not 1-2-3) and Ashton Tate's Framework and Framework II. Symphony managed my Compuserve RPG game sessions, and I used FW for database development.