Combining two files together

I have two excel files that I would like to combine together. If I copy and paste from one to the other the formulas don't transfer. Is it possable to do this and how?

Originally Posted by Chuck@LCM

I have two excel files that I would like to combine together. If I copy and paste from one to the other the formulas don't transfer. Is it possable to do this and how?

Please describe what you want to do..
What are XL files ( workbooks, sheets) ?
Which formula's wont transfer?
Maybe posting an example could help