That means that you have two separate instances of Excel... that is why you
get this problem only 'sometimes'...

One way to fix the problem is -
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\Office12)

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

Note that quotes are required because of spaces in the path
-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"Deriv001" wrote:

It doesn't give you the option to save special. Just as as an object or
picture or bitmap.

"Sheeloo" wrote:

If you want to preserve the formatting then right-click and choose Paste
Special then choose Values...(or Formulas if you also want to copy formulas)

-------------------------------------
Pl. click ''''Yes'''' if this was helpful...

"Deriv001" wrote:

Occasionally when pasting between two 2007 spreadsheets, I will lose all the
formating on the spreadsheet I am pasting to. Is there a way to recover the
formats that are lost? (in this case, both files are open in the same Excel
2007 window)
Thank you