Hi LF,

The way around this would be to create all the required worksheets in the
new workbook, with the same names as in the source workbook, then CUT (not
copy) & paste the source workbook's contents into the new workbook, after
which you close the source workbook without saving the changes.

Cheers

--
macropod
[MVP - Microsoft Word]


"LF" wrote in message
...
Ooops. How can I get this to be correct? I mean, cannot a formula be
incorrect for a while until I also copy over the rest of the sheets? Can I
adjust the formulas after copying. Any solution?

"macropod" wrote in message
...
Hi LF,

I am not sure I understand. When you copy over from one worksheet to
another, don't you simply copy the formulas?

If you have a formula on Sheet1 that refers to Sheet2, for example, the
copied formula will point to Sheet2 in the original workbook, not Sheet2
in
the copy.

Cheers

--
macropod
[MVP - Microsoft Word]