B
Brian
Hi everybody,
I've created an Excel spreadsheet containing a list of documents, with
hyperlinks to file locations on the local intranet. The spreadsheet
works 9 times out of 10, but on the 10th time, the spreadsheet returns
"The internet site reports that the item you requested could not be
found." This is usually because the filetype (read: extension) is of a
different type. I'm wondering if there is a way for Excel to determine
whether the file exists on the server, and if not (ie IsError), returns
an alternate filename.
Thanks in advance for your help.
Brian
I've created an Excel spreadsheet containing a list of documents, with
hyperlinks to file locations on the local intranet. The spreadsheet
works 9 times out of 10, but on the 10th time, the spreadsheet returns
"The internet site reports that the item you requested could not be
found." This is usually because the filetype (read: extension) is of a
different type. I'm wondering if there is a way for Excel to determine
whether the file exists on the server, and if not (ie IsError), returns
an alternate filename.
Thanks in advance for your help.
Brian