Subtotals Deleting Rows after removing Subtotal - 2003 Excel

R

Raul

On a weekly basis I receive a zipped Excel file that contains approximately
5000 rows of data. This file has subtotals, but when I remove the subtotals
by going into Data -> Subtotals -> and hitting the “Remove All Subtotalsâ€
button, Excel seems to delete many rows. I have verified that there is no
Macro in place and after looking at this, there seems to be no logic. I
initially thought it was deleting duplicate rows, but that’s not the case.
Please help.
 
R

Roger Whitehead

'Excel seems to delete many rows' - is it possible that there are multiple
subtotals in the data, not just the summary Grand totals at the bottom?

And/Or

Are some Sub total rows filtered out/hidden when you first open the WB?


Roger
 

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

Macro Pause to Select range then Subtotal 0
Subtotal Formatting 2
how can I insert a blank row after each subtotal in a worksheet 9
Subtotals in very large datasets 5
nested Subtotals in Excel 2007 1
Data - Subtotal error in excel 2003 1
Insert a new worksheet after subtotal 1
How can I automatically print subtotal on last row of every page? 3

Top