1 file crashing Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1590154%22%20slang%3D%22en-US%22%3E1%20file%20crashing%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1590154%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20have%201%20spreadsheet%20among%20many%20shared%20in%20Drop%20Box%20that%20is%20crashing%201%20team%20member's%20Excel%20upon%20making%20changes%2F%20saving.%26nbsp%3B%20He%20asked%20me%20to%20look%20at%20it.%26nbsp%3B%20I%20noted%20that%20it%20was%20the%20only%20in%20a%20series%20of%20somewhat%20similar%20monthly%20summary%20files%20we%20have%20that%20was%20saved%20as%20a%20macro%20enabled%20workbook.%26nbsp%3B%20I%20find%20no%20macros%2C%20so%20tried%20saving%20as%20.xlsx%20file%20and%20it%20still%20crashes%20him.%26nbsp%3B%20Not%20sure%20where%20to%20dig%20or%20if%20I%20need%20to%20rebuild%20the%20file.%26nbsp%3B%20If%20the%20later%2C%20how%20to%20even%20begin%20with%20years%20of%20data%20in%20the%20monster.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1590154%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1590760%22%20slang%3D%22de-DE%22%3ESubject%3A%201%20file%20crashing%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1590760%22%20slang%3D%22de-DE%22%3EIt%20would%20be%20of%20great%20advantage%20if%20you%20insert%20a%20file%20(without%20sensitive%20data)%20so%20that%20we%20can%20see%20and%20understand%20the%20problem%20better.%20So%20you%20can%20be%20helped%20faster%20and%20more%20precisely.%20So%20one%20can%20only%20make%20a%20presumption%20or%20clairvoyance.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%201%20assumption%3A%20%3CBR%20%2F%3E%20Perhaps%20an%20external%20macro%20from%20another%20worksheet%20could%20be%20built%20into%20this%20worksheet.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%202%20assumption%3A%20%3CBR%20%2F%3E%20If%20the%20Blank%20file%20is%20opened%2C%20a%20workaround%20in%20regedit%20is%20probably%20responsible%20(this%20also%20happens%20with%20Word).%20%3CBR%20%2F%3E%20Computers%20HKEY_USERS%20XXXXXXXXXXXXXXXX%20-%20Software%20-%20Microsoft%20-%20office%20the%20current%20version%20number%20(16.0).%20%3CBR%20%2F%3E%3CBR%20%2F%3E%203.%20Assumption%3A%20%3CBR%20%2F%3E%20maybe%20the%20drivers%20and%20%2F%20or%20BIOS%20are%20not%20updated%20to%20the%20latest%20version.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20I'm%20not%20sure%20if%20guesswork%20can%20help%20here.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Nikolino%20%3CBR%20%2F%3E%20I%20know%20that%20I%20don't%20know%20(Socrates)%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

We have 1 spreadsheet among many shared in Drop Box that is crashing 1 team member's Excel upon making changes/ saving.  He asked me to look at it.  I noted that it was the only in a series of somewhat similar monthly summary files we have that was saved as a macro enabled workbook.  I find no macros, so tried saving as .xlsx file and it still crashes him.  Not sure where to dig or if I need to rebuild the file.  If the later, how to even begin with years of data in the monster.

1 Reply
Highlighted
It would be of great advantage if you insert a file (without sensitive data) so that we can see and understand the problem better. thus you can also be helped faster and more precisely. So one can only make a presumption or clairvoyance.

1 assumption:
Perhaps an external macro from another worksheet could be built into this worksheet.

2 assumption:
If the Blank file is opened, a workaround in regedit is probably responsible (this also happens with Word).
Computer \ HKEY_USERS \ XXXXXXXXXXXXXXXX \ Software \ Microsoft \ office the current version number (16.0).

3. Assumption:
maybe the drivers and / or BIOS are not updated to the latest version.

I'm not sure if guesswork can help here.

Nikolino
I know that I don't know (Socrates)