May 29 2006
Q: Why do I get '#REF!' or '0's when I copy data from one Excel spreadsheet to another?
A: When you copy data from one spreadsheet to another you are just copying the formulas and not the data.  There is a way to copy and paste only the Data using a feature called Paste Special. 

Here’s how you use it:
-In Excel
1. Highlight/Select the data you want to copy
2. Edit > Copy
3. Open a new spreadsheet (or even an existing one)
4. Place the cursor where you want the Data to be inserted
5. Edit > Paste Special…
6. Select ‘Values’
7. Click ‘OK’