I have a problem where I copy from a cell (or group of cells) in one workbook and then try to paste special on the same workbook. Instead of seeing "All", Formulas", "Values" etc all I get are file types like "unicode" "text" etc..
There is only instance of excel 2007 running and only one workbook.
The copy and paste is from within the same workbook.
I have tried the unregister and register switches, no difference.
The "Ignore other applications..." switch under advanced settings makes no difference.
When I do the copy part the cell/cells are not highlighted as normal but a normal paste works fine.
Any help would be much appreciated. I'm pulling my hair out.
There is only instance of excel 2007 running and only one workbook.
The copy and paste is from within the same workbook.
I have tried the unregister and register switches, no difference.
The "Ignore other applications..." switch under advanced settings makes no difference.
When I do the copy part the cell/cells are not highlighted as normal but a normal paste works fine.
Any help would be much appreciated. I'm pulling my hair out.