J
JK
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
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