How to avoid "Data connections have been disabled"

[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

 

[Gord Dibben]

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

 

[EagleOne]

See below (mixed in text)

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)

 

[Gord Dibben]

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

 

[EagleOne]

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?)

 

[EagleOne]

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

 

[Gord Dibben]

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

 

[EagleOne]

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.