export to excel generates subtotals for all dimension values

G

Guest

Hi,

when I export to excel from OWC, even though I do not have
sub totals on all dimension, when the pivot is displayed
in excel, all dimensions show up with sub totals. I then
have to manually go in and change the subtotal option to
NONE in each of the dimensions. Is there a setting in
excel that will turn it off automatically?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

#N/A values when exporting PivotTable to Excel 0
ISO best steps to export (import) all from Outlook 2003 to Outlook in MS 365 0
What’s the best way to automatically update dimensions on a drawing image imported from a jpg to Exc 1
Calculating subtotals 0
Calculating subtotals 22
You'll need a new app to open this about link 1
Bug or feature, Expanding multiple dimension with multiple level. 0
All filter on a Dimension 1

Top