• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 247
  • Last Modified:

Absolute reference formula not copying to cell in Excel 2007. How to do it?

Please look at attached. I put an absolute reference formula in A10,which I am trying to copy to A19. However, all I get in A19 is the value, not the formula, as evidenced by the formula bar. Please advise as to what I am doing incorrectly. Thanks in advance.AABB.png
  • 2
2 Solutions
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:

do you have Skype installed?

There is  currently an issue with Paste Special that causes formulas to be pasted as values instead of the formulas. The browser plug-in for skype upsets the "Paste Special" functionality and defaults to pasting values instead of formulas. You may want to remove the  browser plug-in for skype (no need to uninstall skype itself). See here for details: http://www.thecodecage.com/forumz/hot-topics/212321-paste-paste-special-issues-office.html

cheers, teylyn
Right click on the cell where you want to paste.. select paste special.. then say formula..
sheana11Author Commented:
Absolute formula is in F10, not A10, sorry!
sheana11Author Commented:
I actually forgot to put the $ sign in front of each row and column reference....I only put it in front of one of the cell coordinates.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now