Pasted Links retuns "0" when the cell is blank

[Jerk24]

Good morning

I have a workbook which has 12 sheets which have pasted links from 12 separte workbooks. How can i get the workbook link to return blank cells?

 

[Snakehips]

Jerk24,

I'm assuming 2007 or above so try....

Excel Options >> Advanced >> Display options for this worksheet

Select sheets in drop down and Un-Tick 'Show a zero in cells that have zero value.

Hope that helps.

 

[Jerk24]

Snakehips.

I am running 2003. for a quick (sometimes) fix i would find and replace the blank cells with a space and that works.any tips for 2003?

 

[Jerk24]

Snakehips

I am sorry, I did find the block that says Show a zero in cells that have zero value. thank you.

 

[Snakehips]

Jerk,

For 2003 try....

Tools >> Options >> the 'View' tab and Un-Tick 'Zereo Values' in the Window options section at the bottom.