Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why does excel DELETE rows of data when removing subotals?
I have been using a spreadsheet for months and every month when I update I
add subtotals and distribute. To update for the new month I remove subtotals, update data and re add the subtotals. However, this month when I remove the subtotals all data is deleting except for data above the first subtotaled line. I am using Excel Professional Edition 2003 and am stumped. Thank you. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why does excel DELETE rows of data when removing subotals?
Maybe the rows are hidden and not deleted.
-- http://HelpExcel.com "Karen" wrote: I have been using a spreadsheet for months and every month when I update I add subtotals and distribute. To update for the new month I remove subtotals, update data and re add the subtotals. However, this month when I remove the subtotals all data is deleting except for data above the first subtotaled line. I am using Excel Professional Edition 2003 and am stumped. Thank you. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why does excel DELETE rows of data when removing subotals?
nope, they literally all disappear below where the first subotatl was. All
of my other excel files with the same type of subtotaling work fine. "Karen" wrote: I have been using a spreadsheet for months and every month when I update I add subtotals and distribute. To update for the new month I remove subtotals, update data and re add the subtotals. However, this month when I remove the subtotals all data is deleting except for data above the first subtotaled line. I am using Excel Professional Edition 2003 and am stumped. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I delete blank rows from excel without selecting them? | Excel Worksheet Functions | |||
Manual control of link updating for downloaded quotes? | Excel Discussion (Misc queries) | |||
resetting last cell | Excel Discussion (Misc queries) | |||
Excel: How to choose data on two separate rows in the same column | Excel Worksheet Functions | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions |