That's the way Excel behaves when you do the copying
You could try it in this manner:
1. Use EditReplace to change all equal signs, viz: = to say: zzz in the
entire sheet
2. Copy the sheet over into the new book, then reverse the process there by
using EditReplace to change all: zzz back to equal signs: = in the entire
sheet
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Tail Wind" wrote:
I have two workbooks open and trying to copy a worksheet from one to
another. I am using the Right click on the tab name, Move or Copy, and
selecting copy checkbox. The copy occurs however the formulas refer to the
orginial workbook which is undesired.
In reading this forum, this should not be occuring. What am I doing wrong?