Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting rows in Excel 2007 using filters
I'm having trouble deleting rows in Excel 2007 using filters. I have a large
volume of data from another program which I import in Excel and a simple macro went through and deleted all the garbage lines. I encountered a problem moving from Excel 2003 to 2007 as when highlighting all the rows it deleted all of them not just the visible rows. I started to overcome this using the Show visible cells option, but I'm now getting the message "Microsoft Office Excel cannot create or use the data range reference because it is too complex". I would happily go back to Excel 2003, but I have a lot more than 65,000 rows of data. Any other suggestions? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting rows in Excel 2007 using filters
Do you think you could post a simple set off step by step instructions on
how to recreate this problem? Assume that none of us has access to the data you're using, etc. -- Jim "Bentam7" wrote in message ... | I'm having trouble deleting rows in Excel 2007 using filters. I have a large | volume of data from another program which I import in Excel and a simple | macro went through and deleted all the garbage lines. I encountered a | problem moving from Excel 2003 to 2007 as when highlighting all the rows it | deleted all of them not just the visible rows. I started to overcome this | using the Show visible cells option, but I'm now getting the message | "Microsoft Office Excel cannot create or use the data range reference because | it is too complex". | I would happily go back to Excel 2003, but I have a lot more than 65,000 | rows of data. | Any other suggestions? | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
nonblank filters in excel 2007 | New Users to Excel | |||
Data filters in Excel 2007 not working for one file | Excel Worksheet Functions | |||
Excel 2007 OLAP Pivot table Row Filters | Excel Discussion (Misc queries) | |||
deleting sheets in Excel 2007 ( Beta 2 ) | Excel Worksheet Functions | |||
deleting sheets in Excel 2007 ( Beta 2 ) | Excel Worksheet Functions |