+ Post New Thread
Results 1 to 7 of 7
MIS Systems Thread, Macro Security - Certificate revoked in Technical; Hi, I'm getting this error on one windows 7 computer when running reports to excel. Normally users just click enable, ...
  1. #1
    HCC
    HCC is offline
    HCC's Avatar
    Join Date
    Jan 2009
    Location
    East Sussex
    Posts
    117
    Thank Post
    9
    Thanked 0 Times in 0 Posts
    Rep Power
    12

    Question Macro Security - Certificate revoked

    Hi,

    I'm getting this error on one windows 7 computer when running reports to excel. Normally users just click enable, but this isn't there because the certificate is revoked?
    Capture.PNG
    I think I remember seeing a certificate update 'patch' in WSUS, so maybe this is the cause.

    Anyone else seen this?

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    Odd. My reports to Excel work fine, with a prompt. i'm on 7.150
    What macro security have you got?
    I use disable with prompt. If you set the digital signed one, then maybe it causes that error..?

  3. #3

    Join Date
    Feb 2012
    Location
    Guildford
    Posts
    2
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    I am seeing this too. Have you got anywhere in resolving it.

  4. #4
    HCC
    HCC is offline
    HCC's Avatar
    Join Date
    Jan 2009
    Location
    East Sussex
    Posts
    117
    Thank Post
    9
    Thanked 0 Times in 0 Posts
    Rep Power
    12
    Sorry, No further, I called our SIMS support team and they knew nothing about it. I think its a windows update for root certificates that voids a certificate SIMS uses, but I'm not sure which one.
    I'm hoping the Spring Release will fix it.

  5. #5

    Join Date
    Jun 2010
    Location
    Leicestershire
    Posts
    152
    Thank Post
    17
    Thanked 18 Times in 16 Posts
    Rep Power
    12
    We've had this today with a new(ish) member of staff. I've solved it by overwriting her version of the excel sheets in My Documents\TempSimsRpt with my versions.

    I guess there must be a problem with the new templates which SIMS is copying over for new staff - which may mean the new update doesnt fix existing problems!

  6. Thanks to Brucy from:

    waringk (29th April 2013)

  7. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    @Brucy - i'd make a backup of those file somewhere safe then. Be interested to compare them and see what's different. The excel templates are accessible, but the Word ones are password protected.

  8. #7

    Join Date
    Feb 2012
    Location
    Guildford
    Posts
    2
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Worked a treat thank you.

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 10
    Last Post: 26th July 2013, 02:20 PM
  2. Security Certificate Issues
    By damo66a in forum Home Access Plus+
    Replies: 2
    Last Post: 19th October 2011, 05:05 PM
  3. Renew Citrix Security Certificate
    By quaium in forum Thin Client and Virtual Machines
    Replies: 11
    Last Post: 30th December 2010, 09:20 PM
  4. Replies: 2
    Last Post: 12th January 2006, 09:32 AM
  5. Macro Security
    By Ric_ in forum Windows
    Replies: 4
    Last Post: 4th October 2005, 08:59 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •