I use 2 laptops and share spreadsheets between them. A problem I had on one laptop is now happening on the other.

In some spreadsheets, the copy function does not work properly. When I right click to select copy I can see that the Paste options available are restricted. Then, when I try to paste I can only paste the contents (I only get the box with the letter A in it)- the options to paste formulae, format etc are not avaiable. If I select Paste Special I get a dialogue box with the options to paste as Unicode text or just text.

More and more spreadsheets are falling foul of this. What causes it and how can I stop it? I hope I can because I have some complicated formulae I need to copy - rewriting long hand would be a nightmare!

Any help greatly appreciated.

Flybridge