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

ra-aza

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: 1 year ago.
Category: Microsoft Office
Expert:  John D replied 1 year ago.

Hi,

 

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 1 year 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 1 year 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 1 year 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 1 year ago.
Is there some setting in Excel that I can tell excel to not create a link when copying?
Expert:  John D replied 1 year 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 1 year 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 1 year 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 1 year 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 1 year 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 1 year ago.
I just came back to this computer and my attempt didn't work; however, I'll try what you just suggested.
Customer: replied 1 year 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 1 year ago.

Again IT IS NOT AN EXCEL 2010 ISSUE. PERIOD

 

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 1 year 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 1 year 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

 

Thanks

 

Customer: replied 1 year 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 1 year 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 1 year ago.
I think I tried that this morning but will give it another shot. I'll get right back to you.
Expert:  LeGin replied 1 year ago.
Sure.

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... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...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
< Last | 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's Avatar

    jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
< Last | Next >
  • http://ww2.justanswer.com/uploads/JS/jstinehelfer/2012-6-6_215146_Pictureofme1.64x64.png jstinehelfer's Avatar

    jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
  • http://ww2.justanswer.com/uploads/JA/JasonJames122/2011-12-16_135647_jasonjamesheadshotweb.64x64.jpg JasonJames122's Avatar

    JasonJames122

    Computer Enthusiast

    Satisfied Customers:

    0
    I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business
  • http://ww2.justanswer.com/uploads/JE/jessmagz/2012-6-6_18129_jm.64x64.jpg Jess M.'s Avatar

    Jess M.

    Computer Support Specialist

    Satisfied Customers:

    270
    Computer Software Specialist for more than 10 years
  • http://ww2.justanswer.com/uploads/CH/chutz747/2011-11-6_14231_me.64x64.jpg The-PC-Guy's Avatar

    The-PC-Guy

    Computer Manager

    Satisfied Customers:

    260
    20 years experience providing remote computer support
  • http://ww2.justanswer.com/uploads/SE/Seashore2011/2011-12-6_33418_111205223015.64x64.jpg Chris L.'s Avatar

    Chris L.

    Support Specialist

    Satisfied Customers:

    120
    Certified Expert with over 10 years experience.
  • http://ww2.justanswer.com/uploads/SP/spherrod/2012-6-6_174244_1000852.64x64.JPG Steve Herrod's Avatar

    Steve Herrod

    Computer Support Specialist

    Satisfied Customers:

    116
    Trained in Microsoft Office from 2000 through to latest version 2010.
  • http://ww2.justanswer.com/uploads/KR/krkljatorm/2012-6-24_153417_ITMiro.64x64.jpg IT Miro's Avatar

    IT Miro

    Computer Scientist

    Satisfied Customers:

    94
    Bachelor's Degree in Information Technology, Microsoft Certified Professional