I am trying to copy values from one workbook (apps 2006-07) into a new
version of the same workbook (apps 2007-08) but the paste special option only
creates a link to the original formula in the first workbook, e.g. =(('[APPS
2006-07.xls]season apps'!C4))+42.

I want to add the values created in the original workbook to the same
formula in the new book to produce a new list of values. The values are
calculated in the original workbook by a simple SUM formula: =('season
apps'!C4)+32 which adds the value from one sheet to a constant value. I want
to do the same in my new workbook without this being linked to the original
workbook. I ams ure I ahve done this in the past but Excel doesn't seem to
want to play this year!