 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / March 2008How 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 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 >Excel 2007 > [quoted text clipped - 28 lines] > >TIA EagleOne See below (mixed in text) >Instructions for Excel 2003 on WindowsXP Pro SP2 > [quoted text clipped - 5 lines] > >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) >Expand and open Personal Certificates folder. > [quoted text clipped - 42 lines] >> >>TIA EagleOne 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 >See below (mixed in text) > [quoted text clipped - 66 lines] >>> >>>TIA 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 >If you double-click on "Certificates - Current User" you should get a list of >folders including "Personal" and "Trusted" and a half dozen others. [quoted text clipped - 71 lines] >>>> >>>>TIA 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?) >Instructions for Excel 2003 on WindowsXP Pro SP2 > [quoted text clipped - 52 lines] >> >>TIA EagleOne 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 >Additional: > [quoted text clipped - 64 lines] >>> >>>TIA 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. >I don't know why the list of folders did not show up up under Cerificates _ >Current User. [quoted text clipped - 80 lines] >>>> >>>>TIA EagleOne |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.