View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob
 
Posts: n/a
Default 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