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

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

Thank you William

I tried that but get link back to the book I'm copying from. Perhaps the
trick is to copy all sheets at once?

Jim Kobzeff

"William" wrote in message
...
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

Apparently you didn't understand the suggestion. Copying all the sheets at
once was what William suggested. Rather than telling you how, perhaps he
should have just said that.

--
Regards,
Tom Ogilvy

"JK" wrote in message news:xPqce.15$eC.13@trnddc07...
Thank you William

I tried that but get link back to the book I'm copying from. Perhaps the
trick is to copy all sheets at once?

Jim Kobzeff

"William" wrote in message
...
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

Jim

As you say, the trick is to copy all the sheets at once.
--

XL2003
Regards

William



"JK" wrote in message news:xPqce.15$eC.13@trnddc07...
Thank you William

I tried that but get link back to the book I'm copying from. Perhaps the
trick is to copy all sheets at once?

Jim Kobzeff

"William" wrote in message
...
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