copy between worksheets does not copy formulae just values
 

Something strange has happened to my Excel 2003 installation.

The problem I am having is that I cannot copy & paste cells between
worksheets. When I use copy & paste it simply copies over the values. I have
then tried using paste special but I do not get the usual menue where you can
select what you want to copy, i.e. values, formulae, format etc. i just get a
box that offers to post as a bitmap, text etc.

I have accessed the same spreadsheet over my home network on my lap top and
it all works fine. I have run a repair on Office 2003 but that does not make
any difference.

I do not know if it is related but I am also having problems on the same
spreadsheet (hence my reason for trying to put together another version) with
unrequested hyperlinks appearing taking me to other worksheets in the
workbook.