For reference, I'm using Office Professional Plus 2013
As a quick background, my company works in retail construction management. When we are building a new store, we go out to a bunch of plumbers, for example. We'll get a bid from 4 or 5 plumbers on how much it will cost them to do the job.
We keep all of that information on a spreadsheet that has their company and contact information, but also the bid amount. In the office, we are on a shared network, so everyone could open this spreadsheet from their own computer. We occasionally will make the worksheet a shared document so that we can have multiple people editing, but not always. If we don't, a second person could have it open at the same time, but only as "Read-Only".
When we receive a bid, we either get it in PDF format, or scan it and turn it into a PDF. Those bids are then saved on our network.
I was trying to make a way that you could see the bid information without navigating through folders to find the PDF you wanted. My solution to this was to hyperlink the prices, so that when you were in the job spreadsheet, you could click on the price, and the PDF bid would pop up.
Example: Imgur: The most awesome images on the Internet
This worked really great on my computer. When I created it, the hyperlink destination looked like this:
Imgur: The most awesome images on the Internet
But as soon as someone opened it on another computer, everything broke somehow. The hyperlink destination then ended up looking like this:
Imgur: The most awesome images on the Internet
(Ignore the fact that the last part of the file extension, after the 'Bids' folder, is different. I accidentally took screenshots of two different companies)
But as you can see, without moving the location of the PDFs, and without changing the hyperlink, all of a sudden the file location changed. When you try to open the hyperlinks after accessing the worksheet from a different computer, you get the following pop-up:
Imgur: The most awesome images on the Internet
And clicking on 'Yes' gives you:
Imgur: The most awesome images on the Internet
Am I doing something wrong here? Is it our network? Is there a better way to accomplish my goal without using the hyperlink function? Any guidance you guys have is greatly appreciated!
Tyler
As a quick background, my company works in retail construction management. When we are building a new store, we go out to a bunch of plumbers, for example. We'll get a bid from 4 or 5 plumbers on how much it will cost them to do the job.
We keep all of that information on a spreadsheet that has their company and contact information, but also the bid amount. In the office, we are on a shared network, so everyone could open this spreadsheet from their own computer. We occasionally will make the worksheet a shared document so that we can have multiple people editing, but not always. If we don't, a second person could have it open at the same time, but only as "Read-Only".
When we receive a bid, we either get it in PDF format, or scan it and turn it into a PDF. Those bids are then saved on our network.
I was trying to make a way that you could see the bid information without navigating through folders to find the PDF you wanted. My solution to this was to hyperlink the prices, so that when you were in the job spreadsheet, you could click on the price, and the PDF bid would pop up.
Example: Imgur: The most awesome images on the Internet
This worked really great on my computer. When I created it, the hyperlink destination looked like this:
Imgur: The most awesome images on the Internet
But as soon as someone opened it on another computer, everything broke somehow. The hyperlink destination then ended up looking like this:
Imgur: The most awesome images on the Internet
(Ignore the fact that the last part of the file extension, after the 'Bids' folder, is different. I accidentally took screenshots of two different companies)
But as you can see, without moving the location of the PDFs, and without changing the hyperlink, all of a sudden the file location changed. When you try to open the hyperlinks after accessing the worksheet from a different computer, you get the following pop-up:
Imgur: The most awesome images on the Internet
And clicking on 'Yes' gives you:
Imgur: The most awesome images on the Internet
Am I doing something wrong here? Is it our network? Is there a better way to accomplish my goal without using the hyperlink function? Any guidance you guys have is greatly appreciated!
Tyler
