Hi,

I have linked directly to a spreadsheet being used by a team that I then want to then work out some calculations on.

Simply (eg) cell A1 in their spreadsheet will be A1 in mine.

However, where there is a blank in their spreadsheet it's appearing in mine as 00-Jan-00 (or 00-01-1900 when filtering). Is there some simple way of linking the cells but not to carry across the blanks / make them appear as blank or zero even?

Many thanks,

B.