replacing worksheets

[ed]

Excel 97 or 2003, I have a Workbook with multiple worksheets available
to several people on their computers. There is a Worksheet AW in
Workbook A. I want to revise worksheet AW and make it available to
users of Workbook A without totally replacing their workbook A which
has about 10 other worksheets (x, xx, xxx) and a lot of independent
data. In other words, I want their original Workbook A to get the
new worksheet AW, without replacing the entire Workbook A and/or its
other Worksheets x, xx, xxx, etc.

Worksheet AW has formulas referring to cells in other Worksheets of
Workbook A, and still other Worksheets of Workbook A have cells with
formulas refering to cells in Worksheet AW.

How can I make the new Worksheet AW available to all the users to
replace the original Worksheet AW in their Workbook A's with the new
worksheet AW? Whatever I try requires that they go through all the
formulas and delete referrences to whatever Workbook I created the new
AW in. They also get multiple errors in the other Worksheets of
Workbook A that refer to Woriksheet AW.

I need some way to e-mail them the new AW Worksheet with a simple way
for them to replace the old AW Worksheet, and with all the formulas of
the new AW referring to the same Ax Worksheet, and all the formulas of
A's Worksheets referring to the new AW Worksheet cells.

Thanks a bunch in advance.

ed

 

[Dave Peterson]

One way that may work for you...

Create the new worksheet AW.
Make all the changes you need.
Right before you send it to the users, convert all your formulas in that
worksheet to plain old text (not convert to values).
Select all the cells
Edit|Replace
what: =
with: $$$$$=
replace all

Now your formulas are plain old text and don't have any links to anything.

Tell the recipients that they don't replace the existing worksheet with the new
worksheet. Instead they copy all the cells in the new AW and paste those "text
formulas" into the existing AW.

Then tell them to convert the text formulas to real formulas:

Edit|Replace
what: $$$$$=
with: =
replace all

=====
Test it with a single user while you write up the instructions for the rest.

 

[ed]

One way that may work for you...

Create the new worksheet AW.
Make all the changes you need.
Right before you send it to the users, convert all your formulas in that
worksheet to plain old text (not convert to values).
Select all the cells
Edit|Replace
what: =
with: $$$$$=
replace all

Now your formulas are plain old text and don't have any links to anything.

Tell the recipients that they don't replace the existing worksheet with the new
worksheet. Instead they copy all the cells in the new AW and paste those "text
formulas" into the existing AW.

Then tell them to convert the text formulas to real formulas:

Edit|Replace
what: $$$$$=
with: =
replace all

=====
Test it with a single user while you write up the instructions for the rest.











--

Dave Peterson- Hide quoted text -

- Show quoted text -

thanks Dave. that's exactly what I needed and it works fine.

ed