Share via

Cannot Paste Formula/Function from Excel file to another Excel file but only Value of cell can be pasted.

Anonymous
2019-08-30T21:39:21+00:00

Sometimes when I copy the cell with Excel function and try to paste to another file, it pops up: excel functions cannot be pasted and the cell will be pasted as value.

Why this happens? and how to paste excel function successfully?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-08-31T01:34:34+00:00

    Ok, but within Excel, you need to select File > Open to do so, not click on them outside of excel. I have included a screenshot of how they need to be opened.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2019-08-31T01:14:21+00:00

    Those files are at the same folder.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2019-08-31T00:41:00+00:00

    As in you need to select file open and find the file from there to open to guarantee it is in the same instance.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2019-08-30T23:59:04+00:00

    What is same instance of excel?

    Both files are open.

    Was this answer helpful?

    0 comments
  5. Anonymous
    2019-08-30T22:55:03+00:00

    Hi, I'm Amanda, an Independent Advisor. I'm happy to try and assist you today.

    It appears you need to open the files in the same instance of excel.

    https://docs.microsoft.com/en-us/office/trouble...

    Was this answer helpful?

    0 comments