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?
Microsoft ExcelSpreadsheets

Avatar of undefined
Last Comment
wagamama123

8/22/2022 - Mon
John

You should be able to minimize the sheet (standard upper right Windows control icons) and see what is going on.
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.
wagamama123

ASKER
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.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
John

Can you close the workbook?  Then make a new (blank) workbook and minimize it?
wagamama123

ASKER
Yes. Competely functional. Except for the add in dialog box.
John

Maybe the add-in is no good.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
wagamama123

ASKER
working fine for weeks
John

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.
wagamama123

ASKER
Indeed.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
John

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.
wagamama123

ASKER
How do I run as admin? I am the only user of the computer fyi.
John

Right click on Excel and select Run as Administrator.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
wagamama123

ASKER
When I right click there is not to run as admin.
wagamama123

ASKER
There is no option to run as admin on a right click
John

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.
Your help has saved me hundreds of hours of internet surfing.
fblack61
wagamama123

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

ASKER
Its greyed out
John

Then the user name you logged in as is not a member of the administrators group.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
wagamama123

ASKER
How do  I add myself to the admin group?
wagamama123

ASKER
Should I start another thread for help with this?
John

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.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
John

Should I start another thread for help with this?  

No. That will just fragment the work.
wagamama123

ASKER
Under Accounts it says the following (I have made no changes yet)

Local Account
Administrator

Is there more than one level  of admin?
John

Who do you log on as?  

No there is not more than one level of admin
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
wagamama123

ASKER
As me. This is my computer. I live alone.
John

You want to be here:

Windows-10-User-Groups
John

There is no "ME" in your list. What name do you use?
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
wagamama123

ASKER
wagamama123

ASKER
Blake
John

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.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
wagamama123

ASKER
Ok. Got there. I am running as admin. What should I do?
John

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

Did that not work?
wagamama123

ASKER
Which post? What shold I do?
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
John

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.
wagamama123

ASKER
I DID THAT!!!
wagamama123

ASKER
Above post:
Ok. Got there. I am running as admin. What should I do?
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
John

OK, so your operating system is hosed.

What OS. You need to do a Repair Install.
wagamama123

ASKER
Windows 10
wagamama123

ASKER
How do I do that?
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
John

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
wagamama123

ASKER
Ok. Says it is going to be awhile. Going to retire. Have a good night.
John

It takes about 3 hours.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
wagamama123

ASKER
No change. The Dialog box is doing the same thing.
ASKER CERTIFIED SOLUTION
wagamama123

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
John

I am glad you found a solution. Thanks.
wagamama123

ASKER
Yes
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes