Make sure that both spreadsheets are opened in the same instance...
To test
Copy something
go to the other workbook
right click and choose Paste Special... do you see all options (means same
instance) like Values, Formats etc. or only limited ones (means separate
instances) like paste as text,...?

Try this
Open the first workbook
Open the second using the File-Open command from within Excel

Try pasting... it should work

To open all workbooks in same instance try this;
Close Excel first and On the Windows Taskbar

1) Start-Run- excel.exe /unregserver -OK.
2) Start-Run- excel.exe /regserver -OK.

See the space between exe and /regserver

You might have to designate a full path to excel.exe (most likely C:\Program
Files\Microsoft Office\Office11)

In that case Start-Run- "C:\Program Files\Microsoft
Office\Office11\excel.exe" /regserver - OK

Note: 1. quotes are required because of spaces in the path
2. Office11 means Excel 2003. Excel 2007 is Office12

"robin l" wrote:

Can I send someone my spreadsheet - pasting from one spreadsheet to another
is not working. Dates and other data do not paste correctly and all my
data gets corrupted.

Thanks,

Robin