I have no idea what is causing this issue, but when I reopen an Excel file, formulas that reference cells will change the reference cells at the very end of the sheet.
Example: Super simple spread sheet adding A1 and A2 in A3
When I close the file and reopen the file, I can't select any options in the ribbon, and the formula in A3 has been changed to reference cells A1048575 and A1048576 instead of A1 and A2.
This happens to any existing Excel file that I try to open. Also, this can happen with columns as well, like the furthermost column in a spreadsheet, changes to XFD. Say I have a number in E1 that will change to XFD1 and columns A-D will change to XEZ-XFC.
Any help resolving this issue is much appreciated.