Sign in with
Sign up | Sign in
Your question
Solved

Copy and paste excel 2007

Last response: in Windows 7
Share
April 28, 2012 12:50:18 PM

When I copy and paste a formula I used to get a formula now excel pastes the result. Teh paste special is restricted so that it will only paste unicode or text

More about : copy paste excel 2007

a b $ Windows 7
April 28, 2012 1:03:04 PM

are you pasting between two different instances of excel?

if you are, then open the second sheet from file open on the first sheet. Not by starting excel again, or doubling clicking on the file. The precise way to open a file within the same instance, vs as a new instance of excel is a little random.
m
0
l
April 28, 2012 2:07:38 PM

Thanks for your reply but no it's just on the one excel sheet.

It started quite recently and sometimes it seems to clear if I switch my computer off and on again.
m
0
l
Related resources
a b $ Windows 7
April 28, 2012 2:54:26 PM

What version?

In any case when I want to copy a formula I first put a ' (beside the ENTER key) in front of the equal sign. This converts the formula into a text string. (real old spreadsheet trick)

Then copy and paste to where you want the formula. Edit as required, both the original and the new cell contents

edit: Do you get the same restrictive options when copying text as with formulas? (And I see that it is '07 version)
m
0
l
a b $ Windows 7
April 28, 2012 3:31:54 PM

you should be able to just copy and paste the formula.

Are you using = to create the formula or a shortcut like +, if you use + it does create some slightly stranger behaviour
m
0
l
April 28, 2012 4:12:35 PM

No I'm using =
m
0
l

Best solution

a b $ Windows 7
April 28, 2012 4:20:02 PM

reinstall excel if you can, its not behaving normally, as you've noted it sometimes works sometimes doesn't
Share
May 8, 2012 7:50:26 AM

Best answer selected by Djinn100.
m
0
l
!