Thread: why does excel DELETE rows of data when removing subotals?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
galimi galimi is offline
external usenet poster
  
Posts: 210
Default 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.
Reply With QuoteReply With Quote