Hi Jim

Unhide any hidden sheet in the current workbook.
Select all the sheets, right click on one of the sheet tabs and select "Move
or Copy".
Place a check mark against "Copy".
Select the destination workbook from the dropdown list and that should do
it.
--

XL2003
Regards

William



"JK" wrote in message news:wYece.19162$yc.11755@trnddc07...
I was told that it is a good idea to create a new WB for an excel
application that has been in revision for 3-4 years. Seemingly, it clears
out any bugs that might have developed after countless changes, etc. Moving
forms and modules is easy, but how can I copy the sheets to the new
workbook without my formulas making a reference to the old workbook.
Example: the formulas in my HideAll sheet (where most calculations take
place) end up like =[old.xls]Sheet1!$A$1 instead of =Sheet1!$A$1. This one
should be easy, but it's driving me crazy because I can't figure it out.
Please help. Thank you.

Jim Kobzeff