Solved problems copying formulas in excel 2010

August 14, 2016 at 05:33:13
Specs: Windows 7
I have a problem when copying cells with formula from window to a new window,excel 2010 said
the range you are pasting contains formulas that cannot be pasted into this instance of Excel;however,the formulas will be pasted
as value,,,
So how to fix this problem and I don't run skype.

best regards,

message edited by kyawmintun


See More: problems copying formulas in excel 2010

Reply ↓  Report •


#1
August 14, 2016 at 07:30:20
You might not be using two monitors but I think the following applies just the same:
http://excel.tips.net/T003404_Copyi...

Not sure where Skype comes in.

Always pop back and let us know the outcome - thanks


Reply ↓  Report •

#2
August 14, 2016 at 16:38:40
✔ Best Answer
re: "I have a problem when copying cells with formula from window to a new window"

It's not a problem, it's a feature. ;-)

I know that you are not specifically trying to use "Paste Special" but the issue described here applies to copying formulas since a formula is (more or less) an "attribute" (sort of) ;-)

In any case, call it what you want, you can't do it.

https://support.microsoft.com/en-us...

There is a macro in this thread that supposedly lets you copy formulas between instances, but I've never tried it:

http://stackoverflow.com/questions/...

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Reply ↓  Report •

Related Solutions


Ask Question