deleted rows still show up in report

  • Thread starter Thread starter Keith G Hicks
  • Start date Start date
K

Keith G Hicks

This is something I've experienced for many years but never really worried
about until now. It's become a problem for some automation I'm doing using
xlt files. If I have data in rows that I want to remove and then I highligth
those rows using the row numbers column and then right click to get the
delete option (not the DELETE key) the rows are gone. But let's say that I
have a header row and 500 rows below that with info in them. I delete the
500 rows. Then I run a preview of the report (where the grid shows). I end
up with blank pages when I preview or print this. I should expect only to
get the header row. How can these rows REALLY be deleted so they are not
ghosts in the sheet? (no pun intended).

Thanks,

Keith
 
Back
Top