Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
replacing worksheets
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
replacing worksheets
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 wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
replacing worksheets
On Sep 5, 6:45 am, Dave Peterson wrote:
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 wrote: 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- Hide quoted text - - Show quoted text - thanks Dave. that's exactly what I needed and it works fine. ed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replacing #N/A | Excel Worksheet Functions | |||
Replacing #DIV/0! With Just 0 | Excel Worksheet Functions | |||
Replacing #N/A with a '0' (zero) | Excel Worksheet Functions | |||
replacing #N/A with 0 | Excel Discussion (Misc queries) | |||
Help Replacing all ( * ) with ( - ) | Excel Discussion (Misc queries) |