filter
 

I have made a filter in huge data based ( sort A to Z ) tow weeks before, but
when I clear the filter, but the data didn't comeback as it was as before in
the original order.

how can I get it solved?

filter
 

Filter will not rearrange data. Was the data sorted while it was filtered?

"Misho" wrote:

I have made a filter in huge data based ( sort A to Z ) tow weeks before, but
when I clear the filter, but the data didn't comeback as it was as before in
the original order.

how can I get it solved?

filter
 

If you saved the workbook with the data sorted your only recourse is to dig
out the backup copy.

If you did not save, close without saving.


Gord Dibben MS Excel MVP

On Thu, 21 May 2009 02:34:01 -0700, Misho
wrote:

I have made a filter in huge data based ( sort A to Z ) tow weeks before, but
when I clear the filter, but the data didn't comeback as it was as before in
the original order.

how can I get it solved?

filter
 

Hi Sean Timmons,

Thanks for your response,

I'm note sure, as my brother was working on it last week and save it.

and when I clear the sort and the filter, it doesn't returned to the order,
as there wasn't a reference to my data, as I was Depending on the Excel
reference


"Sean Timmons" wrote:

Filter will not rearrange data. Was the data sorted while it was filtered?

"Misho" wrote:

I have made a filter in huge data based ( sort A to Z ) tow weeks before, but
when I clear the filter, but the data didn't comeback as it was as before in
the original order.

how can I get it solved?

filter
 

If data was sorted while filtered, it doesn't always sort the entire table.
Best thing you can do now is sort the data with the filter set to show all or
removed...

"Misho" wrote:

Hi Sean Timmons,

Thanks for your response,

I'm note sure, as my brother was working on it last week and save it.

and when I clear the sort and the filter, it doesn't returned to the order,
as there wasn't a reference to my data, as I was Depending on the Excel
reference


"Sean Timmons" wrote:

Filter will not rearrange data. Was the data sorted while it was filtered?

"Misho" wrote:

I have made a filter in huge data based ( sort A to Z ) tow weeks before, but
when I clear the filter, but the data didn't comeback as it was as before in
the original order.

how can I get it solved?