Ask a Question
or
Create a Poll
  1. Home /
  2. Questions /
  3. Computers
  4. / Computer Software
  5. / Spreadsheet Software
  6. / Microsoft Excel

by kate on March 5th, 2009

kate

Question

Help answer this question below.

In Excel, when I try to copy and paste special, from one workbook to another workbook, it gives me the window that infers you are copying to other office programs, even though they are both Excel spreadsheets. All I want to copy are the formulas. Help?

  • Like
  • Report
Share:
Other

Answers. 2 helpful answers below.

  • by Cyanotic Wasp on March 6th, 2009

    Cyanotic Wasp

    Are both workbooks open in the same Excel "session"? That is, if you go to the menu command for "Windows", can you see both files listed there? Sometimes when we open files from Windows Explorer (or have files created from other applications, such as exports from databases, etc.) that creates a new "session" of Excel that prevents a simple copy-paste operation from one workbook to another in the same session.

    Another way to do the copy is to put the cursor directly into the Formula Bar, the select and copy the literal text of the formula to the same Formula Bar in the target sheet. That sometimes overcomes limitations in the copy / paste operation.

    But like Brian said, just look at your target cell after you've completed the paste. Don't just look at the value that's there, look to see if the formula is a match.

    No comments. Post one | Permalink

  • by Brian I on March 6th, 2009

    Brian I

    If you only want to copy formulas from one workbook to another you don't need Paste Special, you just need paste.

    2 comments | Post one | Permalink

Want to attach an image to your answer? Click here.

Did this answer your question? If not, then ask a new question or create a poll.

More Questions. Additional questions in this category.

You're reading In Excel, when I try to copy and paste special, from one workbook to another workbook, it gives me the window that infers you are copying to other office programs, even though they are both Excel spreadsheets. All I want to copy are the formulas. Help?

Follow us on Facebook!

Related Ads

Related Questions

Professionally Researched

ANSWERBAG BUZZ

Copy paste from one workbook to another only get values not formula
Excel paste literal formula
Copy formulas from excel session to another
Excel paste special from another workbook
Excel copy formulas from one workbook to another but doesn t copy the formula

Answerbag

a Demand Media company