Excel basic authentication disabled SSL message

Hi There,

I have two users both using Microsoft office 2010 SP2 and Windows 7 SP1.
They are both troubled by the attached annoying message.
This message comes up when they open either a local brand new book1 excel document or other excel documents. Nothing pointing to any web server. This message just happens once a day and immediately when you open excel. Now I've disables everything internet related that excel could be accessing, disabled Active X and macros and its still happening. Is there some way to disable this message completely. As it is not needed for anything web related.

Thanks In Advance.
excel-msg.jpg
GECs36711Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ProfessorJimJamCommented:
could have been caused by either of this.

A)  check the file under data  then Connections, see what is there?  also go to VBE with ALT F11 and then go to Thisworkbook and see if there any code there.

B) check what are the active Add-Ins, some add-ins also cause this.
0
GECs36711Author Commented:
@ProfessorJimJam:
A) I get no connections found in Connections in this Workbook. VBE screenshots are attached.
B) Please view attached Active add-ins. Doesn't look like there are any.

For the above I opened a brand new excel doc and the msg come up. I doubt it will come up again. It only happens once a day on both pc's.
1.png
2.png
Add-ins.png
0
ProfessorJimJamCommented:
Ok,  last check,  what is the Excel Start up folder?

are you accessing Excel files from server?

there is a microsoft patch that supposedly solves the problem http://go.microsoft.com/?linkid=9777384
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

GECs36711Author Commented:
-Excel Start up folder? Where can I check this?
-Nope not accessing it from any server, on the local pc and opening a brand new excel workbook.
-Does the fix still apply to if it is locally accessed?
0
ProfessorJimJamCommented:
here is the path for StartUP folder of excel

C:\Users\Username\AppData\Roaming\Microsoft\Excel\XLSTART

just change the username in bold to the computer window username

Yes, the microsoft patch should fix it. here is the confirmation for this statement,  link from microsoft  also another blog, users confirmations
0
GECs36711Author Commented:
-I've gone to that directory. There's nothing in there. Is that normal?
-I will install the fix and let you know tomorrow if that message is still coming up.
0
ProfessorJimJamCommented:
it is normal not to have any file there.

try the fix and let me know.

hopefully it would work.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
GECs36711Author Commented:
Will Do.
0
GECs36711Author Commented:
@ProfessorJimJam:
This fix has unfortunately not worked. That message is still popping up.
Any other suggestions(I really thought we had it fixed)?.
0
GECs36711Author Commented:
Hi All,

Are there any other suggestions?
0
GECs36711Author Commented:
@ProfessorJimJam:
Actually it looks like the fix did help but just with the getting to the next step of troubleshooting.
Now instead of popping up with that message it now prompts for a user name and password.
Please Note:
-My user's internet access is governed by URL Filtering and Firewall rules. So they only have access to work related things.
-This only happens the first time you open excel until the next day.
-The excel document is a completely newly created workbook on the local pc.

*I know need to find out what Microsoft service\updating service is running in excel that check's once a day and using basic authentication.
*I have disabled everything relating to excel reaching out to the internet. If someone might be able to point out exactly what this might be assessing and what must be disabled so that it is not a bother anymore, please your help is really needed.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.