Problem with opening PVWA report

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Announcements

Welcome Idira to LIVEcommunity!

Our community just got stronger! Explore new identity security resources, connect with experts, and discover more ways to learn and collaborate.

Meet Idira

Problem with opening PVWA report

L3 Networker

Hi team,

 

I have a problem with opening PVWA reports in xls format. It used to work on windows 7 and excel 2013. I have migrated to windows 10 and am using office 365. Am getting the below error:

Field_Content_versions_oct20__0682J00000Az8PwQAJ.png

I had a similar error on excel 2013 but it worked. Any idea how to fix this? (please do say use csv 🙂 ) Thanks!

6 REPLIES 6

L7 Applicator

hey @Daniel Rajewicz​ 

I'd suggest trying using CSV to see if that works.

 

Additionally, is this the only report having this issue?

 

Does it work on another machine?

 

Have you reached out to Microsoft regarding this issue with Excel?

 

-Matt

L3 Networker

@Matt Jennison​ 

The problem exists also for other users who migrated to W10 and office 365, it works for users with w7 and office 2013...

hey @Daniel Rajewicz​ 

what version of the PVWA and Vault are you using?

 

If you export a new report do you see the same issue?

 

sounds like there's a compatibility issue with the report you're using and Win10 and O365.

 

-Matt

L3 Networker

@Matt Jennison​ 

I found the solution. First of all I opened the report file in notepad and found out that report is generated in XML format, but the report extension is XLS.

 

Decription on Microsoft web page:

 

Excel 97- Excel 2003 Workbook

.xls

The Excel 97 - Excel 2003 Binary file format (BIFF8).

So the extension does not match to the content of the file. That's why I was getting the error that file format and extension is not valid. I was getting the same error on office 2013 but it was possible to open the file. I can only guess that Cyberark saves reports as xls file to enforce opening files in Excel.

 

I changed the extension to XML, but got another error and it appeared that company policy is to block opening XML files in Excel based on Microsoft office security baseline recommendations.

So to fix the issue setting in Trust Center -> File block settings -> Web Pages and Excel 2003 XML Spreadsheets needs to be unchecked for OPEN.

This allows to open Cyberark reports but only if I change extension to xml...

L0 Member

This seems to still be an issue today (V14.6 self-hosted). Thanks for posting your solution @Daniel Rajewicz​!

@Matt Jennison​ any updates from CyberArk or a way to fix that, so not every user has to do this workaround? Thanks in advance.

Hey @Maximilian Krass​ 

In order to fix this we'd need to have a known issue article created for this after review from R&D. If you have supporting evidence and can reproduce the issue, I would recommend opening a Support Case and we can get working on that!

 

-Matt

  • 563 Views
  • 6 replies
  • 0 Likes
Like what you see?

Show your appreciation!

Click Like if a post is helpful to you or if you just want to show your support.

Click Accept as Solution to acknowledge that the answer to your question has been provided.

The button appears next to the replies on topics you’ve started. The member who gave the solution and all future visitors to this topic will appreciate it!

These simple actions take just seconds of your time, but go a long way in showing appreciation for community members and the LIVEcommunity as a whole!

The LIVEcommunity thanks you for your participation!