Excel 2016 Bug?

[therber2]

Folks,

Without really explaining what I do for a living (not sure its relevent), I wanted to explain both a bug I have been experiencing as well as the typical overall workspace I'm using:

First of all, I have Excel 2016 now and I use 'Excel.exe /x' in Windows 10's 'Run' prompt to have open, currently, 11 instances of excel; each intance will only ever have one single Workbook open on it and my workbooks average about a 5,000 KB file size.

THE ISSUE: some of the files (typically files that are 5k KB to <20k KB in size will give me this issue where a cell won't select on any sheet unless I double click it....seems sort of like I have to 'wake the workbook up.' Also, just clicking between sheets has the same issue: that is, it'll only do anything if I double click...a single click doesn't wake it up.

Now....I do have files open up to over 20,000 KB large that DO NOT do this...I'm not totally sure that rules out the idea that my files having issues are just too large, but it may. I've run file inspector on these problematic files and really decreased file sizes, but there seems to be some corruption.

ALSO, I mentioned that I am on Excel 2016 now. I was on Excel 2003 before this and don't remember dealing with so many little bugs. What do you guys think about down grading my version of Excel?

Any other thoughts?

 

[therber2]

Another thing I can think of may be calculations. If you have a large number of Array formulas/functions in use.
I have a case with thousands of array formulas hitting large arrays. Oh boy does that seem to hang forever. We switch to manual calculations and its speedy.

Another thing may have to do with any connections that might exist. Complex path or remote path or path that does not resolve clearly. I was in a network environment that files on the server were not being discovered quickly causing serious lag in opening the file.
Also, what frequency of auto-save are you on? I have not noticed if the Autosave indicator shows for an inactive window and you just happen to catch it when it is AutoSaving... (If so, play the lottery!)

Thanks for the thoughtful response. Good thoughts...

1. I tried switching to manual calc mode just to debug (had same thought) to no avail. There are no arrays at all, and I only have several formulas as I manually 'paste value's daily and save. So I don't think complexity of formulas and them taking up file size has much to do with it.

2. connections that might exist: we must think alike. I tried this too. I delete ALL hanging / existing connections, resave, close and re-open workbook. To no avail again though :/

3. what frequency of auto-save are you on? - the same as for all my books. This is a constant and not a variable in the debacle.

Also, as far as the aforementioned errors occuring, I see zero correlation between number of worksheets in the book and frequency of the bug occuring.
Totally stumped. All I have left is to try, maybe on another computer, down-grading to a more stable version of excel. Does that seem like the right move? I don't really use any of the newer excel features anyways (although, I might and not know it).

Thank you,
Tom