… As it would explain why some users can and some users cannot access it. I hope this option will work for you. It is weird I tried all of the steps above, but the one that worked for some strange reason will this one from Toodamax. Open Microsoft Excel.2. 2. bjmiller Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range. So then I closed Excel and went to File Explorer again and double-clicked on the file and it opened like it should. Click OK.
If it won't then, you can go with Excel repair software. I've tried it now on 4 users machines and it's doing it for all of them.

This works in most cases, where the issue is originated due to a system corruption. It then places the file we tried to open on the disabled list. I have Excel 2016 and when I use File Explorer and browse to a .xls (Excel 97-2003 worksheet) and double-click, Excel 2016 opens up and display nothing but an empty worksheet.

I will contact my collaborator and have him try your Trust Center suggestion. I have a dropbox account but I believe I need an email address in order to create a shared file folder. All of a sudden when we try to open them, Excel stops working and won't open. Here is the link to the dropbox file. So I tried several more .xls files and they are now all working.

I have also seen on occasion going to Excel Options--> Advanced--> and check the box for "Disable Hardware Graphics Acceleration" fix Excel issues opening files. That can start narrowing it down a little. You could try and convert the file online to another version, maybe it helps. EVAP Master Productivity Calculator (2020_0110).xlsm. We are using Excel 2016 I have created a file in Excel 2016 that utilizes 3 User Forms and several command buttons all backed by various VBA Macros. For a better experience, please enable JavaScript in your browser before proceeding. Please try again. Excel will only open a blank spreadsheet when I enable the DDE. Conditional formatting formula required for day of week and a value.

ask a new question. This went on for several iterations of the file until we got a file that functioned well on both his computer and mine. I can't see anything in the file that would stop it from working in 2013 !! (Or Excel, or PowerPoint, and so on.) Which of the following retains the information it's storing when the system power is turned off? Happy New Year. It only happens on certain profiles. Yes, we have.


The spreadsheet is not damaged, as it is on a network location and others have no issues. Thank you for your help. It will be morning before he will look at it. I do not want to create new user profiles for them for this one spreadsheet. Arrrrgh. Have you gone into Folder Options and under View, deselected "Show preview handlers in preview pane"? Excel 2016, embedded spreadsheet in Excel wont open, Think you've mastered IT? I have created a file in Excel 2016 that utilizes 3 User Forms and several command buttons all backed by various VBA Macros. Only a few people are getting the problem. Click Advanced, then locate the General section.4. Doing the "Quick Repair" to Microsoft Office, "You might try going into Control Panel-->Programs and Features-->right click on the Office version-->select change-->Quick Repair, This happens occasionally with our folks too." I had Excel 2016 open and I went to file explorer and double-click on the file and it opened right up. I have 2 .pdf files embedded also, those open fine. Microsoft 365, what happened to the add ons. Cost us £200 : (. Have you done a version, including service pack, comparison of the installed Office products on PC's that are and are not affected? You must log in or register to reply here. I have tried to repair office, open Excel in safe mode, matched my settings and options to be exactly like one that is working, but I still get the error pop up no matter what, as does some other users.

I can log into a different computer and it works fine. AADSTS90033: A transient error has occurred. Most likely due to an Add-In. 1. This happens occasionally with our folks too. What happens if you log on to a PC that didn't work with a user account that did work and then attempted to open the embedded file? Mine, not the repair suggestion. Anyone else run into this and found a solution? Please try again.