Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Links / July 2005

Tip: Looking for answers? Try searching our database.

Creating a blank when links can't update

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
cs_weirdo - 14 Jun 2005 16:02 GMT
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

Signature

cs_weirdo

ScottO - 13 Jul 2005 06:53 GMT
From your description I'm making a few assumptions:
1. You have a directory that periodically has some workbooks placed in it
with updated data.
2. Each time the updated files are placed in the directory they have the
same names as they did previously.
3. When the data gets out of date, the source files are deleted from the
directory.

If my assumptions are correct, you may be able to get the effect that you're
after by creating a dummy set of source files which are all blank and each
time that you want to delete a set of "out of date" files, simply overwrite
them with the blank dummy set.
Next step is to change the update link settings in your dependant file(s) to
force an update whenever they're opened => references to blanks.
You may need to adjust the formulas in the dependant file(s) to cope with
the sudden appearance of the blanks where regular data is expected.

Rgds,
ScottO

| Is there any way to change a field to a blank when a link cannot be
| updated?
[quoted text clipped - 10 lines]
| --
| cs_weirdo
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.