Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a blank when links can't update | Links and Linking in Excel | |||
Edit Links: make update manual | Excel Discussion (Misc queries) | |||
can't update links...can't find links | Excel Discussion (Misc queries) | |||
Manually update links | Excel Worksheet Functions | |||
Update Individual Links | Excel Discussion (Misc queries) |