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