How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask LeGin Your Own Question

LeGin, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 755
Experience:  BSc (Computer Science)
Type Your Microsoft Office Question Here...
LeGin is online now
A new question is answered every 9 seconds


Customer Question

In Excel 2010, how do you copy formulas from one spreadsheet to another without it creating a link in the pasted into spreadsheet?
Submitted: 4 years ago.
Category: Microsoft Office
Expert:  John D replied 4 years ago.



Try selecting the cell that has the formula, then click inside the Formula Bar and highlight the entire formula and copy it.


Then open the other workbook, select the cell that you want to paste the formula in, then click inside the Formula Bar and paste it there


Hope this helps. If I was able to answer your Question please go ahead and RATE this answer "Excellent" or "Good" so I get credit for my work.


Customer: replied 4 years ago.
I'm talking about 600 formulas, doing that isn't feasible. I need something that will do all the formulas at once. It was easy in Excel 2003, I don't understand why the copy and paste creates a link
in 2010. If I wanted the link I would just do cut and paste.
Expert:  John D replied 4 years ago.

Your question was not about 600 formulas. It was about copying the formula without a link


Now to automate the process so it can copy as many cells as you like you will need a macro created for that




Customer: replied 4 years ago.
So, something that was very simple in Excel 2003 now requires a macro. That's not going to work either because there are dozens of spreadsheets I have to do this with. I'm thinking of reloading Excel 2003 and dumping 2010 if the only answer is a macro.
Customer: replied 4 years ago.
Is there some setting in Excel that I can tell excel to not create a link when copying?
Expert:  John D replied 4 years ago.

No I think there is some misunderstanding here. If you were able to do that copy procedure in Excel 2003 you should be able to do the same in Excel 2010.


Could outline the steps that you did it in Excel 2003 so I can understand exactly what the issue is





Customer: replied 4 years ago.
Ok, in excel 2003, I would highlight a series of cells with formulas in them, say tab X cells C1:C1000, then copy. I'd then go to another spreadsheet and click tax X cell C1 and then Paste. All the formulas would then calculate based on the second, pasted into, spreadsheet.

If I wanted to link them, I'd have done the exact same thing expect used Cut instead of Copy.

With 2010, when I do the exact same thing that I did in 2003, it's acting as a 2003 Cut and Paste and creating a link, the only difference being it now leaves the formulas in the original spreadsheet and creates the link. I don't want that, I want the formulas to work with the spreadsheet it was pasted into, not the information that it was pasted from.

I've been wrestling with this since 8am this morning and I'm pulling my hair, I'm really sorry I got the Excel 2010 at this point! but that's not your fault.
Expert:  John D replied 4 years ago.

No you must have different types of formulas in the two cases or the two workbooks are not opened from the same instance of Excel. If you can send me the file in which the copy procedure works in Excel 2003 I will show that it will work in Excel 2010 for the same formulas



Customer: replied 4 years ago.
Unfortunately, I can't send you the files, the information on them is unclassified but sensitive information by the US Government and I can't share them. However, you may have given me a clue, there is some mixing of Excel 2003 and 2010 files. If I save them all as one or the other that may solve the problem and I'll be able to do the copying? Let me try that and I'll get back to you in a few minutes.
Expert:  John D replied 4 years ago.

And make sure you open both the source file and the destination files from the same instance of Excel (from within Excel using File > Open command and not by double clicking the file icons in your folder)


Customer: replied 4 years ago.
I just came back to this computer and my attempt didn't work; however, I'll try what you just suggested.
Customer: replied 4 years ago.
No that didn't work either. I"m stumped, it seems like Microsoft took out that functionality. I don't know where to go from here other than to reload Excel 2003 and dump 2010 because there is just too many things I have to do like this to put up with this loss in functionality. You'd mentioned a macro, are you suggesting putting one in the pasted into spreadsheet that will remove the links or what?
Expert:  John D replied 4 years ago.



You are not willing to send me the file so I am not sure how else I can prove it to you


Have a great day


Customer: replied 4 years ago.
If I send you two blank spreadsheets with simple formulas in them would that work as an example? If so, what's your e-mail address or how would I share them with you?
Expert:  John D replied 4 years ago.

I will continue to assist if I can make sure I get credit for my time, and if the issue gets resolved you can add bonus later. Otherwise I will opt out to allow others to assist




Customer: replied 4 years ago.
Well, tell me this, can you take a formula from one spreadsheet to another in Excel 2010 and not have a link in the receiving spreadsheet? If so, how do you do that without a manual manipulation of each individual formula. If that can't be done then I agree about the opting out, if you can do that tell me how and you'll be given credit. Let me know. Thanks.
Expert:  LeGin replied 4 years ago.
Highlight all the formula cell
Press Ctrl + C to copy
goto the sheet where you want to paste and
Right click > paste Special > formula.

Let me know if that helped.
Customer: replied 4 years ago.
I think I tried that this morning but will give it another shot. I'll get right back to you.
Expert:  LeGin replied 4 years ago.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
< Previous | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
  • Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland

Meet The Experts:

  • jstinehelfer


    Information Systems Manager

    Satisfied Customers:

    A+ Comptia Certified computer repair
< Last | Next >
  • jstinehelfer's Avatar


    Information Systems Manager

    Satisfied Customers:

    A+ Comptia Certified computer repair
  • JasonJames122's Avatar


    Computer Enthusiast

    Satisfied Customers:

    I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business
  • Jess M.'s Avatar

    Jess M.

    Computer Support Specialist

    Satisfied Customers:

    Computer Software Specialist for more than 10 years
  • The-PC-Guy's Avatar


    Computer Manager

    Satisfied Customers:

    20 years experience providing remote computer support
  • James K.'s Avatar

    James K.


    Satisfied Customers:

    Technical Director of IT Company
  • IT Miro's Avatar

    IT Miro

    Computer Scientist

    Satisfied Customers:

    Bachelor's Degree in Information Technology, Microsoft Certified Professional
  • Chris L.'s Avatar

    Chris L.

    Support Specialist

    Satisfied Customers:

    Certified Expert with over 10 years experience.

Related Microsoft Office Questions