Link to home
Start Free TrialLog in
Avatar of wagamama123
wagamama123

asked on

Dialog Box Hidden Excel

I have a dialog box hidden behind excel spreadsheet. It just started happening rendering the add in useless. How do I fix?
Avatar of John
John
Flag of Canada image

You should be able to minimize the sheet (standard upper right Windows control icons) and see what is going on.
Avatar of wagamama123
wagamama123

ASKER

i have done that and other simple ideas. I am 2 hours into this. its not a simple fix.

I have uninstalled the add in 4 times. No help there.

It all started when I minimized the dialog box. You can ss that it is open when you you hiver over ezcel in the task bar.  I just cant make maximize an appear in front of the spreadsheet.
Edit.  It all started when I minimized the dialog box. You can see that it is open when you you hover over excel in the task bar.  I just cant make it maximize and appear in front of the spreadsheet.
Can you close the workbook?  Then make a new (blank) workbook and minimize it?
Yes. Competely functional. Except for the add in dialog box.
Maybe the add-in is no good.
working fine for weeks
I do not know. If it worked, and now you can set up a new workbook situation and it does not work, something went wrong.
Indeed.
Try the following:

Make sure you know where the add-in is (what folder).

Close Excel.

Open Excel with Run as Administrator. Remove the add-in (not disable - remove). Now click Add and navigate to the folder where the add-in lives and add it from there.

Close out and test.
How do I run as admin? I am the only user of the computer fyi.
Right click on Excel and select Run as Administrator.
When I right click there is not to run as admin.
There is no option to run as admin on a right click
There is. I do not know what operating system you have.

Go here:  C:\Program Files (x86)\Microsoft Office\root\Office16  or wherever Excel.exe is

Find Excel. exe in the folder above and right click on it, Run as Administrator is an option.
I found it in the properties dialog box. I am unable to check the box that says "Run as Administrator"
Its greyed out
Then the user name you logged in as is not a member of the administrators group.
How do  I add myself to the admin group?
Should I start another thread for help with this?
You have to be an administrator to do this.

Right Click on Computer / My Computer and select Manage. In the Window that comes up , select Users and Groups, Users, and see your username at the right. Click on Member of  and add yourself to Administrators.
Should I start another thread for help with this?  

No. That will just fragment the work.
Under Accounts it says the following (I have made no changes yet)

Local Account
Administrator

Is there more than one level  of admin?
Who do you log on as?  

No there is not more than one level of admin
As me. This is my computer. I live alone.
You want to be here:

User generated image
There is no "ME" in your list. What name do you use?
Blake
That says you are Administrator

I found it in the properties dialog box. I am unable to check the box that says "Run as Administrator"  Forget this.

Go here:  C:\Program Files (x86)\Microsoft Office\root\Office16  or wherever Excel.exe is

Right click on excel.exe and select Run as Administrator.

If you really cannot, something is wrong with your operating system.
Ok. Got there. I am running as admin. What should I do?
Go to my post above  Go here:  C:\Program Files (x86)\Microsoft Office\root\Office16  or wherever Excel.exe is

Did that not work?
Which post? What shold I do?
Lordy lordy - Please read.

Go here:  C:\Program Files (x86)\Microsoft Office\root\Office16  or wherever Excel.exe is

 Right click on excel.exe and select Run as Administrator.
I DID THAT!!!
Above post:
Ok. Got there. I am running as admin. What should I do?
OK, so your operating system is hosed.

What OS. You need to do a Repair Install.
Windows 10
How do I do that?
Do a Windows 10 repair install

Go to the Media Creation Link

https://www.microsoft.com/en-us/software-download/windows10

Click on Upgrade to Windows 10 (even if Windows 10 is running), click on the Download button, select Open (Run) but NOT Save. Allow the program to run. Allow drivers to update. Then select Keep Everything.

This issue may be why the Excel function is not working
Ok. Says it is going to be awhile. Going to retire. Have a good night.
It takes about 3 hours.
No change. The Dialog box is doing the same thing.
ASKER CERTIFIED SOLUTION
Avatar of wagamama123
wagamama123

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I am glad you found a solution. Thanks.
Yes