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,
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.