How can I disable Subtotals?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
Using another application I export reports to Excel. However, some of the
reports appears in Excel with subtotals. I want to remove the subtotals. I
know that I can remove them by going to Data >> SubTotals >> Remove all, but
then I have to do this for every report I execute to Excel.

Do anyone know about a way of disable Subtotals within Excel?
 
I don't completely follow you. If the reports already comes to you with
subtotals then you can not just de-activate them. They already exist.
Automated subtotals are not a formating of the data but are a physical
manipulation of the data. To get rid to the subtotals the spreadsheet must be
physically manipulated back to it's original form. So I guess the answer is
no.
 
You must log in or register to reply here.

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

Subtotal Formatting 2
Excel Subtotals 2
Divide two numbers in data subtotal function 2
Help with Subtotal Function 3
SubTotals 3
Subtotals 1
percent of row in subtotal range 1
Subtotals by Column 1

Back
Top