How to avoid "Data connections have been disabled"

  • Thread starter Thread starter EagleOne
  • Start date Start date
E

EagleOne

Excel 2007

Steps taken: Created a certificate called XYZ (which I thought enable my Excel Macros)
which was placed in my Personal Certificates Store but forgot how I did that a year ago.

Now almost every previously created Excel w/s I open contains the message:

"Data connections have been disabled"

Bottom line - how do I get around this issue??

Also, I have deleted all data connections (in a workbook), saved the file, then re-opened
it only to find the same data connections.

ADDITIONAL STEPS:

I have heard that the solution may involve the MS Certificate Manager.

Therefore I used "certmgr.msc" (from START>RUN) certmgr.msc and I would like to install
my certificate into "the trusted Root Certification Authorities store".

I can see the certificate in the Personal folder but its "certification path" indicates
that it is "Not Trusted."

Do I have to delete it and start over? modify it?

I have no clue how to:
1) create, modify a personal certificate and/or
2) install it in the trusted Root Certification Authorities store and/or
3) make sure that the "certificate path" is OK (in short authorized and OK)


TIA EagleOne
 
Instructions for Excel 2003 on WindowsXP Pro SP2

Have a go at changing the DC to a Trusted Certifiicate.

With Excel closed......................

Start>Run "mmc" to open the Microsoft Management Console.

File>Add/Remove Snap-in. Select Certificates snap-in.

Expand and open Personal Certificates folder.

Select your SelfCert DC and drag it to the Trusted Root
Certificates>Certificates folder.

Close MMC...........you can save changes to Comsole1.msc if you choose, but not
necessary unless you want the snap-in to stay loaded.

Now open Excel and your workbook.

Any difference?


Gord Dibben MS Excel MVP
 
See below (mixed in text)

Gord Dibben said:
Instructions for Excel 2003 on WindowsXP Pro SP2

Have a go at changing the DC to a Trusted Certifiicate.

With Excel closed......................

Start>Run "mmc" to open the Microsoft Management Console.

File>Add/Remove Snap-in. Select Certificates snap-in.

Get to here fine.

GET: Snap-ins added to: Console Root
I selected Add (get an drop-down which includes "Certificates"
next I get "This snap-in will always manage certificates for:
My User Account
Service account
Computer account
next I select My user account then Finish , then in I get "Certificates - Current User"

I do not get the option: to (do the next step below)
 
If you double-click on "Certificates - Current User" you should get a list of
folders including "Personal" and "Trusted" and a half dozen others.


Gord
 
Additional:

As mentioned above, I was not able to continue the mmc process.
That said, I would like to know what I did wrong.

I did open (via Start>Run) certmgr.msc

In that utility, I was able to drag my certificate to
the "trusted" folder and it is now "Trusted"

Thanks Gord (if you have the time what did I do wrong with mmc?)
 
I 2-clicked as stated and all that happened was
"Certificates - Current User" moved up to the select-from area"
and the "message box" was became empty.

Thanks
 
I don't know why the list of folders did not show up up under Cerificates _
Current User.

I assume when you opened mmc console and File>Add.Remove a Snap-in you selected
Certificates and "Add" or d-click then options "My User Account".

Works for me.

But they did show up when you bypassed mmc and went directly to certmgr.msc so
at least you got a trusted certificate which was the purpose of all this<g>

I should have directed you there in first place.........you did mention it in
original post but I'm more accustomed to going through mmc console1


Gord
 
Yes, your suggestions led to the solution. I did not know that moving a certificate
from Personal to Trusted would lead to its becoming Trusted. That was the seed
you provided.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top