Copy column to another spreadsheet but get value errors

  • Thread starter Thread starter MoCollins
  • Start date Start date
M

MoCollins

I'm trying to copy a column from one spreadsheet to another but because the
cells contain functions, I get the #VALUE! error. How can I copy the cells
without this happening? Is there a way to convert the function to text?
Thanks,
 
MoCollins said:
I'm trying to copy a column from one spreadsheet to another but because the
cells contain functions, I get the #VALUE! error. How can I copy the cells
without this happening? Is there a way to convert the function to text?
Thanks,
Click to expand...


Each time you move a cell with formulars, you move the links as well. In
your case, by so doing you make excel think within an empty box, hence it
returns error!

This what you do, copy the column - and paste as values in the new worksheet
(right click your mouse, point to paste special, click on values on the left
side of the dialogue box and OK).

you should be fine now.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Function that can differentiate between text & numbers??? 6
Copy and Past Values AND Formatting AND Text 1
Copy or Move a spreadsheet 1
Paste Special Values 2
Excel VBA 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Copy Value of Active cell and 25 rows above to a diff worksheet 4

Back
Top