Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to avoid "Data connections have been disabled"
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 STARTRUN) 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to avoid "Data connections have been disabled"
See below (mixed in text) Gord Dibben <gorddibbATshawDOTca wrote: Instructions for Excel 2003 on WindowsXP Pro SP2 Have a go at changing the DC to a Trusted Certifiicate. With Excel closed...................... StartRun "mmc" to open the Microsoft Management Console. FileAdd/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) Expand and open Personal Certificates folder. Select your SelfCert DC and drag it to the Trusted Root CertificatesCertificates 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 On Tue, 18 Mar 2008 12:33:51 -0400, wrote: 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 STARTRUN) 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to avoid "Data connections have been disabled"
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 On Tue, 18 Mar 2008 16:24:15 -0400, wrote: See below (mixed in text) Gord Dibben <gorddibbATshawDOTca wrote: Instructions for Excel 2003 on WindowsXP Pro SP2 Have a go at changing the DC to a Trusted Certifiicate. With Excel closed...................... StartRun "mmc" to open the Microsoft Management Console. FileAdd/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) Expand and open Personal Certificates folder. Select your SelfCert DC and drag it to the Trusted Root CertificatesCertificates 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 On Tue, 18 Mar 2008 12:33:51 -0400, wrote: 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 STARTRUN) 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to avoid "Data connections have been disabled"
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 StartRun) 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?) Gord Dibben <gorddibbATshawDOTca wrote: Instructions for Excel 2003 on WindowsXP Pro SP2 Have a go at changing the DC to a Trusted Certifiicate. With Excel closed...................... StartRun "mmc" to open the Microsoft Management Console. FileAdd/Remove Snap-in. Select Certificates snap-in. Expand and open Personal Certificates folder. Select your SelfCert DC and drag it to the Trusted Root CertificatesCertificates 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 On Tue, 18 Mar 2008 12:33:51 -0400, wrote: 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 STARTRUN) 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to avoid "Data connections have been disabled"
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 <gorddibbATshawDOTca wrote: 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 On Tue, 18 Mar 2008 16:24:15 -0400, wrote: See below (mixed in text) Gord Dibben <gorddibbATshawDOTca wrote: Instructions for Excel 2003 on WindowsXP Pro SP2 Have a go at changing the DC to a Trusted Certifiicate. With Excel closed...................... StartRun "mmc" to open the Microsoft Management Console. FileAdd/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) Expand and open Personal Certificates folder. Select your SelfCert DC and drag it to the Trusted Root CertificatesCertificates 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 On Tue, 18 Mar 2008 12:33:51 -0400, wrote: 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 STARTRUN) 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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to avoid "Data connections have been disabled"
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 FileAdd.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 On Tue, 18 Mar 2008 19:09:26 -0400, wrote: 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 StartRun) 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?) Gord Dibben <gorddibbATshawDOTca wrote: Instructions for Excel 2003 on WindowsXP Pro SP2 Have a go at changing the DC to a Trusted Certifiicate. With Excel closed...................... StartRun "mmc" to open the Microsoft Management Console. FileAdd/Remove Snap-in. Select Certificates snap-in. Expand and open Personal Certificates folder. Select your SelfCert DC and drag it to the Trusted Root CertificatesCertificates 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 On Tue, 18 Mar 2008 12:33:51 -0400, wrote: 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 STARTRUN) 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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to avoid "Data connections have been disabled"
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. Gord Dibben <gorddibbATshawDOTca wrote: 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 FileAdd.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 On Tue, 18 Mar 2008 19:09:26 -0400, wrote: 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 StartRun) 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?) Gord Dibben <gorddibbATshawDOTca wrote: Instructions for Excel 2003 on WindowsXP Pro SP2 Have a go at changing the DC to a Trusted Certifiicate. With Excel closed...................... StartRun "mmc" to open the Microsoft Management Console. FileAdd/Remove Snap-in. Select Certificates snap-in. Expand and open Personal Certificates folder. Select your SelfCert DC and drag it to the Trusted Root CertificatesCertificates 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 On Tue, 18 Mar 2008 12:33:51 -0400, wrote: 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 STARTRUN) 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Data Connections have been disabled" If no macros, Why? | Excel Discussion (Misc queries) | |||
Security Issue: Data Connections Disabled | Excel Discussion (Misc queries) | |||
Avoid "update Links" promt in e-mailed pivot tables? | Excel Discussion (Misc queries) | |||
Text formatted as "General" in Excel 2002. How do I avoid that? | Excel Discussion (Misc queries) | |||
Excel: can "go to adjacent empty cell" double-click be disabled? | Excel Discussion (Misc queries) |