Blanks in spreadsheet
 

Hi
I have a source spreadsheet which is dynamically linked to a target
spreadsheet using paste link option. But all the blanks in the source as are
appearing as 0s which I want as empty cells. How can I do this.

2.Can I do fill series on links in my target xls? I tried it currently but
it errors as the values are link address and not text or numbers.

Please inform.

Thanks
Bob

Blanks in spreadsheet
 

Test it in the link

=IF(Target!A1="","",Target!A1)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Bob" wrote in message
...
Hi
I have a source spreadsheet which is dynamically linked to a target
spreadsheet using paste link option. But all the blanks in the source as
are
appearing as 0s which I want as empty cells. How can I do this.

2.Can I do fill series on links in my target xls? I tried it currently but
it errors as the values are link address and not text or numbers.

Please inform.

Thanks
Bob