I am facing issue in copying data from one excel to another.I cannot do paste,where as paste special works fine for me.I am having MS 2007.
To clarify: If I copy from an excel spreadsheet/workbook. Then open a completely different spreadsheet workbook, in other words I opened another session of excel, then the copy and paste will not work.
If I open multiple excel documents will in the same excel workbook, it will copy and paste correctly.
Could you guys help?