Creating a blank when links can't update

C

cs_weirdo

Is there any way to change a field to a blank when a link cannot be
updated?

I have a series of worksheets that pull their information from other
excel spreadsheets in a directory. When there aren't any files in that
directory, I don't want my spreadsheet showing old information - I want
the sheets corresponding to missing files to be blank.

Thanks!

-Eleanor
 
Top