C
CarlSprake
I hope that someone here can help with the following:
A customer has a spreadsheet which holds a pivot table that links to a SQL
Server Analysis services data cube. The spreadsheet contains macros which
format the pivot table & pivot chart according to some preset charts. It is
sensitive data and therefore has restricted access. It is published on their
intranet, so apart from maintenance users, is accessed via Internet Explorer.
Last week they had a problem trying to access this spreadsheet over Citrix,
because user's default security settings were high - and that only enabled
them to run macros which were signed. So they purchased a digital signature,
installed it on a machine, and signed the spreadsheet macros. The spreadsheet
now runs OK on Citrix, users only have to say they trust macros signed by us,
and almost all works OK.
Until this morning, the customer discovered a very worrying set of symptoms
with the spreadsheet. It happens when the visible chart is selected, copied
to clipboard, and pasted into Microsoft Powerpoint. My customer has a macro
function which selects the visible chart and copies to clipboard, and this
shows exactly the same symptoms as doing it by hand. Pasting into Microsoft
Word does not seem to be a problem.
The Errors are:
1: On opening the published version, running a chart, selecting "Copy to
clipboard", when pasting to PowerPoint, error message "Macros do not match
digital signature - this can only happen with a macro virus - macros will be
disabled" error message comes up. Select OK and the picture is visible,
though. Also get other "Error accessing file" messages (as in 2). This
happens only if Powerpoint window opened after the copy; if opened before,
they get error 2.
2: Get "Error accessing file" when pasting chart. Does not happen on Word
paste, only PowerPoint; happens 7 times then picture is pasted. Does not
happen on repeat try. For variant 2 of this error
3: On pasting chart into another application, customer gets "An application
is requesting access to Private Item - CryptoAPI Private key". This also
appeared on anothe user's machine. Only seen with Powerpoint paste; never
appeared on Word paste. Seen this several times but not sure what
circumstances cause it to appear.
4: After error 3 get "The server application cannot be found"
A customer has a spreadsheet which holds a pivot table that links to a SQL
Server Analysis services data cube. The spreadsheet contains macros which
format the pivot table & pivot chart according to some preset charts. It is
sensitive data and therefore has restricted access. It is published on their
intranet, so apart from maintenance users, is accessed via Internet Explorer.
Last week they had a problem trying to access this spreadsheet over Citrix,
because user's default security settings were high - and that only enabled
them to run macros which were signed. So they purchased a digital signature,
installed it on a machine, and signed the spreadsheet macros. The spreadsheet
now runs OK on Citrix, users only have to say they trust macros signed by us,
and almost all works OK.
Until this morning, the customer discovered a very worrying set of symptoms
with the spreadsheet. It happens when the visible chart is selected, copied
to clipboard, and pasted into Microsoft Powerpoint. My customer has a macro
function which selects the visible chart and copies to clipboard, and this
shows exactly the same symptoms as doing it by hand. Pasting into Microsoft
Word does not seem to be a problem.
The Errors are:
1: On opening the published version, running a chart, selecting "Copy to
clipboard", when pasting to PowerPoint, error message "Macros do not match
digital signature - this can only happen with a macro virus - macros will be
disabled" error message comes up. Select OK and the picture is visible,
though. Also get other "Error accessing file" messages (as in 2). This
happens only if Powerpoint window opened after the copy; if opened before,
they get error 2.
2: Get "Error accessing file" when pasting chart. Does not happen on Word
paste, only PowerPoint; happens 7 times then picture is pasted. Does not
happen on repeat try. For variant 2 of this error
3: On pasting chart into another application, customer gets "An application
is requesting access to Private Item - CryptoAPI Private key". This also
appeared on anothe user's machine. Only seen with Powerpoint paste; never
appeared on Word paste. Seen this several times but not sure what
circumstances cause it to appear.
4: After error 3 get "The server application cannot be found"