http://forums.visokio.com/discussions/tagged/spreadsheet-export/feed.rss Mon, 30 Oct 17 14:25:04 -0400 Tagged with spreadsheet-export - Visokio Forums en-CA http://forums.visokio.com/discussion/3135/pivot-view-export-of-aggregated-data-in-excel-tables Mon, 06 Jun 2016 08:33:42 -0400 Phillipa 3135@/discussions We are constantly being asked by clients if it is possible to export the view data into excel tables.

I am aware that this option exists but what the clients really want is aggregated data in a format similar to a pivot table.

When I export from the pivot table to excel I get aggregated data but cannot restrict which fields are exported.
This results in unneccessary fields, which are often meaningless as they contain "no value" as there is no unique single answer due to aggregation.
This is not very intuitive for our clients.

Ideally I would like to be able to reproduce a pivot table view in an excel table.

Can anyone help me with this problem?
Thanks for any advice.
Phillipa]]> http://forums.visokio.com/discussion/2981/export-excel-sharepoint-existing-vs-new-worksheet-files Mon, 10 Aug 2015 06:33:52 -0400 benjamin 2981@/discussions I have a series of Omniscope files which run sequentially and export in each file multiple output blocks to varying location on Sharepoint. Each block is using "Replace Data" and "Excel Direct".

My problem is that when exporting the data it sometimes creates a new worksheet for the export instead of exporting to the excel file on Sharepoint.

For instance i have one Omniscope file and i have three (3) blocks exporting to the same Excel file on Sharepoint. These blocks sometimes export to the Excel file and sometimes create their own new Excel file.

I have looked at version history on Sharepoint and for instance the first two block publish ok and then the last block will just publish to a newly created Excel file and save it on Sharepoint.

Thanks, Ben]]>