software

I want to set up an Excel workbook with multiple worksheets. I want to have
one column repeat on each new worksheet I set up in the workbook so that any
changes or additions made to the column on the original worksheet
automatically update all other worksheets in the workbook. I have tried to
use the quot;Paste Specialquot; - quot;Paste Linkquot; commands in the Edit menu, but blank
cells in the original worksheet column show up as quot;0quot; in the pasted column
even with the cel format set to quot;Textquot;.

Hi danmc- In Excel 2002,-Tools, Options, View tab, Zero Values option may help.

PBquot;danmc1000quot; wrote:

gt; I want to set up an Excel workbook with multiple worksheets. I want to have
gt; one column repeat on each new worksheet I set up in the workbook so that any
gt; changes or additions made to the column on the original worksheet
gt; automatically update all other worksheets in the workbook. I have tried to
gt; use the quot;Paste Specialquot; - quot;Paste Linkquot; commands in the Edit menu, but blank
gt; cells in the original worksheet column show up as quot;0quot; in the pasted column
gt; even with the cel format set to quot;Textquot;.

Boy, do I feel dumb. Forgot all about the View Options. Thanks for your help.

quot;PancakeBatterquot; wrote:

gt; Hi danmc- In Excel 2002,-Tools, Options, View tab, Zero Values option may help.
gt;
gt; PB
gt;
gt;
gt; quot;danmc1000quot; wrote:
gt;
gt; gt; I want to set up an Excel workbook with multiple worksheets. I want to have
gt; gt; one column repeat on each new worksheet I set up in the workbook so that any
gt; gt; changes or additions made to the column on the original worksheet
gt; gt; automatically update all other worksheets in the workbook. I have tried to
gt; gt; use the quot;Paste Specialquot; - quot;Paste Linkquot; commands in the Edit menu, but blank
gt; gt; cells in the original worksheet column show up as quot;0quot; in the pasted column
gt; gt; even with the cel format set to quot;Textquot;.