Desktop

Ask something
Discussion Locked

Error msg in Excel

0 helpful
4 replies

by therook

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
When a user tries to apply an advance filter on a database created in Excel, the following error msg pops up: Microsoft Excel has encountered a problem and needs to close.

4 replies

by dklippert

Are they trying to copy the results to another sheet? Advanced only works on the same sheet as the data.

by therook

Once the user selects the range that she wants to filter out of the spreadsheet, she selects advance filter, which gives her two options:
a) Filter the list, in-place
b) Copy to another location

She selects copy to another location.

That's when the computer errors out.

This discussion is closed to new replies.