At work me and another coop have been given the job of creating more of a central database of all the drawings we have in our technical library used by the MBTA. Most of the drawings are currently on a shared network drive. We want to create an excel file that acts as a database to make it easy to find drawings by DWG # or Drawing Description. Then next to that put in a hyperlink to the image so that you can just click the link from the excel file and have the image file open up. The problem I'm facing is the excel file just will not open up any of the files on network drive. I can open word documents, pdfs, image files (jpeg and tif), and so on if they are on the local C drive, but not on the network drive. If I try opening up one of the tif files on the network drive through the hyperlink in excel it will start up the program (in this case PS CS2) but not the actual image. If I turn the default program for .tifs to the Windows Picture and Fax Viewer then nothing happens at all after clicking the link.
Any ideas?
Any ideas?