opiamoon.blogg.se

This happened after installing Office 2016 through Microsoft 365 online. I typed in second cell,hit enter and the text disappeared. cleared the add ins wįirst i typed in the cells. AutoRecover has been disabled for this session of excel."Ī) Click on File menu, click Options, Add-ins,īut i have the same issue. To close the file I did get a Microsoft Excel error message stating " An unexpected error has occurred.

After that everything was back to normal. The simple solution I found was for me was to close the file, close excel and everything else open on my PC, which in my case was just Lotus Notes, then shut down completely and then cold boot. I copied the file to an network drive and it worked fine for another user on the network but still no good for me.

The only active addins I had were FileNet, Lotus Quickr and Solver.

I had not changed any settings at all or played around with any addins. I had the same problem myself today on a file that worked fine previously. Reply with the necessary information and the result for further assistance. If the issue reappears again, it will help you to determine which add-in is causing this issue. If Excel safe works, disable the add-ins following steps mentioned below and determine the problem causing add-in:Ī) Click on File menu, click Options, Add-ins, Go button besides Manage:ī) Check if there are add-ins listed, clear the check box.Ĭ) Close the Office program and restart it.ĭ) Disable each add-in one at a time, restart the Excel, and repeat the above procedure. Copy and paste, or type the following command in the Open box, and then press Enter: Note: You must enable ‘Show hidden files and folders’ to access ‘ AppData’ folder and ensure to disable it after the troubleshooting process.Ģ) Start Excel in safe mode and verify the result.įollow the below mentioned steps to start Excel safe mode:ī.

Is this issue experienced on a specific Excel file or on all Excel files?ġ) Go to the following location and delete files from XLSTART folder and then start Excel and verify the result:Ĭ:\Users\\AppData\Roaming\Microsoft\Excel\XLSTART I would assist you in issue related to Excel however I have a quick question for you: