With SharePoint 2010, you might run into an issue when attempting to create a new PowerPivot Gallery Document from PowerPivot gallery, like this:
If you encounter this issue, you may then see the following to errors:
The reason for the error is that SharePoint is looking for the template .xlsx file in the wrong location.
To resolve the issue:
Now the path to the template.xlsx folder will be correct, and you shouldn’t get any errors when creating new PowerPivot Gallery Documents from PowerPivot gallery.
When I am trying to select "Open With Explorer", I am getting following error
"We're having a problem opening this location in File Explorer. Add this web site to your Trusted Sites list and try again."
I added my website into browser trusted site list, still getting the same error
Can you please let me know the steps to resolve this.
Thanks in Advance
The issue that you're seeing seems like more of an issue with basic SharePoint functionality. One thing you could try is to log into SharePoint as the Farm Administrator, and then try to click on Open with Explorer. If even that does not work, then I would recommend that you coordinate with your own internal SharePoint Admin team to move the Forms folder into the ReportGallery folder, or if the Forms folder does not exist, to create a Forms folder in the ReportGallery folder, and then locate that template Excel file there.
I hope it helps,