Creating a blank when links can't update
 

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


--
cs_weirdo
------------------------------------------------------------------------
cs_weirdo's Profile: http://www.excelforum.com/member.php...o&userid=24341
View this thread: http://www.excelforum.com/showthread...hreadid=379410