Excel 2007 : Cannot copy/delete cells because they are too complex

[opg]

Hi all, Im encountering a problem when I try to copy a database to another worksheet after applying an Auto filter on it I tried to copy it in many different ways. I dont know whats wrong this has never came up before the prompt Im getting is :

Microsoft Excel cannot create or use the data range reference because it is too complex.


If someone can help me with this it would be heavily appreciated!


Thanks for the help in advance and happy new years!